CFF occurs depending on

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
denzilsyb
Participant
Posts: 186
Joined: Mon Sep 22, 2003 7:38 am
Location: South Africa
Contact:

CFF occurs depending on

Post by denzilsyb »

hi guys

We are reading a variable length file in EBCDIC format. The record has an 'occurs depending on' field, that goes down any number of levels, or none. i.e. We dont have a maximum amount of occurs defined. The original code is from SAS, and we are trying to rewrite this into a CFD that DS can understand.

any suggestions on how to take on this monster?

dnzl
dnzl
"what the thinker thinks, the prover proves" - Robert Anton Wilson
mleroux
Participant
Posts: 81
Joined: Wed Jul 14, 2004 3:18 am
Location: Johannesburg, South Africa
Contact:

Post by mleroux »

Howzit Denzil

I see in the readme for 7.5 that Enterprise Edition supports your fancy OCCURS DEPENDING ON CFF's...

Code: Select all

Enterprise Edition
~~~~~~~~~~~~~~~~~~

Complex Flat File Stage
-----------------------
A new Parallel Complex Flat File stage has been added to read or write
files that contain complex structures (for example groups, arrays,
redefines, occurs depending on, etc.). Arrays from complex sources can
be passed as-is or optionally flattened or normalized.
Morney le Roux

There are only 10 kinds of people: Those who understand binary and those who don't.
denzilsyb
Participant
Posts: 186
Joined: Mon Sep 22, 2003 7:38 am
Location: South Africa
Contact:

Post by denzilsyb »

Hi morne

The server job CFF also does this, except that you need to specify for obvious reasons the maximum occurs in an 'occurs dep. on' field. else, if you have int(4) as your occurs defined field there is a possible 9999 occurs if the maximum is not defined.

When we eventually start developing on the mainframe jobs, i hope that this will be resolved.

good to see you are on the forum!
dnzl
"what the thinker thinks, the prover proves" - Robert Anton Wilson
Post Reply