Chapter 9 SQL Statements
503
$ For more information on the use of the SQLDA structure, see "The SQL
descriptor area (SQLDA)" on page 45 of the book ASA Programming
Interfaces Guide.
♦
SQL/92 Part of the SQL/92 standard. Some clauses are vendor
extensions.
♦
Sybase Some clauses supported by Open Client/Open Server.
♦ The following example shows how to use the DESCRIBE statement:
sqlda = alloc_sqlda( 3 );
EXEC SQL DESCRIBE OUTPUT
FOR employee_statement
INTO sqlda;
if( sqlda->sqld > sqlda->sqln ) {
actual_size = sqlda->sqld;
free_sqlda( sqlda );
sqlda = alloc_sqlda( actual_size );
EXEC SQL DESCRIBE OUTPUT
FOR employee_statement
INTO sqlda;
}
Standards and
compatibility
Example