SQL/MX Programming Manual for C and COBOL (G06.24+, H06.03+)

C Sample Programs
HP NonStop SQL/MX Programming Manual for C and COBOL—523627-004
A-8
Using SQL Descriptor Areas With DESCRIBE
Example A-4. Using SQL Descriptor Areas With DESCRIBE (page 1 of 4)
/* ---------------------------------------------------------
Description: Using Descriptor Areas With DESCRIBE
Statements: ALLOCATE DESCRIPTOR
SELECT
PREPARE
DESCRIBE
SET DESCRIPTOR
EXECUTE
GET DESCRIPTOR
DEALLOCATE PREPARE
DEALLOCATE DESCRIPTOR
WHENEVER
GET DIAGNOSTICS
------------------------------------------------------------ */
#include <stdio.h>
#include <string.h>
EXEC SQL MODULE EXF111M NAMES ARE ISO88591;
int main()
{
char SQLSTATE_OK[6]="00000";
EXEC SQL BEGIN DECLARE SECTION;
char SQLSTATE[6];
unsigned NUMERIC (4) hv_empnum; /* Employee table */
char hv_first_name[16];
char hv_last_name[21];
unsigned NUMERIC (4) hv_deptnum;
unsigned NUMERIC (4) hv_jobcode;
short hv_jobcode_i;
unsigned NUMERIC (8,2) hv_salary;
short hv_salary_i;
unsigned NUMERIC (4) in_empnum;
char in_columns[80];
char hv_sql_stmt[256];
long hv_desc_max;
long hv_desc_value;
VARCHAR sqlda_name[129]; /* NAME in SQL */
/* descriptor area*/
long hv_num; /* Statement info */
long i; /* Used for condition loop */
char hv_sqlstate[6]; /* Condition info */
VARCHAR hv_tabname[129];
VARCHAR hv_colname[129];
VARCHAR hv_msgtxt[129];
EXEC SQL END DECLARE SECTION;