Hi All,

Below is my control file and I'm trying to load multiple csv files in to single table.

OPTIONS (SKIP=1)
LOAD DATA  
CHARACTERSET WE8ISO8859P1
--infile '/home/applmgr/harish/Ringgold_Files/PROQ_*.csv'
--BADFILE '/home/applmgr/harish/Ringgold_Files/rg.bad'
--DISCARDFILE '/home/applmgr/harish/Ringgold_Files/rg.ds'
APPEND INTO TABLE XXPQ_RG_SUBS_FULL                                   
FIELDS TERMINATED BY ',' optionally enclosed by '"'
TRAILING NULLCOLS                                                 
(                  
   RG_NUMBER                        DECIMAL EXTERNAL NULLIF (RG_NUMBER=BLANKS)  
 , RG_NAME                          CHAR NULLIF (RG_NAME=BLANKS)     
 , PARENT_COUNTRY                   CHAR NULLIF (PARENT_COUNTRY=BLANKS)         
 , PARENT_TIER                      CHAR NULLIF (PARENT_TIER=BLANKS) 
 , TOP_LEVEL_RIN                    DECIMAL EXTERNAL NULLIF (TOP_LEVEL_RIN=BLANKS) 
 , TOP_LEVEL_NAME                   CHAR NULLIF (TOP_LEVEL_NAME=BLANKS)    
 , TOP_PARENT_COUNTRY               CHAR NULLIF (TOP_PARENT_COUNTRY=BLANKS)         
 , SUBSCRIBER_NUMBER                CHAR NULLIF (SUBSCRIBER_NUMBER=BLANKS)      
 , SUBSCRIBER_NAME                  CHAR NULLIF (SUBSCRIBER_NAME=BLANKS)   
 , CREATED_BY                       CONSTANT '1' 
 , CREATED_DATE                     SYSDATE        
 , LAST_UPDATED_BY                  CONSTANT '1'     
 , LAST_UPDATE_DATE                 SYSDATE  
)

Below is the batch file

for %f in /home/applmgr/harish/Ringgold_Files/*.csv do \
sqlldr xxx/xxx@ebsua' DATA=%f \
CONTROL=xxpq_rg_subs.ctl LOG=/home/applmgr/harish/Ringgold_Files/rg.log  \
BAD=/home/applmgr/harish/Ringgold_Files/rg.bad skip=1 

I keep encountering below error.COuld you please suggest what change needs to be done in the batch file.

[applmgr@ebs203 Ringgold_Files]$ rg.bat
./rg.bat: line 5: syntax error: unexpected end of file