SQL Loader - can a table column be set CONSTANT where the constant a value returned by a function

From: Jeff Boehlert <boehlert_at_peak.org>
Date: Mon, 14 Jun 1999 23:10:01 -0400
Message-ID: <7k416t$dn1$1_at_bashir.peak.org>

[Quoted] Is it possible in SQL Loader (7.3) to load a table column CONSTANT whereby the CONSTANT value is really a function return. I want to use my own sequence value and populate the column of a table.

The sequence function call works fine but without the keyword constant it looks for a value on the inbound file. With CONSTANT specified it wants to use the function call text as the constant.

Tell me there is a way to do this ?

Jeff Boehlert

--
      _  __________________________________________  _
     / )| Jeff Boehlert        boehlert_at_peak.org   |( \
    / / |             Why run 26.2 ?               | \ \
  _( (_ |      Because it hurts so good !!         | _) )_


 (((\ \>|_/->__________________________________<-\_|</ /)))

 (\\\\ \_/ /    o      New York City      o     \ \_/ ////)
  \       /    < \      Marine Corp      < \     \       /
   \    _/    _/\        Portland       _/\       \_    /
   /   /       /          Big Sur        /          \   \
  /___/                   Seattle                    \___\
                       San Francisco
                    Rock-n-Roll Marathon
 =================================================================
 Utica, NY home of the best 15k in the country - The Boilermaker
        And of course the Distance Running Hall of Fame
 =================================================================

Received on Tue Jun 15 1999 - 05:10:01 CEST