From RAYMOND@infopro.com.my Sun, 10 Jun 2001 18:25:48 -0700 From: Raymond Lee Meng Hong Date: Sun, 10 Jun 2001 18:25:48 -0700 Subject: RE: Sqlloader on VSAM file Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: Sqlloader on VSAM file [Raymond]  I did check on the source text file , I did't see a carriage return on this, according to the previous example , this is the 1 record A38001000307754A0000005516562HATIJAH BT BAKAR                        19920130020000020000 0000850 this is the 2nd record and so on .and for the first 6 character is the agent code , which will not be the same like A38001, might be something else F41010..or whatever .. A38001053088697A0000006106290ALIBABAKA R                        1992013001000001000000008 50 here is my control files. . if the record is like this 1 line/record. A38001053088697A0000006106290ALIBABAKAR                         199201300100000100000000850 LOAD DATAINFILE AAA.DATAPPEND INTOTABLE LN21PNB(FINANCE_CD        position(1:6)DECIMAL EXTERNAL, MEMBERSHIP_NO        position(7:15)CHAR, ICNO            position(16:29)CHAR, NAME        position(30:69)CHAR, CERTNO       position(70:75) CHAR, TXN_DATE     position(76:83)DATE 'YYYYMMDD', LOAN_AMT        position(84:89)DECIMAL EXTERNAL, REPAY_AMT     position(90:96) DECIMAL EXTERNAL, REASON_CD     position(97:98) DECIMAL EXTERNAL, REPAY_MAG     position(99:102) DECIMAL EXTERNAL) sorry for any misleading.      I do the same thing here at my shop and the record I download from a vsam file is 3574 in length.  When I view the download in the .txt format it is wrapped just like what your records look like below.  However, a new record does start on a new line, and it looks like yours does the same thing.  In your .ctl member just treat the record as if were not wrapped.  It will work. Laura -----Original Message----- From: Raymond Lee Meng Hong [mailto:RAYMOND@infopro.com.my] Sent: Friday, June 08, 2001 4:06 AM To: Multiple recipients of list ORACLE-L Subject: Sqlloader on VSAM file   Hello , currently I have a set of data download from IBM VSAM file format such as these A38001000307754A0000005516562HATIJAH BT BAKAR                        19920130020000020000 0000850 A38001053406059A0000005637195SALBIAH B RAHMAT                      1992013001000001000 00000850 A38001157190166A0000005249952RAIDAH AB U TALIB                        1992013001000000850 00000850 Actually of the the field is fixed on the length , but for the name which it auto-carriage return down to next line , how can I configure my sqlloader to capable for this format , as well as I know ,sqlloader can only download ASCII (1 line per line on fetching record , but how about this when the line is fix on 60 per line and the remaining record will continous in next line ? how to capable for this ?? Raymond fall asleep in waiting for the Q. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong   INET: RAYMOND@infopro.com.my 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: ListGuru@fatcity.com (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).