-SETA (SET CURRENT SCHEMA statement)

The -SETA command sets the schema creator for SQL statements.

The command also records the schema creator when the Execution component restarts a worklist. After the object is created, the -SETA command sets the schema creator to the default for subsequent -SQL commands.

Example of -SETA command

-SETS 000550 SET CURRENT SQLID = 'J1OSS9A'
-SETA 000600 SET CURRENT SCHEMA = 'J1CSS9A'
-SQL 000650 CREATE TABLE T_T03MSEG_B
(
  COLSI_2
     SMALLINT NOT NULL WITH DEFAULT
, COLIN_1
     INTEGER NOT NULL WITH DEFAULT
    1
, COLIN_3
     INTEGER NOT NULL WITH DEFAULT
, COLDT_9
     DATE NOT NULL WITH DEFAULT
    '1961-05-06'
, COLTS_11
     TIMESTAMP NOT NULL GENERATED BY DEFAULT
      FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP
)
                    CCSID EBCDIC
  IN J1SS9A.T03MSEG

-SQL 000700 CREATE TABLE T_T03MSEG_A
(
  COLSI_2
     SMALLINT NOT NULL WITH DEFAULT
, COLIN_1
     INTEGER NOT NULL WITH DEFAULT
    1
, COLIN_3
     INTEGER NOT NULL WITH DEFAULT
, COLDT_9
     DATE NOT NULL WITH DEFAULT
    '1961-05-06'
, COLTS_11
     TIMESTAMP NOT NULL GENERATED BY DEFAULT
      FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP
)
                    CCSID EBCDIC
  IN J1SS9A.T03MSEG

-SETA 000750 SET CURRENT SCHEMA = DEFAULT
-SETS 000800 SET CURRENT SQLID = USER
-SYNC 000850 END OF TABLE SECTION

-SETA (SET CURRENT SCHEMA statement)

On this page