SQL/MX 2.x Reference Manual (H06.04+)

MXCI Commands

HP NonStop SQL/MX Reference Manual—540440-003

4-21

Examples of DISPLAY_QC_ENTRIES

>>SET SCHEMA SAMDBCAT.PERSNL;

--- SQL operation complete.

>SELECT * FROM EMPLOYEE;

Employee/Number First Name Last Name Dept/Num Job/Code Salary

-------------- -------------- -------------- -------- -------- ---------

1 ROGER GREEN 9000 100 175500.00

23 JERRY HOWARD 1000 100 137000.10

29 JANE RAYMOND 3000 100 136000.00

--- 62 row(s) selected.

>SELECT * FROM DEPT;

Dept/Num Dept/Name Mgr Rpt/Dept Location

-------- ------------ ----- -------- ------------------

1000 FINANCE 23 9000 CHICAGO

1500 PERSONNEL 213 1000 CHICAGO

2000 INVENTORY 32 9000 LOS ANGELES

--- 12 row(s) selected.

>SELECT * FROM JOB;

Job/Code Job Description

-------- ------------------

100 MANAGER

200 PRODUCTION SUPV

250 ASSEMBLER

--- 10 row(s) selected.

>>DISPLAY_QC_ENTRIES;

ROWID TEXT NUMHITS PH COMPTIME AVGHTIME

------- --------------------------------- -------- -- -------- --------

0 select * from job; 0 B 88 0

1 select * from dept; 0 B 115 0

2 select * from employee; 0 B 1605 0

--- SQL operation complete.