Passing file name as parameter from a Concurrent Program, to a control file. [message #382442] |
Thu, 22 January 2009 05:54 |
janacallsu
Messages: 6 Registered: December 2006
|
Junior Member |
|
|
Hi guys,
can anyone tell me how to pass file name as a parameter to the control file in SQL loader from a concurrent program?
LOAD DATA
INFILE '%d:\oradev\devappl\ap\11.5.0\bin\%<**file***>'
truncate
INTO TABLE "MHC_INVOICE_TEMP"
WHEN INVOICE_NUMBER!='INVOICE_NUMBER'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
INVOICE_NUMBER,
INVOICE_DATE,
INVOICE_AMOUNT,
CURRENCY,
SUPPLIER_NUMBER
)
I want to pass the file name as parameter to the infile.
Thanks in advance.
Regards,
Jana
|
|
|
|
|