How to identify a data file contains level and arrays.
Posted: Wed Nov 19, 2008 12:27 pm
Hello,
I have a data file which is extracted from a mainframe system.
Now here is my question:
1. Is there any way to tell whether the data file has arrays and levels in it by looking at the data?
I don't have a Cobol Copy Book/CFD. But, I have a file layout in spread sheet which is telling about the levels and array fields of the data file. I manually typed the metadata in CFF stage. But i couldn't able to view data as i am getting different kinds of error messages.
Here is one eg:
Short read encountered on import; this most likely indicates one of the following possibilities:
2. What does these field pictures represents in mainframe data:
field picture/Type My Assumption
9(2) Numeric/Integer
X(2) Character
V(2) Varchar
9(2)V(2) ?????????
Can any one please advise me on this?
Thanks
Vini
I have a data file which is extracted from a mainframe system.
Now here is my question:
1. Is there any way to tell whether the data file has arrays and levels in it by looking at the data?
I don't have a Cobol Copy Book/CFD. But, I have a file layout in spread sheet which is telling about the levels and array fields of the data file. I manually typed the metadata in CFF stage. But i couldn't able to view data as i am getting different kinds of error messages.
Here is one eg:
Short read encountered on import; this most likely indicates one of the following possibilities:
2. What does these field pictures represents in mainframe data:
field picture/Type My Assumption
9(2) Numeric/Integer
X(2) Character
V(2) Varchar
9(2)V(2) ?????????
Can any one please advise me on this?
Thanks
Vini