MX Release 3.1 (H06.23+, J06.12+)

Considerations

• You must enter the command in one line.

• The command needs an SQL terminator.

• If catalog name is not specified, the command uses the default catalog

NONSTOP_SYSTEM_NSK.

Examples

• The following example illustrates the usage of this command:

SQL>create catalog cat11;

--- SQL operation complete

SQL> fc;

SQL>create catalog cat12;

--- SQL operation complete

SQL>create schema cat1.sch11;

--- SQL operation complete

SQL>set catalog cat11;

--- SQL operation complete

SQL>set schema sch11;

--- SQL operation complete

SQL>create table t(c1 int,c2 int);

--- SQL operation complete

SQL>set catalog cat12;

--- SQL operation complete

SQL>create table t(c1 int, c2 int);

SQL>*** ERROR[1003] Schema CAT12.SCH11 does not exist. [2011-03-31 12:01:07]

SQL>create schema cat12.sch11;

--- SQL operation complete

SQL>create table t(c1 int, c2 int);

--- SQL operation complete

SET COLSEP command

The set colsep command sets the column separator and allows you to control the formatting of

the result displayed for SQL queries. This command specifies a delimiter value to use for separating

columns in each row of the results. The default delimiter is “ ”.

Syntax

SET COLSEP [separator]

84 RMXCI commands