SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-370
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.