Inputs to SQL Loader [message #650728] |
Mon, 02 May 2016 07:04 |
|
Arunpandi
Messages: 4 Registered: March 2016
|
Junior Member |
|
|
Hi,
Can anyone say how to give inputs to ctl file?
For Example :
File having like this
<country_code1>_<SYSDATE>.dat
<country_code2>_<SYSDATE>.dat
<country_code3_<SYSDATE>.dat
<country_code4_<SYSDATE>.dat
<country_code5>_<SYSDATE>.dat
i am going to insert in the table
T_COUNTRY_DATE
My Loading Script : (As of now)
LOAD DATA
APPEND
INTO TABLE T_COUNTRY_DATE
FIELDS TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
COUNTRY_CODE CONSTANT "<COUNTRY_CODE>",
....
....
....
....
)
Currently we have separate ctl file to load the data with respective country code.
But i don't want like this. Changes in these import making big head ache.
Is there any way to use only one ctl file to upload these files in to single table with their respective COUNTRY_CODE?
Thanks in advance.
|
|
|
|
|