DROP TABLE TRAFODION.MXOLTP.TBL500;
CREATE TABLE TRAFODION.MXOLTP.TBL500
(
CNT INT UNSIGNED NO DEFAULT NOT NULL
, COL1 INT UNSIGNED NO DEFAULT NOT NULL
, COL2 INT UNSIGNED NO DEFAULT NOT NULL
, COL3 INT UNSIGNED NO DEFAULT NOT NULL
, COL4 INT UNSIGNED NO DEFAULT NOT NULL
, COL5 INT UNSIGNED NO DEFAULT NOT NULL
, COL6 INT UNSIGNED NO DEFAULT NOT NULL
, COL7 INT UNSIGNED NO DEFAULT NOT NULL
, COL10 CHAR(468) NO DEFAULT NOT NULL
, PRIMARY KEY (CNT ASC)
) SALT USING 20 PARTITIONS
;
exit
The update command used is in the code above.
up_col1 = 11;
up_col2 = 22;
DROP TABLE TRAFODION. MXOLTP. TBL500; MXOLTP. TBL500
CREATE TABLE TRAFODION.
(
CNT INT UNSIGNED NO DEFAULT NOT NULL
, COL1 INT UNSIGNED NO DEFAULT NOT NULL
, COL2 INT UNSIGNED NO DEFAULT NOT NULL
, COL3 INT UNSIGNED NO DEFAULT NOT NULL
, COL4 INT UNSIGNED NO DEFAULT NOT NULL
, COL5 INT UNSIGNED NO DEFAULT NOT NULL
, COL6 INT UNSIGNED NO DEFAULT NOT NULL
, COL7 INT UNSIGNED NO DEFAULT NOT NULL
, COL10 CHAR(468) NO DEFAULT NOT NULL
, PRIMARY KEY (CNT ASC)
) SALT USING 20 PARTITIONS
;
exit
The update command used is in the code above.
up_col1 = 11;
up_col2 = 22;