Is there a way to create a job which reads in any MF binary [EBCDIC] file by providing the copybook dynamically?
The copybook may have COMP/COMP-3 fields or may not be.
I need your valuable suggestions to create a Job/Routine [PX Or Server] if at all this is possible.
Dynamically reading MF binary files
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Importing the copybook manually is the only way to get a complex flat file definition into DataStage. You need to import the copybook definition and then fill in values for record type and define how you are going to flatten the data. Sometimes you need to modify and tweak the copybook to get DataStage to understand it.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
To add to Vince's post - once you have those COBOL copybook definitions loaded into DataStage you can write a job which decides at runtime which (previously loaded) schema file is used to read the input data. This job would need to use runtime column propagation to process data, but it is a possible approach to dynamically read complex files.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact: