| sqlldr loading julian dates [message #74617] |
Fri, 21 January 2005 08:39 |
Kris Johnson
Messages: 4
Registered: December 2004
|
Junior Member |
|
|
I am receiving EBCIDC data on my server from a mainframe system. I am doing the EBCIDC to ASCII conversion within my ctl file when I execute sqlldr. However, I'm stuck on one issue. My date coming in includes a 3 byte packed julian date. Yes, that's 3 bytes, which means that it doesn't include the century on this field.
Is there anyway to get sqlldr to read in this field and load it as a date?
Below is an example of my CTL file:
LOAD DATA CHARACTERSET WE8EBCDIC500
BYTEORDER BIG ENDIAN
INFILE '/u10/dir1/dir2/TEST.DAT' "FIX 00287"
TRUNCATE
INTO TABLE DEV.TEST_TABLE
( FIELD_A CONSTANT '111',
FIELD_B POSITION(37:45) CHAR(9),
FIELD_C CONSTANT '00000',
FIELD_D POSITION(59:67) CHAR(9),
FIELD_E POSITION(1:4) CHAR(4),
FIELD_F POSITION(46:47) ZONED(2),
FIELD_G POSITION(71:71) DECIMAL(1,0),
FIELD_H POSITION(48:51) INTEGER(4),
FIELD_I POSITION(5:8) CHAR(4),
FIELD_J POSITION(9:11) DATE )
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
