re: occurs 0-200 times depending on clause in CFF stage

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
panic
Participant
Posts: 17
Joined: Fri Sep 23, 2005 5:58 pm

re: occurs 0-200 times depending on clause in CFF stage

Post by panic »

hey gurus,
i have an instance in copybook (COBOLFILE)

05 ICD-2615-PROVIDER-TYPE
OCCURS 18 TIMES
INDEXED BY PROV-TYP-INDEX.
10 ICD-2615-PROV-TYPE PIC X(04).

05 ICD-2603-PROVIDER-SPECIALTY
OCCURS 36 TIMES
INDEXED BY PROV-SPC-INDEX.
10 ICD-2603-PROV-SPECIALTY PIC X(04).

05 ICD-4500-PROC-RANGE-CNTR PIC 9(03).
05 ICD-4500-PROCEDURE-RANGES
OCCURS 0 TO 200 TIMES
DEPENDING ON ICD-4500-PROC-RANGE-CNTR
INDEXED BY PROC-RNG-INDEX.
10 ICD-4500-PROC-BEGIN-RANGE PIC X(05).
10 ICD-4500-PROC-END-RANGE PIC X(05).


IN THE LAST
OCCURS 0 TO 200 TIMES
DEPENDING ON ICD-4500-PROC-RANGE-CNTR
INDEXED BY PROC-RNG-INDEX

when i edited the details in EXTENDED attributes in CFF stage
giving 200 times occuring but it CAN'T be flattened
and also i am unable to see that column
ICD-4500-PROCEDURE-RANGES
in the output columns and also the error says it is a tagged

THE other 18 times ,36 times are fine except the 200 times
how can i edit that in Extended attributes to see in the output columns to map it in the target
can anyone please suggest

thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

According to the documentation, OCCURS DEPENDING ON is not supported
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
madhukar
Participant
Posts: 86
Joined: Fri May 20, 2005 4:05 pm

Re: re: occurs 0-200 times depending on clause in CFF stage

Post by madhukar »

Hi panic,

indexed columns in cobol file is not supported by Datasate CFF.

Regs
madhukar
Post Reply