Re: SQLLDR: Mapping 1value in .dat file to 2 Columns in Table - LONG

Jurgen,

Thanks a lot, the second of your two suggestions worked perfectly.

Rajah

juergen.meurisch_at_t-online.de (=?ISO-8859-1?Q?J=FCrgen_Meurisch?=) wrote in message news:<2ebfa77d.0210300729.2fe55887_at_posting.google.com>...
> rajah_james_at_yahoo.com (Rajah James) wrote in message news:<86114a1a.0210291424.5e118499_at_posting.google.com>...
>
> Hello James,
>
> try this at the end of the ctl-file
>
> dEndOffset DECIMAL EXTERNAL,
> sOperationNumber CHAR(:SOperationUniqueIdentifier)
> )
>
> or
>
> dEndOffset DECIMAL EXTERNAL,
> sOperationNumber CHAR "concat(:SOperationUniqueIdentifier,'')")
>
> I think this works
> Jürgen
Received on Thu Oct 31 2002 - 21:50:57 CET