Programming or scripting. EnTERpRiSE DATAbASES AnD inTERfAcES. Adabas for z/OS. Binary Flat Files. * Supports log-based change capture informatica powerExchange for. Mainframes provides access to enterprise data housed in popular relational and. Today's IT organizations face growing demand for timely access to critical operational data stored in VSAM files on IBM zSeries mainframes. And PowerExchange are trademarks or registered trademarks of Informatica Corporation in the United States and in jurisdictions throughout the world.

Amit redefine clause inside detail, splits the field into seperate colums when a datamap is created and you can split cells within the mainfram VSAM field and make it appear in multiple fields. If you would like I can explain more later. Feel free to call me. R ' amit.jh. Via informatica-l' wrote: # Putting Teeth in Corporate Ethics Codes # Read News: # View Group Archive: Ram, What happens to the DETAIL data i.e.

REDEFINE clause.could you send me the table structure, how it would Look like.sorry if I am asking too much and eating your time. Regards, Amit -----Original Message----- From: grampras via informatica-l [mailto:informatica-l@Groups.ITtoolbox.com] Sent: 23 February 2004 16:12 To: Amit K. Jha Subject: [informatica-l] Re: Importing VSAM Sources # Putting Teeth in Corporate Ethics Codes # Read News: # View Group Archive: Amit When you import this data it will create the record area automatically, there will be nly one record area and one table for the following book. Your body data is split into nme add1 and city, each char field, and your supp code and supp name will occur 4 times, which i assume each occurance pointing to a zone or something.

Hope this helps ram or give me a call, 904 370 7126 03 BODY-DATA. 05 BODY-STORE-NAME PIC X(30). 05 BODY-STORE-ADDR1 PIC X(30). 05 BODY-STORE-CITY PIC X(30). 03 DETAIL-DATA REDEFINES BODY-DATA. 05 DETAIL-ITEM PIC 9(9).

05 DETAIL-DESC PIC X(30). 05 DETAIL-PRICE PIC 9(4)V99. 05 DETAIL-QTY PIC 9(5). 05 SUPPLIER-INFO OCCURS 4 TIMES. Keygen Pnozmulti Configurator more.

10 SUPPLIER-CODE PIC XX. 10 SUPPLIER-NAME PIC X(8). _________________________________________________ Ramprasad Gowrishankar Consultant Infomerica Incorporated --------------------------------- Do you Yahoo!? Mail SpamGuard - Read only the mail you want. *Archives: *Manage Subscriptions: *Leave Group: mailto:leave-informatica-l@Groups.ITtoolbox.com *Need Subscription Help?

Mailto:Listmaster@ITtoolbox.com *Terms of Use: *Copyright (c) ITtoolbox and message author. No redistribution.

*Archives: *Manage Subscriptions: *Leave Group: mailto:leave-informatica-l@Groups.ITtoolbox.com *Need Subscription Help? Mailto:Listmaster@ITtoolbox.com *Terms of Use: *Copyright (c) ITtoolbox and message author. No redistribution. --------------------------------- Do you Yahoo!?

Mail SpamGuard - Read only the mail you want. Ram, What happens to the DETAIL data i. Download Free Music For Paper Jamz Pro here. e. REDEFINE clause.could you send me the table structure, how it would=20 Look like.sorry if I am asking too much and eating your time. Regards, Amit=20 -----Original Message----- From: grampras via informatica-l [mailto:informatica-l@Groups.ITtoolbox.com]=20 Sent: 23 February 2004 16:12 To: Amit K. Jha Subject: [informatica-l] Re: Importing VSAM Sources # Putting Teeth in Corporate Ethics Codes # Read News: # View Group Archive: Amit When you import this data it will create the record area automatically, there will be nly one record area and one table for the following book.=20 =20 your body data is split into nme add1 and city, each char field, and your supp code and supp name will occur 4 times, which i assume each occurance pointing to a zone or something.

Hope this helps=20 ram or give me a call, 904 370 7126 =20 =20 03 BODY-DATA. 05 BODY-STORE-NAME PIC X(30).

05 BODY-STORE-ADDR1 PIC X(30). Jrc Radar 1000 Mk2 Manual. 05 BODY-STORE-CITY PIC X(30). 03 DETAIL-DATA REDEFINES BODY-DATA.

05 DETAIL-ITEM PIC 9(9). 05 DETAIL-DESC PIC X(30). 05 DETAIL-PRICE PIC 9(4)V99. 05 DETAIL-QTY PIC 9(5). 05 SUPPLIER-INFO OCCURS 4 TIMES. 10 SUPPLIER-CODE PIC XX. 10 SUPPLIER-NAME PIC X(8).

=20 _________________________________________________ Ramprasad Gowrishankar Consultant Infomerica Incorporated --------------------------------- Do you Yahoo!? Mail SpamGuard - Read only the mail you want. *Archives: *Manage Subscriptions: *Leave Group: mailto:leave-informatica-l@Groups.ITtoolbox.com *Need Subscription Help?

Mailto:Listmaster@ITtoolbox.com *Terms of Use: *Copyright (c) ITtoolbox and message author. No redistribution. Amit When you import this data it will create the record area automatically, there will be nly one record area and one table for the following book. Your body data is split into nme add1 and city, each char field, and your supp code and supp name will occur 4 times, which i assume each occurance pointing to a zone or something.