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

In article <47lh4m$n6r_at_news.acns.nwu.edu>

           dma956_at_lulu.acns.nwu.edu "Dave Mausner" writes:
> In article <815575836.13915_at_vnvi.demon.co.uk>,
> Nigel J Underwood <nigel_at_vnvi.demon.co.uk> wrote:
> >Andy,
> >You can refer to a sequence in the Loader control file by putting the
> >sequence in quotation marks
> >
> >e.g. field1 position(1:20),
> > field2 "myseq.nextva;",
>
> a sql string may prevent you from using direct load mode. if that's true
> you can revert to using your sequence(count) or sequence(max) idea,
> for without direct you won't be parallel either.
> --
> dave

Dave,

You are correct - using an SQL string prevents direct load. I think that I'm going to play safe, use direct load to get it all in and the perform an update using sequence!

Andy

-- 
Andy Hardy (Internet: aph_at_ahardy.demon.co.uk, CIS: 100015,2603)
PGP key available on request
===============================================================
The lion and the calf shall lie down together,
but the calf won't get much sleep