SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
2-283
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.