Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
ESQL/C GuideThe HCL OneDB™ ESQL/C Programmer's Manual explains how to use , the HCL OneDB™ implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities.
Dynamic SQL
An sqlda structureAn sqlda structure is a dynamic-management structure that can hold data that is either returned from or sent to the database server by a prepared statement. It is a C structure defined in the sqlda.h header file.
Manage an sqlda structure
Define an sqlda structureThe sqlda.h header file defines the sqlda structure.

Define an sqlda structure

The sqlda.h header file defines the sqlda structure.

To define an sqlda structure, the program must take the following actions:

Include the sqlda.h header file to provide the declaration for sqlda in your program
The preprocessor automatically includes the sqlhdr.h file, which includes the sqlda.h header file.
Declare a variable name as a pointer to the sqlda structure
The following line of code declares the da_ptr variable as an sqlda pointer:
```
struct sqlda *da_ptr;
```

Important: The pointer to an sqlda structure is not the host variable. Therefore, you do not need to precede the statement declaration with either the keywords EXEC SQL or a dollar ($) symbol. Furthermore, in the program blocks you do not precede any references to the pointer with a colon (:) or a dollar ($) symbol.