Re: Can I use user-generated sequences in SQL*Load?

In article <796858656wnr_at_istel-is.demon.co.uk>, <AndyHard_at_istel-is.demon.co.uk> writes:
> Path:

noc.tor.hookup.net!hookup!usenet.eel.ufl.edu!newsfeed.internetmci.com!btnet!dis patch.news.demon.net!demon!mail2news.demon.co.uk!relay-4.mail.demon.net
> From: Andy Hardy <AndyHard_at_istel-is.demon.co.uk>
> Newsgroups: comp.databases.oracle
> Subject: Can I use user-generated sequences in SQL*Load?
> Date: Sat, 04 Nov 1995 12:37:33 GMT
> Organization: AT&T ISTEL - IS Communications
> Lines: 14
> Message-ID: <796858656wnr_at_istel-is.demon.co.uk>
> Reply-To: AndyHard_at_istel-is.demon.co.uk
> X-NNTP-Posting-Host: relay-4.mail.demon.net
> X-Broken-Date: Saturday, Nov 04, 1995 12.37.33
> X-Newsreader: Newswin Alpha 0.7
>
> Hi,
>
> I'm using sqlload to populate some tables - one of the fields requires
> population with a sequence number generated by a users CREATE SEQUENCE
> statement.
>
> Is there a way of referring to this sequence during the load?
>
> At the moment, I have to perform an update of the table at a later date!
>
> Andy
> --
> Andy Hardy

I'm not 100% certain, but within your control statements specify NEXT_SEQUENCE as if you were specifying a literal or constant. Should work, but I haven't tried it myself.

\lfeges Received on Mon Nov 06 1995 - 00:00:00 CET