<FONT
face=Tahoma>
<FONT color=#0000ff
face=Arial>[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
<FONT
size=2>A38001000307754A0000005516562HATIJAH BT <FONT
size=2>BAKAR
19920130020000020000 <FONT color=#0000ff face=Arial
size=2>0000850
<FONT
size=2>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 ..
<SPAN
class=740110301-11062001><FONT color=#0000ff face=Arial
size=2><FONT
size=2>A38001053088697A0000006106290ALIBABAKA <FONT
size=2>R
1992013001000001000000008 50
here
is my control files. . if the record is like this 1
line/record.
<FONT
color=#0000ff face=Arial size=2><FONT
size=2>A38001053088697A0000006106290ALIBABAKAR <FONT
size=2>
199201300100000100000000850
<FONT
size=2>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.
<SPAN
class=740110301-11062001>
<SPAN
class=740110301-11062001>
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 [<A
href="mailto:RAYMOND_at_infopro.com.my">mailto:RAYMOND_at_infopro.com.my]
Sent: Friday, June 08, 2001 4:06 AM <FONT
size=2>To: Multiple recipients of list ORACLE-L <FONT
size=2>Subject: Sqlloader on VSAM file
Hello , currently I have a set of data download from
IBM VSAM file format such as these
A38001000307754A0000005516562HATIJAH BT <FONT
size=2>BAKAR
19920130020000020000 0000850 <FONT
size=2>A38001053406059A0000005637195SALBIAH B <FONT
size=2>RAHMAT
1992013001000001000 00000850 <FONT
size=2>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 <FONT
size=2>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: <A href="http://www.orafaq.com"
target=_blank>http://www.orafaq.com --
Author: Raymond Lee Meng Hong <FONT
size=2> INET: RAYMOND_at_infopro.com.my
Fat City Network Services -- (858)
538-5051 FAX: (858) 538-5051 San Diego,
California -- Public Internet access
/ Mailing Lists <FONT
size=2>--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail
message to: ListGuru_at_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).
Received on Sun Jun 10 2001 - 20:25:48 CDT
