4.5 SQL Batch Server Response

  • Article

The following is an example of the server response that is sent from the server to the client. 

  
 04 01 00 26 00 33 01 00 A0 05 00 04 63 6F 6C 31
 A1 05 00 07 00 08 00 38 D1 01 00 00 00 FD 10 00
 C1 00 01 00 00 00 
   <PacketHeader>
     <Type>
       <BYTE>04 </BYTE>
     </Type>
     <Status>
       <BYTE>01 </BYTE>
     </Status>
     <Length>
       <BYTE>00 </BYTE>
       <BYTE>26 </BYTE>
     </Length>
     <SPID>
       <BYTE>00 </BYTE>
       <BYTE>00 </BYTE>
     </SPID>
     <Packet>
       <BYTE>01 </BYTE>
     </Packet>
     <Window>
       <BYTE>00 </BYTE>
     </Window>
   </PacketHeader>
   <PacketData>
     <TableResponse>
       <COLNAME>
         <TokenType>
           <BYTE>A0 </BYTE>
         </TokenType>
         <Length>
           <USHORT>05 00 </USHORT>
         </Length>
         <ColName>
           <B_VARCHAR>
             <BYTE>04 </BYTE>
             <BYTES ascii="col1">63 6F 6C 31 </BYTES>
           </B_VARCHAR>
         </ColName>
       </COLNAME>
       <COLFMT>
         <TokenType>
           <BYTE>A1 </BYTE>
         </TokenType>
         <Length>
           <USHORT>05 00 </USHORT>
         </Length>
         <ColumnData>
           <UserType>
             <USHORT>07 00 </USHORT>
           </UserType>
           <Flags>
             <USHORT>08 00 </USHORT>
           </Flags>
           <TYPE_INFO>
             <FIXEDLENTYPE>
               <BYTE>38 </BYTE>
             </FIXEDLENTYPE>
           </TYPE_INFO>
         </ColumnData>
       </COLFMT>
       <ROW>
         <TokenType>
           <BYTE>D1 </BYTE>
         </TokenType>
         <TYPE_VARBYTE>
           <BYTES>01 00 00 00 </BYTES>
         </TYPE_VARBYTE>
       </ROW>
       <DONE>
         <TokenType>
           <BYTE>FD </BYTE>
         </TokenType>
         <Status>
           <USHORT>10 00 </USHORT>
         </Status>
         <CurCmd>
           <USHORT>C1 00 </USHORT>
         </CurCmd>
         <DoneRowCount>
           <LONG>01 00 00 00 </LONG>
         </DoneRowCount>
       </DONE>
     </TableResponse>
   </PacketData>