check the utilities documentation, specifically the Field List section and the "terminated by" clause.. you can override the default terminator of line feed. You can also concatenate multiple lines together
--- "Mandal, Ashoke" <[EMAIL PROTECTED]> wrote: > Greetings, > > We have one column in a table and this column need to store data with > Line Feed, denoted by \x0d\x0a in the following row. This data comes > from Sybase database. If \x0d\x0a cannot be loaded as Line Feed > through the SQL*Loader then how can we do it? > > Any help is appreciated. > Thanks, > Ashoke > > Data file contains the following one record : > > crm1d1p1|50 Hz Interval|Software Group|When the test is conducted in > the Atrium, this parameter encodes to Manual Therapy 50 Hz Induction > Atrial Pacing Minimum Interval and x0d0a Manual Therapy Atrial 50 Hz > Induction Instruction Buffer Byte 7 and 9.\x0d\x0aWhen the test is > conducted in the Ventricle, this parameter encodes to Manual Therapy > 50 Hz Induction Ventricular Pacing Minimum Intervaland \x0d\x0a > Manual Therapy 50 Hz Induction Instruction Buffer Byte 3 and > 5.|37344||||||||1192 > > > Sample Control File : > LOAD DATA > INFILE param.dat "str X'0d0a'" > BADFILE param.bad > append into TABLE param_ashoke > TRAILING NULLCOLS > (DEVICE CHAR(80) TERMINATED BY "|" > ,PARAM CHAR(80) TERMINATED BY "|" > ,PARAM_TYPE CHAR(20) TERMINATED BY "|" > ,SW_NOTE CHAR(4000) TERMINATED BY "|" > ,SW_NOTE_CHECKSUM CHAR(38) TERMINATED BY "|" > ,FW_VAR_BASE CHAR(80) TERMINATED BY "|" > ,FW_VAR_MEMBER CHAR(80) TERMINATED BY "|" > ,BIT_OFFSET CHAR(38) TERMINATED BY "|" > ,BIT_SIZE CHAR(38) TERMINATED BY "|" > ,FW_ENCODE_DECODE CHAR(20) TERMINATED BY "|" > ,BIT_LEVEL_TRANS CHAR(80) TERMINATED BY "|" > ,ALIAS CHAR(80) TERMINATED BY "|" > ,GLOBAL_ID CHAR(38) TERMINATED BY WHITESPACE) > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mandal, Ashoke > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
