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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-217
MXCI Examples of SET SCHEMA
MXCI Examples of SET SCHEMA
•
Set the default schema name:
SET SCHEMA myschema;
•
Set the default catalog and schema name by specifying both:
SET SCHEMA mycatalog.myschema;
C Example of SET SCHEMA
•
Set the default catalog and schema with an SQL string literal:
EXEC SQL SET SCHEMA 'prodcat.persnl';
•
Set the default catalog and schema with an SQL identifier:
EXEC SQL SET SCHEMA prodcat.persnl;
COBOL Example of SET SCHEMA
•
Set the default schema with an SQL string literal:
EXEC SQL SET SCHEMA 'prodcat.persnl' END-EXEC.
•
Set the default schema with an SQL identifier:
EXEC SQL SET SCHEMA prodcat.persnl END-EXEC.