SQLLDR with a constant in the control file
Posted on 2006-10-23
Hi I am trying to setup a control file for sqlldr I write the file just before I do an import so the file is dynamic. When I write the file I want to set one of my parameters to a fixed value somthing like the following:
APPEND INTO TABLE CD.TARGET_LOAD
MY_FIXED_VALUE 911 INTEGER EXTERNAL
MY_NBR POSITION(13:25) INTEGER EXTERNAL
, MY_ID POSITION(324:329) INTEGER EXTERNAL
The My_FIXED_VALUE is the part that doesn't work though what is the proper syntax for this command?