-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 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
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*