Re: Help SQL*Loader

In article <3ro3ds$3j1_at_alfa02.Medio.Net>, JKudebeh_at_medio.net (Jim Kudebeh) says:
>
>We are running Oracle V7.x under Open VMS.
>
>Is it possible to pass either a logical or a symbol to a CONSTANT
>field in SQL*loader from a *.COM file? I have been successfull in
>defineing a data file in a logical for the filename in the INFILE
>statement. It may be I don't know the proper way to have SQL*Loader
>interpet the symbol/logical
>
>----------------- *.COM file -----------------------------
>$ define in_data_file DATA_FILE.DAT
>$ define my_constant GREEN
>$ my_constant = GREEN
>$SQLLOADER / control=control_file.ctl
>
>----------*.CTL ---------
>...
>INFILE "in_data_file"
>...
>constant_color CONSTANT {???},
>...
>
>Thanks for any help
>JKudebeh_at_medio.net
>

I have tried to do this, but was unable to get SQL*Loader to be able to read environment variables. So what I did was write a SQL*Plus script to create the control file. The script wrote in the value for the constant. Then I ran SQL*Loader and deleted the control file. The other jury-rigged way of doing it is to story the value in a table and select in your SQL*Load script.

It is not great, but it worked. Received on Wed Jun 21 1995 - 00:00:00 CEST