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

Dynamic SQL With Descriptor Areas

HP NonStop SQL/MX Programming Manual for C and COBOL—523627-004

10-21

Using SQL Descriptor Areas to Select SQL/MP

KANJI and KSC5601 Data

Example

EXEC SQL DEALLOCATE PREPARE sqlstmt;

...

EXEC SQL DEALLOCATE DESCRIPTOR 'in_sqlda';

EXEC SQL DEALLOCATE DESCRIPTOR 'out_sqlda';

Using SQL Descriptor Areas to Select SQL/MP

KANJI and KSC5601 Data

See Example A-9 on page A-28 and Example A-10 on page A-30 for a detailed

example.

Using SQL Descriptor Areas to Retrieve

ISO88591 Data to UCS2 Host Variables

See Example A-11 on page A-35 for a dynamic SQL descriptor example that retrieves

ISO88591 data to UCS2 host variables.