Re: SQL*Loader - Input Parameter

write a script which generates the control file. Otherwise the only option is edit the control file.

Hth,

Sybrand Bakker, Oracle DBA

Malka Friedman <malkaf_at_amdocs.com> schreef in berichtnieuws 958637165.942559_at_soint7...
> Hello,
>
> I have to create a CTL that will load a file into a table, and into one of
> the fields it will insert constant according to an input parameter - I
 have
> to load several times and each time with diffeent value.
> Example:
> INSERT
> INTO TABLE CUST
> (
>
> RECORD_TYPE DEFAULT %1 // Thats what I
 am
> imagine...:-), How can it be done?
> EMP_NUM POSITION(5:14) INTEGER EXTERNAL
> EMP_NAME POSITION(15:23) CHAR
> NULLIF ( LEGACY_CORPORATE_CD = BLANKS ),
> EMP_LAST_NAME POSITION(24:31) CHAR
> NULLIF ( LEGACY_REPORTING_CD = BLANKS ),
> )
>
> Please help,
> It is very urgent,
> Malka
>
>
>
Received on Thu May 18 2000 - 00:00:00 CEST