Declaration of binary type host variables in C, C++ embedded SQL applications

Binary host variables that you declare in your embedded C and C++ applications are treated as if they were declared in a C or C++ program. You can use host variables to exchange data between the embedded application and the database manager.

The syntax for binary and varbinary locator host variables in C, C++ is:

Example

Declaring:

SQL TYPE IS BINARY(4) myBinField;

Results in the generation of the following C code:

 unsigned char myBinField[4];  

where length  N (1<= N <=255)

Declaring:

SQL TYPE IS VARBINARY(12) myVarBinField;

Results in the generation of the following C code:

struct myVarBinField_t { sqluint16 length; 
char data[12]; 
} myVarBinField;  

Where length is N (1<= N <=32704)