SQLDA Data Structure

Embedded SQL for C and SQL Server

Embedded SQL for C and SQL Server

SQLDA Data Structure

The SQLDA data structure definition (from Sqlda.h) looks like this:

// SQL Descriptor Area - SQLDA
struct sqlda
{
   
 
unsigned char sqldaid[8];
// Eye catcher = 'SQLDA  '
 
long sqldabc;
// SQLDA size in bytes = 16+44*SQLN
 
short sqln;
// Number of SQLVAR elements
 
short sqld;
// Num of used SQLVAR elements
 
struct sqlvar
 
 
{
 
 
   short sqltype;
// Variable data type
 
   short sqllen;
// Variable data length
// Maximum amount of data < 32K
 
   unsigned char FAR
 
 
      *sqldata;
// Pointer to variable data value
 
   short FAR *sqlind;
// Pointer to null indicator
 
   struct sqlname
// Variable name
 
   {
 
 
      short length;
// Name length [1..30]
 
      unsigned char
 
 
         data[30];
// Variable or column name
 
   } sqlname;
 
 
} sqlvar[1];
 
};