1 Answers
Below is an example to load data into two table in one go
OPTIONS (SKIP=1,READSIZE=1000000, BINDSIZE=1000000,ROWS=200,ERRORS=2000)
LOAD DATA INFILE *
TRUNCATE
INTO TABLE XXCUST.XX_ONE_STG
FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘
TRAILING NULLCOLS
(
item_number “LTRIM(RTRIM(:ITEM_NUMBER))”,
organization_code “LTRIM(RTRIM(:ORGANIZATION_CODE))”
)
INTO TABLE XXCUST.XX_TWO_STG
FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘
TRAILING NULLCOLS
(
item_number “LTRIM(RTRIM(:ITEM_NUMBER))”,
organization_code “LTRIM(RTRIM(:ORGANIZATION_CODE))”
)