Re: sqlldr & Date/time

Knut Talman <knut.talman_at_mytoys.de> wrote in message news:<3C8F117C.31A29A63_at_mytoys.de>...
> > Thanks for the support, Knut. But I ended my original message with a
> > question similar to his. : Can the table be loaded only using SQLLDR
> > with no TTIME column in the destination table?
> >
> > For fixed field length records it may be possible, but I haven't
> > figured out how to do it for delimited records. Have to use a position
> > specifier but what I read in the manuals, there no way to specify the
> > "field after the next field".
>
> Simple question: Why can't you (or better the original poster) remove the first
> comma?
>
> Regards,
>
> Knut

It may not always be possible or permissible. (yes the later is a political issue, but it happens.) What if the order of the fields were date, vmstat, time
removing one comma wouldn't help.

 So the question remains: Is it possible in SQLLDR, using terminated fields (instead of fixed length) to refer to a field of the input file that is not directly being loaded to a column in the destination table? (Why must the fields exists one-to-one with column names?)

  Tom, do you have any suggestions?

Ed Received on Thu Mar 14 2002 - 15:53:13 CST