RE: Sqlloader on VSAM file

From: Burton, Laura L. <BurtonL_at_prismplus.com>
Date: Mon, 11 Jun 2001 12:10:09 -0700
Message-ID: <F001.00324725.20010611120622@fatcity.com>

<FONT color=#0000ff face=Arial

size=2>Raymond,
<FONT color=#0000ff face=Arial

size=2> 
Please
forgive me, but I am not sure now if you are asking a question or stating that you're ok.  Your control file looks ok except I 'define' my fields differently.  I am sending you an example below.  I am assuming your amount fields has 2 decimal positions.  Let me know if you need anything else.
<FONT color=#0000ff face=Arial

size=2><FONT color=#0000ff
face=Arial size=2>Laura
<FONT color=#0000ff face=Arial

size=2>_______________________________________________________

options (errors=99)load datainfile
'pmiwkly.dat'truncate
 
into table pmiwklytrailing

nullcols(badge                  <SPAN 

class=772550415-11062001><FONT color=#0000ff face=Arial size=2>       position(01-
06)    <FONT color=#0000ff
face=Arial size=2>    

char,wedte                     <SPAN 

class=772550415-11062001><FONT color=#0000ff face=Arial size=2>    position(07-
12)    <FONT color=#0000ff
face=Arial size=2>    
date    "MMDDYY"    
"decode(:WEDTE, '000000', null,

:WEDte)",mgmtded                    

position( 17- 17)   <FONT
color=#0000ff face=Arial size=2>    

CHAR,unionded                   <SPAN 

class=772550415-11062001>
POSITION( 18- 18)    

CHAR,esophrs                    <SPAN 

class=772550415-11062001> 
POSITION( 78- 82)     INTEGER
EXTERNal       

":ESOPHRS/10",esopamt                    <SPAN 

class=772550415-11062001>
POSITION( 83- 89)     INTEGER
EXTERNAL       

":ESOPAMT/100",mesophrs                   <SPAN 

class=772550415-11062001>
POSITION( 90- 94)     INTEGER
EXTERNAL       

":MESOPHRS/10",mesopamt                   

POSITION( 95-101)     INTEGER
EXTERNAL       
":MESOPAMT/100"
<FONT

color=#0000ff face=Arial size=2>)
<FONT

color=#0000ff face=Arial size=2><SPAN
class=772550415-11062001><FONT color=#0000ff face=Arial

size=2>_________________________________________________________

    <FONT face="Times New Roman"
    size=2>-----Original Message-----From: Raymond Lee Meng Hong     [mailto:RAYMOND_at_infopro.com.my]Sent: Sunday, June 10, 2001 9:25     PMTo: Multiple recipients of list ORACLE-LSubject: RE:     Sqlloader on VSAM file     

        <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 
        <SPAN 
        class=740110301-11062001><FONT 
        size=2>A38001000307754A0000005516562HATIJAH BT <FONT 
        size=2>BAKAR                        
        19920130020000020000 <FONT color=#0000ff 
        face=Arial size=2><FONT 
        size=2>0000850 
        <SPAN 
        class=740110301-11062001>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 
        
        <SPAN 
        class=740110301-11062001>here is my control files. . if the record is 
        like this 1 line/record.
        <SPAN 
        class=740110301-11062001><SPAN 
        class=740110301-11062001><FONT 
        size=2>A38001053088697A0000006106290ALIBABAKAR <FONT 
        size=2>                        
        199201300100000100000000850 
        
        <SPAN 
        class=740110301-11062001>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)
        <SPAN 
        class=740110301-11062001>sorry for any mislead<SPAN 
        class=772550415-11062001><FONT color=#0000ff face=Arial 
        size=2>ing
        <SPAN 
        class=740110301-11062001><FONT 
        color=#0000ff face=Arial size=2> <SPAN 
        class=772550415-11062001><FONT color=#0000ff face=Arial 
        size=2> 

Received on Mon Jun 11 2001 - 14:10:09 CDT