| sql loader - 1 physical record [message #69663] |
Thu, 14 February 2002 10:42  |
Cheryl
Messages: 4
Registered: February 2002
|
Junior Member |
|
|
I am trying to load a feed from a legacy db2 system. the ebcdic fixed length flat file comes across as 1 very long physical record. all the logical records are listed one after the other. like a tape feed. no delimiters or end of line characters. I have loaded the first record correctly. but only one. it does not continue to read along the single line physical file.
Here is the basic ctl i'm running.
LOAD DATA
CHARACTERSET 'WE8EBCDIC37C'
INFILE 'C:CT2116.BIN'
INTO TABLE CT.CT2116
(TERM_LOCATION POSITION(1) CHAR(6),
TERM_LOC_MNEMNC POSITION(7) CHAR(10) ,
TERM_LOC_DESCR POSITION(17) CHAR(50) ,
MANUAL_AUTO_IND POSITION(67) CHAR(1) ,
USER_ID POSITION(68) CHAR(8) ,
TIME_STAMP POSITION(76) CHAR(26)
)
does anyone have any idea how to load this table?
thanks,
cheryl
|
|
|
|
| Re: sql loader - 1 physical record [message #69665 is a reply to message #69663] |
Thu, 14 February 2002 11:56  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
|
I have not had to do this before but as far as I know sqlloader will not handle it. What you might try is loading it into MS Access and then export it as ascii. At least a try. Good luck.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
