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

MXCI Commands

HP NonStop SQL/MX Reference Manual—540440-003

4-19

Examples of DISPLAY_QC

>>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.

>>DISPLAY_QC;

AVGSIZE CURSIZE MAXSIZE NPINNED NRECOM NRETR NCACHE NHITS

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

31 35 1024 0 0 0 1 0

--- SQL operation complete.