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

Dynamic SQL

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

9-8

Setting Default Values Dynamically

Use the EXECUTE IMMEDIATE statement to set dynamic SQL default values; for

example, to set the WARN attribute to the default value

iud_nonaudited_index_maint.

Examples

strcpy(hv_sql_statement,"control query default

iud_nonaudited_index_maint 'warn'");

EXEC SQL EXECUTE IMMEDIATE :hv_sql_statement;

move "control query default iud_nonaudited_index_maint

'warn'" to hv-sql-statement.

EXEC SQL EXECUTE IMMEDIATE :hv-sql-statement END-EXEC.

COBOL