Sqlldr and Control file
I am trying to pass the data file name as a concurrent program parameter to a shell program and I am passing this file to sqlldr command line argument
as
sqlldr $FCP_LOGIN control=$XXASC_TOP/bin/${control_file} data=$SOURCE_PATH$FILE_NAME1 log=$SOURCE_PATH$LOG_FILE$timestamp.log errors=0
The control file is :
OPTIONS (SKIP=1)
LOAD DATA
INFILE *
BADFILE '/u01/oracle/AMALTEST/apps/apps_st/appl/xxasc/12.0.0/inbound/ar/Customer.bad'
BADFILE '/u01/oracle/AMALTEST/apps/apps_st/appl/xxasc/12.0.0/inbound/ar/Customer.dis'
APPEND
INTO TABLE "AR"."RA_CUSTOMERS_INTERFACE_ALL"
FIELDS TERMINATED BY ','