Sqlloader

From: Michael Stiler <mstiler_at_genmagic.com>
Date: 1996/06/20
Message-ID: <4qae8v$i8e_at_cnn.genmagic.com>#1/1


Hi folks, just a quick question. One of our clients (out of 3) is shipping us datafiles for loading into our Oracle database tables where we use a _single_ VARCHAR2 field of 500 bytes to hold comments about an problem being worked on. This one client is using four *fixed length* fields of 70 bytes each which may, or may not have data in each field. I need to be able to concatenate those 4 fields into a single field for insertion into the table single variable length field without skipping any of them.

Hopefully someone out there will have a quick answer about what I should be writing in my SQLLoader control file to do this.

Any help is appreciated, and I hope this makes sense!

Please post answers to this newsgroup.

Mike

--
Michael D. Stiler  Sysdate Consulting Services  ::internet stiler_at_netcom.com
NRA LifeMember  AMA LifeMember  AOPA  DAN  Retreads  HOG  TeamOS/2  Bagpiper
Master Mason   32nd degree Scottish Rite   Knight Templar   Shriner   Sailor
IronHorsemen M/C   ---------    Hooligans' M/C   ---------   SightSeers' M/C
Received on Thu Jun 20 1996 - 00:00:00 CEST

Original text of this message