Retrieval of data from a file
Moderators: chulett, rschirm, roy
Retrieval of data from a file
Hi,
I have a file. It has lot of columns. However, some columns are together without any space in between them and some have space. For eg:
0000492007-02-28 1020001 1 5066 0.4
000049 is first column
2007-02-28 is second
1020001 is third.
What property do i need to set in my sequential stage to get the same?
I have a file. It has lot of columns. However, some columns are together without any space in between them and some have space. For eg:
0000492007-02-28 1020001 1 5066 0.4
000049 is first column
2007-02-28 is second
1020001 is third.
What property do i need to set in my sequential stage to get the same?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
You need to set the format property that indicates that the record format is fixed width. For each column you need to specify the display width (which is the number of characters in the record that represent that particular field).
You need to set the format property that indicates that the record format is fixed width. For each column you need to specify the display width (which is the number of characters in the record that represent that particular field).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi,
Thanks for your reply. I am not a Premiuim account holder so i could not see half of your 2nd message.
I did change the format to fixed width. By display width do you mean the Field width that you get after double clicking each column? I changed that also. But got the below mentioned error:
"Short read encountered on import; this most likely indicates one of the following possibilities:
1) the import schema you specified is incorrect
2) invalid data (the schema is correct, but there is an error in the data). "
The schema seems correct, so does the data.
Thanks for your reply. I am not a Premiuim account holder so i could not see half of your 2nd message.
I did change the format to fixed width. By display width do you mean the Field width that you get after double clicking each column? I changed that also. But got the below mentioned error:
"Short read encountered on import; this most likely indicates one of the following possibilities:
1) the import schema you specified is incorrect
2) invalid data (the schema is correct, but there is an error in the data). "
The schema seems correct, so does the data.
data viewer is only for view the data in datastes.is there any way to view the sequential file data from data viewervasa_dxx wrote:Try to read the Records from Data Viewer. If your able to view through Data Viewer, then the schema and other Credentials are supplied correctly. If there is any error, that would be displayed in the error message.
D.N .MURTHY
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: