 Load Flat File on Table using SQL LOADER [message #127791] |
Wed, 13 July 2005 06:42 |
kumar044
Messages: 1
Registered: July 2005
|
Junior Member |
|
|
I got problem to loading variable length Flat File on SQL Loader. Here first 4lines are fileheader ,second 4 lines are filerecord and last 4 lines are fileFooter.
Flat File as follows:
FHDRFAD 02G105021005021009032220NMB xxxxxx xxx. xx
LAO266050128S00 0003613REC R31287PSZ700
00000000038008355JPMCHASE/PWMBS
1C64136 0201B1Q8224C00041302010827BAC105011305020105020105020105021500
0000045833333300000000000106742I00000000000017119F00000000000123
FTLR0000000000000000000000000{00000000000000000{00000000000
000000000{000000000000
FHDRFAD 02G105021005021009032220NMB xxxxxx xxx. xx
.
.
.
.
.
.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
