-
SQL*Loader with parameters?
I have a Linux script that will run SQL*Loader daily to load a file. Each record loaded from that file must be assigned a batch ID, which is determined from a sequence. The batch ID is constant for each load, so that all of day 1's records are batch 1, day 2's are batch 2, etc.
Once I select the batch ID from the sequence, is there a way to pass that value to SQL*Loader at the command line in order to use it to load the records? I know I can dynamically rebuild the control file each time and use a constant, but I'm just wondering whether there is a more straightforward method.
TIA for any advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|