SQL/MX Programming Manual for Java

Sample Programs
HP NonStop SQL/MX Programming Manual for Java—523726-003
C-4
SQLJ Source File
/* The doCATSCH() method creates a catalog and schemas */
void doCATSCH() throws SQLException {
// Creates a catalog
#sql [ctx1] {CREATE CATALOG samdbcat2};
System.out.println("The SAMDBCAT2 catalog was created.");
// Creates schemas
#sql [ctx1] {CREATE SCHEMA samdbcat2.persnl2};
System.out.println("The PERSNL2 schema was created.");
#sql [ctx2] {CREATE SCHEMA samdbcat2.sales2};
System.out.println("The SALES2 schema was created.");
#sql [ctx3] {CREATE SCHEMA samdbcat2.invent2};
System.out.println("The INVENT2 schema was created.");
} // End of doCATSCH() method
/* The doTABLES() method creates tables in
* existing catalogs and schemas */
void doTABLES () throws SQLException {
/* Set the default catalog and schema for a set of
* database objects to be created. */
#sql [ctx1] {DECLARE CATALOG 'SAMDBCAT2'};
#sql [ctx1] {DECLARE SCHEMA 'PERSNL2'};
// Create tables in the schema
#sql [ctx1] {CREATE TABLE employee_internatl
( empnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING 'Employee/Number'
,first_name CHARACTER (15) CHARACTER SET UCS2
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING 'First Name'
,last_name CHARACTER (20) CHARACTER SET UCS2
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING 'Last Name'
,deptnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL NOT DROPPABLE
HEADING 'Dept/Num'
,jobcode NUMERIC (4) UNSIGNED
DEFAULT NULL
HEADING 'Job/Code'
,salary NUMERIC (8,2) UNSIGNED
DEFAULT NULL
HEADING 'Salary'
,PRIMARY KEY (empnum) NOT DROPPABLE
)
};
System.out.println("The EMPLOYEE_INTERNATL table was created.");
Example C-1. SampleDDL.sqlj—Creating Tables From an SQLJ
Program (page 3 of 7)