Load type custom
Posted: Tue May 27, 2003 7:05 am
Hi all,
I would like to assign the value Current_Timestamp directly at the level of the loading stage. My first attempt of replacing the value ":MOD_DT_TM" by Current_Timestamp resulted in an error.
Mload Script:
dml label tdmload do update the existing rows;
UPDATE #ThisDataBase#.#Table#
SET EMAIL_ADDR = :EMAIL_ADDR,
MOD_DT_TM = current_timestamp
WHERE CUST_ACCT_ID = :CUST_ACCT_ID;
import INFILE #FilePath#/Dly/multiload/#ThisJob# format fastload
layout internal apply tdmload;
Thanks
MAT
I would like to assign the value Current_Timestamp directly at the level of the loading stage. My first attempt of replacing the value ":MOD_DT_TM" by Current_Timestamp resulted in an error.
Mload Script:
dml label tdmload do update the existing rows;
UPDATE #ThisDataBase#.#Table#
SET EMAIL_ADDR = :EMAIL_ADDR,
MOD_DT_TM = current_timestamp
WHERE CUST_ACCT_ID = :CUST_ACCT_ID;
import INFILE #FilePath#/Dly/multiload/#ThisJob# format fastload
layout internal apply tdmload;
Thanks
MAT