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

DB2/S390 Bulk Load Properties Tab

DB2/S390 Bulk Load Properties Tab

For DB2 data sources only. On the
DB2/S390 Bulk Load Properties
 tab in the
PowerExchange Data Source
 dialog box, enter the following properties to define PowerExchange for DB2 bulk load processing.
Bulk Load
Select this option to enable input on this page.
Corresponding ODBC Parameter: BULKLOAD
Load Options
The load option.
The options are:
  • INSERT
    . Insert.
  • REPLACE
    . Replace.
Corresponding ODBC Parameter: LOADOPTIONS, as follows:
  • INSERT is equivalent to LOADOPTIONS=1.
  • REPLACE is equivalent to LOADOPTIONS=4.
Delete Temporary Files
Indicates whether to delete temporary files. The options are:
  • NO.
    Temporary files are not deleted.
  • BEFORE
    . Temporary files are deleted before running the loader.
  • AFTER SUCCESS ONLY
    . For a mode type of
    JOB
    only. Temporary files are deleted after running the loader, if the return code is 0.
  • AFTER
    . For a mode type of
    JOB
     only. Temporary files are deleted after running the loader.
Corresponding ODBC Parameter: DELETETEMPFILES, as follows:
  • NO is equivalent to DELETETEMPFILES=1.
  • BEFORE is equivalent to DELETETEMPFILES=2.
  • AFTER SUCCESS ONLY is equivalent to DELETETEMPFILES=3.
  • AFTER is equivalent to DELETETEMPFILES=4.
JCL Template
The name of the JCL file template on the target system, which is a member in a PDS defined on the system where the PowerExchange Listener is running.
Default is DB2LDJCL. You must customize this JCL before using it.
Corresponding ODBC Parameter: JCLTEMPLATE
CTL Template
The name of the DB2 bulk load control file template on the target system, which is a member in a PDS defined on the system where the PowerExchange Listener is running.
If you specify a CTL template, the
Load Options
 option is ignored.
Default is DB2LDJCL. You must customize this JCL before using it.
Corresponding ODBC Parameter: CTLTEMPLATE
Mode Type
The mode type. The options are:
  • JOB
    . Submits as a job to the internal reader.
  • NOSUBMIT
    . Not submitted. Instead, creates the DB2 loader-specific control files and data files, saves them on the target system, and generates an executable JCL deck on disk.
  • TASK
    . Submits as a subtask of the PowerExchange Listener.
Corresponding ODBC Parameter: MODETYPE as follows:
  • TASK is equivalent to MODETYPE=1.
  • NOSUBMIT is equivalent to MODETYPE=2.
  • JOB is equivalent to MODETYPE=3.
Mode Time
The mode time. The options are:
  • WAIT
    . Synchronous. For a mode type of
    JOB
     or
    TASK
     only. Report the results at end the end of the job or task.
  • NOWAIT
    . Asynchronous. For a mode type of
    JOB
     or
    NOSUBMIT
     only. Returns OK when a job is submitted.
  • TIMED
    . Synchronous. For a mode type of
    JOB
     only. Wait for the specified number of seconds.
  • DATAONLY
    . For all mode types, but typically used with the
    NOSUBMIT
     mode type. Creates the data DB2 loader file.
Corresponding ODBC Parameter: MODETIME, as follows:
  • WAIT is equivalent to MODETIME=1.
  • NOWAIT is equivalent to MODETIME=2.
  • TIMED is equivalent to MODETIME=3.
  • DATAONLY is equivalent to MODETIME=4.
Time
Valid only for a mode type of
JOB
 and a mode time of
TIMED
.
A value from 0 to 99999, as follows:
  • 0
    . No wait.
  • 99999
    . Wait.
  • Any other value. The number of seconds to wait.
Corresponding ODBC Parameter: TIME
Space
The z/OS space allocation. The options are:
  • TRACK
    . Tracks.
  • CYLINDERS
    . Cylinders.
Corresponding ODBC Parameter: SPACE
Primary Space
Amount of primary space for z/OS files.
Corresponding ODBC Parameter: PRISPACE
Secondary Space
Amount of secondary space for z/OS files.
Corresponding ODBC Parameter: SECSPACE
FName
The file name on the host system. Used as the stem for files created on z/OS.
The files created are:
  • FNAME.DTL
    nnnnn
    Data for load.
  • FNAME.DTL
    nnnnn
    .CTL
    Load commands.
  • FNAME.DTL
    nnnnn
    .SQL
    SQL template - create table.
  • FNAME.DTL
    nnnnn
    .SYSPRINT
    Output from loader.
Corresponding ODBC Parameter: FNAME
0 COMMENTS
We’d like to hear from you!