SQL/MP Installation and Management Guide

Performing Recovery Operations
HP NonStop SQL/MP Installation and Management Guide—523353-004
11-22
Recovery Example
4. Re-create the EMPLOYEE table and all its dependent objects:
a. Check that the OBEY (script) command file you maintain for this purpose
contains a SQLCI CREATE command for the EMPLOYEE table and all its
dependent objects.
b. Issue the SQLCI OBEY command to execute the commands in the OBEY
command file. (In this case, the OBEY command file is named DBCREATE.)
>>OBEY DBCREATE
As SQLCI executes the commands, they appear onscreen, along with certain
related messages:
>>?SECTION employee
>> CREATE TABLE =employee (
+> empnum NUMERIC (4) UNSIGNED
+> NO DEFAULT
+> NOT NULL
+> HEADING "Employee/Number"
+> ,first_name CHARACTER (15)
+> DEFAULT SYSTEM
+> NOT NULL
+> HEADING "First Name"
+> ,last_name CHARACTER (20)
+> DEFAULT SYSTEM
+> NOT NULL
+> HEADING "Last Name"
+> ,deptnum NUMERIC (4)
+>. UNSIGNED
+> NO DEFAULT
+> NOT NULL
+> HEADING "Dept/Num"
+> ,jobcode NUMERIC (4) UNSIGNED
+> DEFAULT NULL
+> HEADING "Job/Code"
+> ,salary NUMERIC (8, 2) UNSIGNED
+> DEFAULT NULL
+> HEADING "salary"
+> ,PRIMARY KEY (empnum)
+> )
+> CATALOG =persnl
+> ORGANIZATION KEY SEQUENCED
+> ;
--- SQL operation complete.
>> CREATE VIEW =EMPLIST
+> AS SELECT
+> empnum
+> ,first_name
+> ,last_name
+> ,deptnum
+> ,jobcode
+> FROM =employee
+> FOR PROTECTION
+> CATALOG =persnl
+> ;
--- SQL operation complete.
.
.
.
>> CREATE INDEX =xempname
+> ON =employee (
+> last_name