Re: Loading Constant Date

LOAD DATA
INFILE 'abagcus2.txt'
replace INTO TABLE RA_CUSTOMERS_INTERFACE_ALL FIELDS TERMINATED BY '","' TRAILING NULLCOLS (
ORIG_SYSTEM_CUSTOMER_REF,CUSTOMER_NAME,ADDRESS1, ADDRESS2,ADDRESS3,ADDRESS4,CITY,STATE,
POSTAL_CODE,COUNTRY,INSERT_UPDATE_FLAG,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
CREATED_BY,CREATION_DATE,CUSTOMER_CATEGORY_CODE, CUSTOMER_STATUS,ORIG_SYSTEM_ADDRESS_REF, PRIMARY_SITE_USE_FLAG,SITE_USE_CODE,
CUSTOMER_TYPE
)

in your data file
for the corresponding DATE fields would be stored and entered as:

"-1","15-AUG-02","-1","15-AUG-02"," good luck

george Received on Thu Aug 22 2002 - 23:16:23 CEST