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.
Output file having complex flat structure
Moderators: chulett, rschirm, roy
Output file having complex flat structure
Thanks in advance,
Hi,
You can use CFF stage or Transformer stage.
You can implement it in server or parallel jobs.
IHTH,
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: