Hello,

I have a ksh file that calls sqlldr to load a file into a staging table.
I need to be able to send the delimiter (which is pipe in this case) as a parameter in the sqlldr command to the control file.
So in other words, I don't want the delimiter to be hardcoded in the control file (FIELDS TERMINATED BY '|'), instead I need it to be defined as a variable in the control file and specified as a parameter in the ksh file.

Is that possible?
Your help is much appreciated.

Sample ksh file:

#!/bin/ksh
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export ORACLE_BIN=$ORACLE_HOME/bin
export DBCONN=username/password

$ORACLE_BIN/sqlldr $DBCONN data=filename.dat control=filename.ctl log=filename.log skip=1 direct=true

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Sample Control file:

load data
truncate
into table stg_table
FIELDS TERMINATED BY '|' TRAILING NULLCOLS
(field1 "trim( both '\"' from :field1)",
field2 "trim( both '\"' from :field2)",
field3 "trim( both '\"' from :field3)"
)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Sample data file (filename.dat):

"Column1"|"Column2"|"Column3"
"value1"|"value2"|"value3"