Vsam Files In Informatica Powercenter
'Hello friends, How to connect to COBOL/VSAM from Informatica? What are the settings to be done from both Mainframe & Informatica side? Which section of the COBOL code to be changed/added? Are there any spl keywords to add in COBOL pgm so that Informatica can look before connecting? Could you please let me know the procedure please. Thanks in advance, Gautam.
Informatica Powercenter Pdf
//.- INTERESTED IN THIS MESSAGE? RELATED CONTENT - The Business Value of HP-UX 11i: Lower TCO and increase ROI (White Papers) In Sydney! (Blogs) Data Mining (Wiki) RE: complete development environment question (Groups) -.// '. To connect to mainframe VSAM sources, you can use PowerExchange. As far as pulling in Cobol VSAM sources, you need to add specific header information which is described in the Informatica Designer Help. Basically, it gives you the info to add around a copy book that more or less makes the copy book sort of look like a program - including a data section etc.
I am new to mainframe systems and we have a requirement to extract data from VSAM files. Informatica to pull data from VSAM files. Ana powerCenter. Vsam Files In Informatica. Vsam Files In Cobol Informatica OWB. File containing OCCURS and REDEFINES can be processed using Informatica PowerCenter.
Hope that's some help. Bob Doucette -Original Message- From: gautama.
Via informatica-l mailto:informatica-l@groups.ittoolbox.com=20 Sent: Wednesday, March 29, 2006 4:38 AM To: Doucette, Robert Subject: informatica-l Connecting Informatica with Mainframes (COBOL,VSAM) Hello friends, How to connect to COBOL/VSAM from Informatica? What are the settings to be done from both Mainframe & Informatica side? Which section of the COBOL code to be changed/added? Are there any spl keywords to add in COBOL pgm so that Informatica can look before connecting? Could you please let me know the procedure please. Thanks in advance, Gautam.
=20 //.- INTERESTED IN THIS MESSAGE? RELATED CONTENT - Scorecard-On-Demand CRM Market (White Papers) A Plan (Blogs) Hummingbird (Wiki) RE: complete development environment question (Groups) -.//. Gautam, In the manual there are instructions how to import a cobol VSAM fil= e as data source.
In the source definition, you can import that file as source. If you want to denormalize the file description, you may have to eliminate the occurs clauses and define them individually. The example cobol file looks something like this. IDENTIFICATION DIVISION. ENVIRONMENT DIVISION.
SELECT DEA-PRCTR ASSIGN TO 'ANAME'. DATA DIVISION. FILE SECTION. FD DEA-PRCTR.
01 DEA-PRCTR. 02 BUSINESS-ACTIVITY-CODE PIC X(1). 02 PRCTR-NAME PIC X(40). 02 STATE PIC X(2). 02 ZIP PIC X(5).
WORKING-STORAGE SECTION. PROCEDURE DIVISION. Give the file an extension name '.cbl' Anand On 3/29/06, gautama. Via informatica-l wrote: Hello friendsHow to connect to COBOL/VSAM from Informatica? What are the settings to be done from both Mainframe & Informatica side? Which section of the COBOL code to be changed/added?
Are there any spl keywords to add in COBOL pgm so that Informatica can look before connecti= ng ? Could you please let me know the procedure please. Thanks in advance, Gautam. //.- INTERESTED IN THIS MESSAGE?
RELATED CONTENT - The Business Value of HP–UX 11i: Lower TCO and increase ROI (White Papers) Piracy (Blogs) Data Mining (Wiki) RE: complete development environment question (Groups) -.//.
The bundle contains the following set of listings. Visit individual listings for details.
PowerCenter mapping sample to demonstrate loading heterogeneous targets using a single mapping. PowerCenter mapping sample demonstrating the processing of XML Data. This listing describes how a VSAM COBOL file containing OCCURS and REDEFINES can be processed using Informatica PowerCenter. A sample implementation demonstrating the features of Informatica Web Services Hub. PowerCenter Web Services Provider is used to implement a web service that can be used to send email from within a mapping.