SQL/MP Installation and Management Guide

Performing Recovery Operations
HP NonStop SQL/MP Installation and Management Guide—523353-004
11-23
Recovery Example
+> ,first_name
+> )
+> CATALOG =persnl
+> ;
--- SQL operation complete.
.
.
.
>> CREATE INDEX =xempdept
+> ON =employee (
+> deptnum
+> )
+> CATALOG =persnl
+> ;
--- SQL operation complete.
.
.
.
>> CREATE VIEW =mgrlist (
+> first_name
+> ,last_name
+> ,department
+> )
+> AS SELECT
+> first_name
+> ,last_name
+> ,deptname
+> FROM
+> =dept
+> ,=employee
+> WHERE
+> dept.manager = employee.empnum
+> CATALOG =persnl
+> ;
--- SQL operation complete.
.
.
.
>> CREATE VIEW =ordrep
+> AS SELECT empnum
+> ,last_name
+> ,ordernum
+> ,o.custnum
+> FROM
+> =employee e
+> ,=orders o
+> ,=customer c
+> WHERE
+> e.empnum = o.salesrep
+> AND
+> o.custnum = C.custnum
+> CATALOG =sales
+> ;
--- SQL operation complete.
.
.
.
5. Verify that all the objects have been re-created by issuing the SQLCI DISPLAY
USE OF command:
>> DISPLAY USE OF $DATA.PERSNL.EMPLOYEE;