Hello All,
We have a requirement wherein we have a EBCDIC file (after being ftped). We are reading this file using sequential files stage(SFS) with format properties set to EBCDIC. Now my question is can we directly load this sequential file to a dataset stage and expect that it will implicitly convert the EBCDIC format to ASCII format as we do not have any format option in a dataset stage. So my job design is like this:
Sequential file stage(EBCDIC format)------------------------->dataset stage
Actually before we did this in two jobs,
1)first job was from SFS(EBCDIC) format to SFS(ASCII) format.
2)Second job was from above SFS(ASCII) to dataset stage.
This did not appear to be a good idea so we directly loaded from SFS stage to dataset assuming that implicit conversion from EBCDIC to ASCII takes place in dataset.
Please suggest.
reading EBCDIC file from sequential file stage to dataset
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 53
- Joined: Fri Mar 07, 2008 1:17 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: