Output file having complex flat structure

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
DS_MJ
Participant
Posts: 157
Joined: Wed Feb 02, 2005 10:00 am

Output file having complex flat structure

Post by DS_MJ »

Hello:

Our requirement is to extract the data from SAP R/3 and create an output file having complex flat structure with Header and detial records.

Would like to know what file accepts as input complex flat structure with Header and detail records?

Header Record Format

Description | Format| Size | Field value |

Fieldvalue | Char | 11 | "XXXXX" |

Detail Records with following fields:

File Field Name| Position| Attributes|

XXXDATE | 001-006| CHAR(06) |


DS Windows Client 7.5.1.a
OS: Linux
Source: SAP R/3
Target Database: Db2 v8.2.
Thanks in advance,
Top
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
You can use CFF stage or Transformer stage.

You can implement it in server or parallel jobs.

IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
Top
DS_MJ
Participant
Posts: 157
Joined: Wed Feb 02, 2005 10:00 am

Post by DS_MJ »

Hi Roy:

CFF stage is used as a source stage. I want to output this to a file. CFF has no input.
Thanks in advance,
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

CFF stage can have an input in version 7.5. Time to upgrade?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”