[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Reading Multiple occurs from file, Array?



I am reading a very long master file to load into oracle
it has many sections that would have mulitple occurences
of 1 type like 15 occurences of addl_pay.
so i am reading these in like this
! ADDL PAYS 15 TIMES X 42 bytes = 630
 $MASTER_ADDL_CD15:630
I want to break this up to this
addl_code       3    char
addl_effdt      8    date
addl_annamt     7v2  number
addl_biwamt     9v2  number
addl_ytdamt     9v2  number

I thinking read it in one chunk break it to an array than
put in a loop to insert to db