SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—523725-004

2-213

MXCI Examples of SET CATALOG

•

Set the default catalog name:

SET CATALOG mycatalog;

C Example of SET CATALOG

•

Set the default catalog name with an SQL string literal:

EXEC SQL SET CATALOG 'mycatalog';

•

Set the default catalog name with an SQL identifier:

EXEC SQL SET CATALOG mycatalog;

COBOL Example of SET CATALOG

•

Set the default catalog name with an SQL string literal:

EXEC SQL SET CATALOG 'mycatalog' END-EXEC.

•

Set the default catalog name with an SQL identifier:

EXEC SQL SET CATALOG mycatalog END-EXEC.