SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—544517-008
4-38
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