SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Performing Recovery Operations
HP NonStop SQL/MX Installation and Management Guide—523723-004
12-16
Recovering Tables
With the SAVE_DROPPED_TABLE_DDL attribute set ON, the script for
re-creating the table is saved in the OSS directory /usr/tandem/sqlmx/ddl in
the file HRDATA.PERSNL.EMPLOYEE-20031114-160629.ddl. Issue an MXCI
OBEY command to execute the commands in this file from a licensed MXCI
process:
>>OBEY /USR/TANDEM/SQLMX/DDL/HRDATA.PERSNL.EMPLOYEE
+>-20031114-160629.DDL;
As MXCI executes the commands, they appear on your screen, along with certain
related messages:
>>CREATE TABLE HRDATA.PERSNL.EMPLOYEE
+>(
+> EMPNUM NUMERIC(4, 0) UNSIGNED NO DEFAULT HEADING
+> ‘Employee/Number’ -- NOT NULL NOT DROPPABLE
+>,FIRST_NAME CHAR(15) CHARACTER SET ISO88591 COLLATE
+> DEFAULT DEFAULT_ISO88591 ‘ ‘ HEADING ‘First Name’
+> -- NOT NULL NOT DROPPABLE
+>,LAST_NAME CHAR(20) CHARACTER SET ISO88591 COLLATE
+> DEFAULT DEFAULT_ISO88591 ‘ ‘ HEADING ‘Last Name’
+> -- NOT NULL NOT DROPPABLE
+>,DEPTNUM NUMERIC(4, 0) UNSIGNED NO DEFAULT HEADING
+> ‘Dept/Num’ -- NOT NULL NOT DROPPABLE
+>,JOBCODE NUMERIC(4, 0) UNSIGNED DEFAULT NULL
+> HEADING ‘Job Code’
+>,SALARY NUMERIC(8, 2) UNSIGNED DEFAULT NULL
+>,CONSTRAINT HRDATA.PERSNL.EMPLOYEE_428832188_2424 PRIMARY KEY(EMPUM ASC)
+> NOT DROPPABLE
+>,CONTRAINT HRDATA.PERSNL.EMPLOYEE_133512188_2424 CHECK
+> (HRDATA.PERSNL.EMPLOYEE.EMPNUM IS NOT NULL AND
+> HRDATA.PERSNL.EMPLOYEE.FIRST_NAME IS NOT NULL AND
+> HRDATA.PERSNL.EMPLOYEE.LAST_NAME IS NOT NULL AND
+> HRDATA.PERSNL.EMPLOYEE.DEPTNUM IS NOT NULL) NOT DROPPABLE
+>)
+> LOCATION \KRYPTON.$DATA10.ZSDT5356.NG59FJ00
+> NAME KRYPTON_DATA10_ZSDT5356_NG59FJ00
+> STORE BY (EMPNUM ASC)
+> ;
--- SQL operation complete.
>>CREATE INDEX XEMPNAME ON HRDATA.PERSNL.EMPLOYEE
+>(
+> LAST_NAME ASC, FIRST_NAME ASC
+>)
+>LOCATION \KRYPTON.$DATA10.ZSDT5356.JN9V5J00
+>NAME KRYPTON_DATA10.ZSDT5356_JN9V5J00
+>;
-- SQL operation complete.
>>CREATE INDEX XEMPDEPT ON HRDATA.PERSNL.EMPLOYEE
+>(
+> DEPTNUM ASC
+>)
+>LOCATION \KRYPTON.$DATA10.ZSDT5356.NPFH8J00
+>NAME KRYPTON_DATA10_ZSDT5356_NPFH8J00
+>;
--- SQL operation complete.