Passing custom parameters to SQL Loader

[cidoni]

Is it possible to pass parameters to the sqlloader and use them inside the control file?
something like,
>sqlldr .... empid=123

and inside the control file, i want to use the empid to be inserted to a table.
How can I use it inside the control file along with LOAD DATA?

thanks in advance,
cidoni

 

[Wonboodoo]

I think (not entirely sure) that you can use environment variables in the control file. At least for Unix, but probably for Winblows too. You can set the variable before you call SQL*Ldr.