SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

MXCI Commands
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
4-49
Examples of LOG
*** ERROR[8822] The statement was not prepared.
>>LOG;
•
Start logging only commands:
>>LOG myfile COMMANDS CLEAR;
>>select * from mytable;
>>select * from tab;
>>LOG;
The log file displays the following information:
>>select * from mytable;
>>select * from tab;
>>LOG;
•
Start logging using RESULT option:
>>LOG myfile RESULT CLEAR;
>>select * from mytable;
>>select * from tab;
>>LOG;
The log file displays the following information:
I
-----------
1
2
3
4
5
--- 5 row(s) selected.
*** ERROR[4082] Table, view or stored procedure CAT.SCH.TAB
does not exist or is inaccessible.
*** ERROR[8822] The statement was not prepared.
•
Start logging using RESULT and ONLY options:
>>LOG myfile RESULT ONLY CLEAR;
>>select * from mytable;
>>select * from tab;
>>LOG;
The log file displays the following information:
1
2
3
4
5