4.7 SQL Batch Server Response

Server response sent from the server to the client:

 04 01 00 33 00 00 01 00 81 01 00 00 00 00 00 20 
 00 A7 03 00 09 04 D0 00 34 03 62 00 61 00 72 00 
 D1 03 00 66 6F 6F FD 10 00 C1 00 01 00 00 00 00 
 00 00 00
  
   <PacketHeader>
     <Type>
       <BYTE>04 </BYTE>
     </Type>
     <Status>
       <BYTE>01 </BYTE>
     </Status>
     <Length>
       <BYTE>00 </BYTE>
       <BYTE>33 </BYTE>
     </Length>
     <SPID>
       <BYTE>00 </BYTE>
       <BYTE>00 </BYTE>
     </SPID>
     <PacketID>
       <BYTE>01 </BYTE>
     </PacketID>
     <Window>
       <BYTE>00 </BYTE>
     </Window>
   </PacketHeader>
   <PacketData>
     <TableResponse>
       <COLMETADATA>
         <TokenType>
           <BYTE>81 </BYTE>
         </TokenType>
         <Count>
           <USHORT>01 00 </USHORT>
         </Count>
         <ColumnData>
           <UserType>
             <ULONG>00 00 00 00 </ULONG>
           </UserType>
           <Flags>
             <USHORT>20 00 </USHORT>
           </Flags>
           <TYPE_INFO>
             <VARLENTYPE>
               <USHORTLEN_TYPE>
                 <BYTE>A7 </BYTE>
               </USHORTLEN_TYPE>
             </VARLENTYPE>
             <TYPE_VARLEN>
               <USHORTCHARBINLEN>
                 <USHORT>03 00 </USHORT>
               </USHORTCHARBINLEN>
             </TYPE_VARLEN>
             <COLLATION>
               <BYTES>09 04 D0 00 34 </BYTES>
             </COLLATION>
           </TYPE_INFO>
           <ColName>
             <B_VARCHAR>
               <BYTELEN>
                 <BYTE>03 </BYTE>
               </BYTELEN>
               <BYTES ascii="b.a.r.">62 00 61 00 72 00 </BYTES>
             </B_VARCHAR>
           </ColName>
         </ColumnData>
       </COLMETADATA>
       <ROW>
         <TokenType>
           <BYTE>D1 </BYTE>
         </TokenType>
         <TYPE_VARBYTE>
           <TYPE_VARLEN>
             <USHORTCHARBINLEN>
               <USHORT>03 00 </USHORT>
             </USHORTCHARBINLEN>
           </TYPE_VARLEN>
           <BYTES ascii="fio">66 6F 6F </BYTES>
         </TYPE_VARBYTE>
       </ROW>
       <DONE>
         <TokenType>
           <BYTE>FD </BYTE>
         </TokenType>
         <Status>
           <USHORT>10 00 </USHORT>
         </Status>
         <CurCmd>
           <USHORT>C1 00 </USHORT>
         </CurCmd>
         <DoneRowCount>
           <LONGLONG>01 00 00 00 00 00 00 00 </LONGLONG>
         </DoneRowCount>
       </DONE>
     </TableResponse>
   </PacketData>