Problem reading a EBCDIC file using CFF Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Thu Aug 25, 2005 11:33 pm
Problem reading a EBCDIC file using CFF Stage
Hi,
****THIS IS URGENT****
I am using a CFF Stage to read a EBCDIC file and then convert it to a ASCII file.
I have problem reading a particular column. Whe I do a 'view data', I get a '?' (question mark) as the value for that column.
The columns native type is CHARACTER and length is 1. (BIT (1) type ).
I get correct values for other columns, but except this.
I played around with all the properties and options, but still only a "?" shows up.
Please help. This is URGENT
****THIS IS URGENT****
I am using a CFF Stage to read a EBCDIC file and then convert it to a ASCII file.
I have problem reading a particular column. Whe I do a 'view data', I get a '?' (question mark) as the value for that column.
The columns native type is CHARACTER and length is 1. (BIT (1) type ).
I get correct values for other columns, but except this.
I played around with all the properties and options, but still only a "?" shows up.
Please help. This is URGENT
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard! :D
If it's urgent, sign up with your support provider for premium support and learn how much "urgent" costs.
This is an all-volunteer site. People post as and when they can.
If it's urgent, sign up with your support provider for premium support and learn how much "urgent" costs.
This is an all-volunteer site. People post as and when they can.
Last edited by ray.wurlod on Fri Aug 26, 2005 1:38 am, edited 1 time in total.
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.
krsriraman ,
I am sure that you would already have received answers, had you not specified URGENT twice in your e-mail.
While you are awaiting answers, perhaps you could use the search functionality on this site to see some answers.
I am sure that you would already have received answers, had you not specified URGENT twice in your e-mail.
While you are awaiting answers, perhaps you could use the search functionality on this site to see some answers.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA
-
- Participant
- Posts: 9
- Joined: Thu Aug 25, 2005 11:33 pm
Before posting, I did search the site, and since I did not get an answer, I have posted the query.ArndW wrote:krsriraman ,
I am sure that you would already have received answers, had you not specified URGENT twice in your e-mail.
While you are awaiting answers, perhaps you could use the search functionality on this site to see some answers.
When converted to ASCII, the sequential file just shows the ASCII equivalent of "?". Also, it is not packed.
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
Perhaps my Create a hex/ascii dump of an ebcdic cobol file tool can give you a clue.
You will find it on the DataStage Tools page of www.anotheritco.com.
You will find it on the DataStage Tools page of www.anotheritco.com.
Chuck Smith
www.anotheritco.com
www.anotheritco.com
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
This tool can dumps your entire dataset. Its primary input parameter is your logical record length.
I usually limit my job to a few rows when I first run it. Next, I try to identify fields in the logical record that I can use in constraints to filter the output without limiting the input rows. Add a constraint to the job, and run it again. Repeat the cycle until you have found the problem with your data or it description (copybook).
I usually limit my job to a few rows when I first run it. Next, I try to identify fields in the logical record that I can use in constraints to filter the output without limiting the input rows. Add a constraint to the job, and run it again. Repeat the cycle until you have found the problem with your data or it description (copybook).
Chuck Smith
www.anotheritco.com
www.anotheritco.com
-
- Participant
- Posts: 9
- Joined: Thu Aug 25, 2005 11:33 pm
But I am getting the ?s only some fields. Not all. The other fields have NULL (or blank ) values in them.dls wrote:If your EBCDIC file is the result of a utilility 'unload' of a DB2 table on the MF, then the ?s may be indicating null values in your source.
If that's the case, you can easily account for it in the CFF stage processing.
Also,I heard that, If the CFF does not understand a character, then it shows a questionmark.
Keep in mind the difference between a blank/space and a null value.
I'm suggesting the following scenarion. It may, or may not, be the case.
Your EBCDIC file is the result of an unload from a MF DB2 table. Some columns in the source table are defined as nullable. Whenever a null value exists in the source column, it results in a '?' value in your FF field.
Likewise, any column in your source table defined as CHAR/VCHAR can have a blank/space value, whether it's nullable or not. Like any other value, the blank/space value is carried over to your FF field.
Make sense?
I'm suggesting the following scenarion. It may, or may not, be the case.
Your EBCDIC file is the result of an unload from a MF DB2 table. Some columns in the source table are defined as nullable. Whenever a null value exists in the source column, it results in a '?' value in your FF field.
Likewise, any column in your source table defined as CHAR/VCHAR can have a blank/space value, whether it's nullable or not. Like any other value, the blank/space value is carried over to your FF field.
Make sense?