| SQLLDR [message #179485] |
Tue, 27 June 2006 11:11  |
Pallavi123
Messages: 3
Registered: June 2006
|
Junior Member |
|
|
My SQLLDR INFILE name is appended with current date evryday.
How do I specify the INFILE attribute dynamically in the control file?
|
|
|
|
| Re: SQLLDR [message #179490 is a reply to message #179485] |
Tue, 27 June 2006 12:12  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
You can run sqlldr with all the parameters on the command line such as:
sqlldr control=foo.ctl data=foo.`date +%m%d%y` bad=...etc.
|
|
|
|
|
|
| Re: SQLLDR [message #179521 is a reply to message #179500] |
Tue, 27 June 2006 16:24 |
Pallavi123
Messages: 3
Registered: June 2006
|
Junior Member |
|
|
Can I use a wildcard character in the DATA file.
I use this in a batch file:
sqlldr USERID=... CONTROL=.. DATA=XYZ%DATE%*.*
This throws an error
SQL*Loader-500: Unable to open file XYZ06272006*.*
Is there any workaround?
Thanks.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
