-- Sample control file
Options (Skip =2)
Load data
infile '$XBOL_TOP/bin/xe.csv'
badfile '$XBOL_TOP/bin/xe.bad'
discardfile '$XBOL_TOP/bin/xe.dis'
insert into table xxgl_exchange_rates_stg
fields terminated by ','
optionally enclosed by '"'
Trailing nullcols
(from_currency
,amount
,from_conversion_date
,to_currency
,conversion_rate)
Options (Skip =2)
Load data
infile '$XBOL_TOP/bin/xe.csv'
badfile '$XBOL_TOP/bin/xe.bad'
discardfile '$XBOL_TOP/bin/xe.dis'
insert into table xxgl_exchange_rates_stg
fields terminated by ','
optionally enclosed by '"'
Trailing nullcols
(from_currency
,amount
,from_conversion_date
,to_currency
,conversion_rate)
No comments:
Post a Comment