SQL/MX 2.x Reference Manual (H06.04+)

Embedded-Only SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
3-17
C Examples of DEALLOCATE DESCRIPTOR
C Examples of DEALLOCATE DESCRIPTOR
•
This example uses an SQL string literal as the descriptor name:
EXEC SQL DEALLOCATE DESCRIPTOR 'in_sqlda';
•
This example uses a host variable as the descriptor name:
...
EXEC SQL BEGIN DECLARE SECTION;
char desc_name[20];
long desc_max;
...
EXEC SQL END DECLARE SECTION;
...
strcpy(desc_name, "in_sqlda");
...
desc_max = 10;
EXEC SQL ALLOCATE DESCRIPTOR :desc_name WITH MAX :desc_max;
...
EXEC SQL DEALLOCATE DESCRIPTOR :desc_name;
COBOL Examples of DEALLOCATE DESCRIPTOR
•
This example uses an SQL string literal as the descriptor name:
EXEC SQL DEALLOCATE DESCRIPTOR 'in_sqlda' END-EXEC.
•
This example uses a host variable as the descriptor name:
...
EXEC SQL BEGIN DECLARE SECTION END-EXEC.
01 desc-name PIC X(20).
01 desc-max PIC S9(9) comp.
...
EXEC SQL END DECLARE SECTION END-EXEC.
...
MOVE "in_sqlda" TO desc-name.
...
MOVE 10 TO desc-max.
EXEC SQL ALLOCATE DESCRIPTOR :desc-name
WITH MAX :desc-max END-EXEC.
...
EXEC SQL DEALLOCATE DESCRIPTOR :desc-name END-EXEC.