SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—640322-001
2-239
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.