CFF Multiple Record Types

rstemphowski · Post by **rstemphowski** » Wed Feb 04, 2009 9:00 am

If you use the Px CFF stage to define multiple record types, you have to specify the record ID for each with the only option being '='. Is there any way to define the record IDs for all but one type and have something like an otherwise or all others record layout. I have a source file that has over 40 record types and am not prepared to define each possibility at this point. I need to define as many as I want and have the others, that don't match the record IDs defined, fall into an "other" record layout. Is there any way to accomplish this in the PX CFF stage?

rstemphowski · Post by **rstemphowski** » Thu Feb 05, 2009 1:22 pm

I still haven't figured this out so if anyone has any answers on this, they would be greatly appreciated. At this point, I'm reading in all records with the CFF stage but one layout then filtering them by type (with the remaining going to an "other" bucket) out to individual CFF files. In a separate job, I read the individual file with a CFF stage but this time applying the complex record layout.

Aruna Gutti · Post by **Aruna Gutti** » Tue Feb 17, 2009 12:59 pm

Hello Robert !

I am not sure whether this is very old topic for you but this is the first time I saw this post. I had the same issue which I resolved not through CFF stage options but by eliminating unwanted record types from the source file itself ( I created a JCL with a Sort to extract only valid record types on the Mainframe side ).

If you already found a solution to this I would appreciate if you can share it so that I can eliminate creating an extra Mainframe job.

Many Thanks,

Aruna.

Aruna Gutti · Post by **Aruna Gutti** » Tue Feb 17, 2009 1:00 pm

Hello Robert !

I am not sure whether this is very old topic for you but this is the first time I saw this post. I had the same issue which I resolved not through CFF stage options but by eliminating unwanted record types from the source file itself ( I created a JCL with a Sort to extract only valid record types on the Mainframe side ).

If you already found a solution to this I would appreciate if you can share it so that I can eliminate creating an extra Mainframe job.

Many Thanks,

Aruna.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Feb 18, 2009 5:24 am

You can use the filter to pick only the record types you need and ignore the rest.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Feb 18, 2009 5:24 am

You can use the filter to pick only the record types you need and ignore the rest.

Aruna Gutti · Post by **Aruna Gutti** » Wed Feb 18, 2009 9:03 am

Hi Sainath,

Could you please give an example of how to use a filter. I have around 35 record types with redefinitions at the record level ( all the records have several packed data with redefines). I am picking 15 types of records basing on the record type.

Is there any way to define a filter for the first two characters only instead using record definition ?

Appreciate your help,

Aruna.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Feb 18, 2009 9:33 am

CFF stage picks only the record IDs you defne. So if you skip those you do not wish to extract, it will automatically drop it during import.

Aruna Gutti · Post by **Aruna Gutti** » Wed Feb 18, 2009 1:51 pm

No it doesn't.

I am getting a initial warning :

Cff_Mar_balo,0: Tag value: NS does not match any tagcase for tagged field "cff_mar_balo_record_type"

'NS' is the record_type for the very first record of the file and want to skip that record.

Then the job fails with a error message subsequently :

Cff_Mar_balo,0: Import error at record 1.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Feb 19, 2009 3:59 am

What is the datatype?

It worked for me in ASCII

Aruna Gutti · Post by **Aruna Gutti** » Thu Feb 19, 2009 12:36 pm

My data format is binary and character set is EBCDIC. My record type is first two characters of the record defined as string (CHAR).

Thanks,

Aruna.

devo · Post by **devo** » Wed Dec 07, 2011 10:44 am

Here is what I found. In the CFF stage on the File Options tab, change the reject mode to "Save." You will then need to add a reject to the stage. (add a link, right click link, convert to reject) Now any record that does not flow to the criteria you have established will be sent to the reject link. A warning will be logged for each reject sent.

devo · Post by **devo** » Wed Dec 07, 2011 10:48 am

Here is what I found. In the CFF stage on the File Options tab, change the reject mode to "Save." You will then need to add a reject to the stage. (add a link, right click link, convert to reject) Now any record that does not flow to the criteria you have established will be sent to the reject link. A warning will be logged for each reject sent.

Aruna Gutti · Post by **Aruna Gutti** » Fri Dec 16, 2011 11:39 am

Hi Devo,

No it won't work. The reject mode only works for CFF stage with single record definition. For Multiple record definition you get the following error:

Record format type=implicit: cannot save rejected records

In fact we opened a PMR with IBM and an enhancement request was created for this issue.

Aruna.

DSXchange

CFF Multiple Record Types

CFF Multiple Record Types

Re: CFF Multiple Record Types

Re: CFF Multiple Record Types

Re: CFF Multiple Record Types