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

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-58
SHOW PREPARED Command
SHOW PREPARED Command
The SHOW PREPARED command is used to display prepared statements in the
current MXCI session.
Use SHOW PREPARED only within an MXCI session.
* | ALL
displays all the currently prepared statements.
See PREPARE Statement on page 2-159.
Examples of SHOW PREPARED
•
Display all currently prepared statements:
>>SHOW PREPARED;
FINDEMP
SELECT * FROM PERSNL.EMPLOYEE WHERE SALARY > 40000.00
AND JOBCODE = 450;
EMPCOM
SELECT FIRST_NAME, LAST_NAME, DEPTNUM FROM PERSNL.EMPLOYEE
WHERE DEPTNUM <> 1500 AND SALARY <= (SELECT AVG(SALARY)
FROM PERSNL.EMPLOYEE WHERE DEPTNUM = 1500);
•
This command also displays all currently prepared statements:
>>SHOW PREPARED *;
FINDEMP
SELECT * FROM PERSNL.EMPLOYEE WHERE SALARY > 40000.00
AND JOBCODE = 450;
EMPCOM
SELECT FIRST_NAME, LAST_NAME, DEPTNUM FROM PERSNL.EMPLOYEE
WHERE DEPTNUM <> 1500 AND SALARY <= (SELECT AVG(SALARY)
FROM PERSNL.EMPLOYEE WHERE DEPTNUM = 1500);
SHOW PREPARED [* | ALL]
Note. The SHOW PREPARED command displays all the currently prepared statements
regardless of whether you specify the * or the ALL option.