Help SQL*Loader

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 Received on Sun Oct 22 1995 - 00:00:00 CET