
MXCS Commands and Objects
SQL/MX Connectivity Service Administrative Command Reference—526350-005
2-12
MXCI Mode Command
MXCI Mode Command
The MXCI MODE command directs all subsequent commands to the MXCS command
library. To enter the MXCS mode, enter:
>>mode mxcs;
CS>
To indicate the session is in MXCS mode, the prompt changes to CS>.The prompt for
continuation lines is the normal +> for all modes. The mode prompt of CS persists until
the mode is reset. Use CS as the prompt for connection services commands.
To end the MXCS mode, enter:
To determine the active mode, enter:
CS>mode display;
For an example session, see Appendix A, Example Commands and Objects.
If there is an SQL transaction in progress and not yet committed, the mode switch to
mode mxcs is not permitted. To enter MXCS administrative commands in this
situation, start a second instance of MXCI.
Session Variables
Do not use the TACL DEFINE command or OSS shell environment variables to define
session variables. These are not expanded in the input command by MXCI or MXCS.
MXCI Comment
An MXCI comment:
Begins with two hyphens (--) and ends at the end of the line
Can be on a line by itself or it can follow command text
Can be embedded in multiline input provided it is outside of keywords and literals
cs>mode sql; Return to SQL/MX mode; the default at MXCI start.
CS>mode report; Go to report writer mode.
CS>exit; Terminate MXCI.
Kommentare zu diesen Handbüchern