How to read redefines using parallel complex flat file stage
Moderators: chulett, rschirm, roy
How to read redefines using parallel complex flat file stage
I am having problem in reading redifines in complex flat file stage in parallel job so can any body help me in resolving this issue
I appreciate for that
I appreciate for that
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
So what, precisely, is the problem that you are having? Is the metadata on each output one of the redefined table definitions? Are you getting any error messages logged by the CFF stage? If so, please post the exact text.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Ray, is there any way to do it in version 7.5?
Right now I just write all records that don't match the schema to a reject file and then read the reject file as a source to get the records for the second schema. I have two schemas. So I end up with two jobs.
I don't like this approach, but I can't think of anything better.
Right now I just write all records that don't match the schema to a reject file and then read the reject file as a source to get the records for the second schema. I have two schemas. So I end up with two jobs.
I don't like this approach, but I can't think of anything better.
Mike
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Could the rejects link from the first CFF stage be directed into a second CFF stage (or even a Column Import stage) to handle the other record type in the same job?
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.
-
- Participant
- Posts: 22
- Joined: Mon Apr 02, 2007 4:02 am
- Location: MUMBAI
- Contact:
You can use the below mentioned functions
Hi even once i faced the same scenario once
One way is CFF stage but i dont have much clarity on that....
I followed the alternate sequential file stage .
i.e , Use the data as a bunch for which you have redifinition and slice it accordingly as per your requirement .
Means if you have column position from 1 - 50 . The same bunch has been used twice or more by some other columns but with different data type .
So group this data into a stage variable and slice it cordingly each time.....
Cheers
One way is CFF stage but i dont have much clarity on that....
I followed the alternate sequential file stage .
i.e , Use the data as a bunch for which you have redifinition and slice it accordingly as per your requirement .
Means if you have column position from 1 - 50 . The same bunch has been used twice or more by some other columns but with different data type .
So group this data into a stage variable and slice it cordingly each time.....
Cheers
Smrutiranjan Nayak
-
- Participant
- Posts: 22
- Joined: Mon Apr 02, 2007 4:02 am
- Location: MUMBAI
- Contact:
I had some other problems
Hi ,
The problem i am facing is :
The input file is not a fixed width file ( its a cobol data file )
I used CFF stage also to read the data means view the data.....i have some redifines and occurs clause .
So i am not able to do that .
Also suggest how to use redefines tab in CFF ( gurus pls answer) in case i am using more than one columns for redefined .
Can we do any individual column settings ??
Please advice .
The problem i am facing is :
The input file is not a fixed width file ( its a cobol data file )
I used CFF stage also to read the data means view the data.....i have some redifines and occurs clause .
So i am not able to do that .
Also suggest how to use redefines tab in CFF ( gurus pls answer) in case i am using more than one columns for redefined .
Can we do any individual column settings ??
Please advice .
Smrutiranjan Nayak