Hi,
I have an issue reading mainframe file whose format is
H,date(2006-07-07).....
D,.............................
D,....................
.
.
T,1234,..................
H-header record
D-data record
T-trailer record
I am using same metadata to read all the records using CFF stage to convert ebcidic to ascii.
I have an issue with the second column its datatype is integer.So date cannot be loaded into this datatype.After conversion its giving me junk values for data column of header record.
Please suggest some strategy to deal with this issue as it may happen for any file.
Thanx in advance.
mainframe file issue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: mainframe file issue
Thanx Ray, but can you elaborate on your solution.sdfasih wrote:Hi,
I have an issue reading mainframe file whose format is
H,date(2006-07-07).....
D,.............................
D,....................
.
.
T,1234,..................
H-header record
D-data record
T-trailer record
I am using same metadata to read all the records using CFF stage to convert ebcidic to ascii.
I have an issue with the second column its datatype is integer.So date cannot be loaded into this datatype.After conversion its giving me junk values for data column of header record.
Please suggest some strategy to deal with this issue as it may happen for any file.
Thanx in advance.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: