Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
DESCRIBE INPUT statementUse the DESCRIBE INPUT statement to return input parameter information before a prepared statement is executed.
Using the INTO sqlda Pointer Clause

Using the INTO sqlda Pointer Clause

The INTO sqlda_pointer clause allocates memory for an sqlda structure and store its address in an sqlda pointer. The DESCRIBE INPUT statement fills in the allocated memory with descriptive information.

The DESCRIBE INPUT statement sets the sqlda.sqld field to the number of values in the statement list. The sqlda structure also contains an array of data descriptors (sqlvar structures), one for each value in the statement list. After a DESCRIBE statement is executed, the sqlda.sqlvar structure has the sqltype, sqllen, and sqlname fields set.

If the column has an opaque data type, DESCRIBE INPUT . . . INTO sets the sqlxid, sqltypename, sqltypelen, sqlownerlen, and sqlownername fields of the item descriptor.

The DESCRIBE INPUT statement allocates memory for an sqlda pointer once it is declared in a program. The application program, however, must designate the storage area of the sqlda.sqlvar.sqldata fields.