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

MXCI Commands
HP NonStop SQL/MX Reference Manual—544517-008
4-37
Considerations for LOG
Considerations for LOG
Contents of the Log File
The log file includes all lines you enter except FC editing lines, including the final
version of any line you edit by using FC. It also includes the prompts for lines that you
enter and all text that MXCI displays or prints in response to those lines, including
output from commands and diagnostic messages—except for output from the CD, FC,
HISTORY, LS, SH, GTACL, and ! commands.
Concurrent MXCI Sessions
If two or more concurrent MXCI sessions use the same log_file name in a LOG
command, each MXCI session writes information to the same log file. After the log file
is closed, you cannot determine which information was written by each MXCI session.
To ensure that log information is retained for a session, use a unique name for each
log file.
Examples of LOG
•
Start logging only commands to an OSS text file in the current directory, clearing
the file first:
>>LOG myfile COMMANDS CLEAR;
•
Stop logging:
>>LOG;
•
Start logging with CLEAR option:
>>LOG myfile CLEAR;
>>select * from mytable;
>>select * from tab;
>>LOG;
The log file displays the following information:
>>select * from mytable;
I
-----------
1
2
3
4
5
--- 5 row(s) selected.
>>select * from tab;
*** ERROR[4082] Table, view or stored procedure CAT.SCH.TAB
does not exist or is inaccessible.