View data in CFF
Moderators: chulett, rschirm, roy
View data in CFF
Hi There,
We are using a CFF stage to read one of our input file
We are able to view the all columns properly but when we view it in datastage each record is shown as 4 times
If i have 2 records in the input file, it shows 8 records when i view the data from Datastage, when i tried to load the file to Dataset it loads 8 records but the performance statistics shows only 2 records
Any ideas please
Regards
We are using a CFF stage to read one of our input file
We are able to view the all columns properly but when we view it in datastage each record is shown as 4 times
If i have 2 records in the input file, it shows 8 records when i view the data from Datastage, when i tried to load the file to Dataset it loads 8 records but the performance statistics shows only 2 records
Any ideas please
Regards
-------------------------
https://www.ssa.co.za
https://www.ssa.co.za
Hi Mike,
Please let me know where can i set the array size
Regards
Please let me know where can i set the array size
Regards
-------------------------
https://www.ssa.co.za
https://www.ssa.co.za
That's certainly true in 7.5.2.
I'm an old COBOL dog, so I don't hesitate to edit the copybook before importing it, deciding on arrays and redefines myself. When I deal with mainframe data, it's always going to or from some other platform (usually Unix) where COBOL formatting is not very useful.
I'm an old COBOL dog, so I don't hesitate to edit the copybook before importing it, deciding on arrays and redefines myself. When I deal with mainframe data, it's always going to or from some other platform (usually Unix) where COBOL formatting is not very useful.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
Hi All,
We got this working by selecting the Flatten Arrays while selecting the columns.
We are getting source files from the Packed Decimal (Comp 3) and EBCDIC format
But when we select the character set as EBCDIC, we are not able to view the data, but we can view the data (Partially-some columns) if we select the character set as ASCII
When we select the character set as EBCDIC, we are getting the below error as
Please advise if i have to bring any settings in
Regards
We got this working by selecting the Flatten Arrays while selecting the columns.
We are getting source files from the Packed Decimal (Comp 3) and EBCDIC format
But when we select the character set as EBCDIC, we are not able to view the data, but we can view the data (Partially-some columns) if we select the character set as ASCII
When we select the character set as EBCDIC, we are getting the below error as
Input buffer overrun at field "FIELD NAME"
Please advise if i have to bring any settings in
Regards
The fact that you can partially view the data when you select ascii likely means that the file was transferred in ascii mode... all of your packed decimals will be destroyed.
There was a recent post, I think, where James and Franklin provided some excellent information regarding ftp of mainframe files.
Mike
There was a recent post, I think, where James and Franklin provided some excellent information regarding ftp of mainframe files.
Mike