CFF file output Multiplied

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
rhaddur
Participant
Posts: 52
Joined: Mon Mar 13, 2006 7:33 am
Location: mumbai

CFF file output Multiplied

Post by rhaddur »

I am reading CFF with following copy book

01 Header.
03 COL1 PIC X(1).
88 HED_REC VALUE 'A'.
03 COL2 PIC X(02).
03 COL3 PIC X( 08 ) .
03 COL4 PIC X(10).
03 COL5 PIC X( 08 ) .

01 Detail.

03 COL1 PIC X(1).
88 DATA_REC VALUE 'D'.
03 COL2 PIC X(2).
03 COL3 PIC X( 8 ) .
03 COL3 PIC X(30).
03 COL4 PIC X(16).
03 COL5 PIC X(30).
03 COL6 PIC X(26).
03 COL7 PIC S9(9).
03 FILLER PIC X(10).
03 GROUP_COL1 OCCURS 1 TO 32600
DEPENDING ON
COL7.
05 FILLER PIC X(1).
03 COL8 PIC X(1).

01 Trailer.
03 COL1 PIC X(1).
88 TRL_REC VALUE 'Z'.
03 COL2 PIC 9(09).



where in my input I am getting 255 records ( 1 Headr , 253 details , 1 trailer )


When I am writing it to target flat file I am getting 7012687


I suspect becaue of
details group = 03 GROUP_COL1 OCCURS 1 TO 32600
Recrods are multiplied in target

i.e input = recrods count =255 and output record count 7012687

Can any body let me know whether my undetsanding is correct or is there any issue with my job
Rhaddur
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Basically, yes. However you have an "OCCURS DEPENDING ON" rather than a simple "OCCURS" clause meaning while they can repeat up to 32600 times the values in the group will repeat the number of times stored in COL7.

Now, as to the CFF stage, I don't recall if it supports "DEPENDING ON" or not. :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

CFF stage supports one OCCURS DEPENDING ON clause. So what's the value in COL7 ?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
rhaddur
Participant
Posts: 52
Joined: Mon Mar 13, 2006 7:33 am
Location: mumbai

Post by rhaddur »

ray.wurlod wrote:CFF stage supports one OCCURS DEPENDING ON clause. So what's the value in COL7 ? ...

Hi chulett/Ray,

Thanks for your help

Ray where COL7 is lenth column

new issue -- when I read this group column i.e. GROUP_COL1 in target I am getting following error in tranformer any idea , how to read the field GROUP_COL1


Transformer_46: Error when checking operator: When binding input interface subrec "GROUP_COL1" to subrec "GROUP_COL1": A variable-length vector is bound to fixed-length vector input.
Rhaddur
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

We know what it holds, Ray asked for the actual value in the field - 1, 25, eleventy-seven? This to validate how it was being 'multiplied'. And best to resolve the posted problem before moving on to other issues (which really should be in a separate post) rather than treating this as a long, run-on CFF topic.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply