Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • PowerExchange for CDC and Mainframe H2L
  • All Products

Table of Contents

Search

  1. Abstract
  2. Supported Versions
  3. Creating an ODBC Data Source to Run a DB2 for z/OS Stored Procedure Transformation

Creating an ODBC Data Source to Run a DB2 for z/OS Stored Procedure Transformation

Creating an ODBC Data Source to Run a DB2 for z/OS Stored Procedure Transformation

Back Next

Implementing a Stored Procedure Transformation in a Mapping

Implementing a Stored Procedure Transformation in a Mapping

To implement a Stored Procedure transformation for a DB2 for z/OS stored procedure in a mapping, complete the following high-level tasks:
  1. Create and compile the DB2 stored procedure on the z/OS system.
  2. Ensure that the PowerExchange Listener is running on the z/OS system.
  3. Create and configure an ODBC data source on Windows. For more information, see the
    PowerExchange Reference Manual
    .
  4. In the Transformation Developer, click
    Transformation > Import Stored Procedure
    .
  5. In the
    ODBC data source
     box, enter or browse to the ODBC data source that you configured.
  6. In the Mapping Designer, add the Stored Procedure transformation to the mapping.
    When you import the stored procedure, the Mapping Designer does not qualify the stored procedure name with the owner. If you leave the name as is, PowerExchange executes any unqualified stored procedures by using the user ID of the PowerExchange connection as the schema name. So, if the user ID on the PowerExchange connection is USER1, PowerExchange calls unqualified stored procedures as USER1.
    procedurename
    .
  7. If the schema of the stored procedure is different from the user ID that starts the PowerExchange Listener, edit properties for the Stored Procedure transformation in the mapping.
    On the
    Properties
     tab in the
    Edit Transformations
     dialog box, add the schema name to the stored procedure name in the
    Stored Procedure Name
     box. For example, if the stored procedure name is ZEMPS1 and the user ID that starts the PowerExchange Listener is USER2, enter the following value in the
    Stored Procedure Name
     box: 
    USER2.ZEMPS
For more information about implementing Stored Procedure transformations in mappings, see the
PowerCenter Transformation Guide
.
0 COMMENTS
We’d like to hear from you!