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 10.5.5
  • All Products

Table of Contents

Search

  1. Preface
  2. PowerExchange Navigator Introduction
  3. Data Maps
  4. Data Maps for Specific Data Sources
  5. Copybooks
  6. Registration Groups and Capture Registrations
  7. Extraction Groups and Extraction Maps
  8. Personal Metadata
  9. Database Row Test
  10. PowerExchange Navigator Examples
  11. Appendix A: PowerExchange Functions for User-Defined Fields
  12. Appendix B: User Access Method Programs
  13. Appendix C: Application Groups and Applications
  14. Appendix D: Data Map Properties
  15. Appendix E: Record, Field, and Table Properties
  16. Appendix F: DTL__CAPXTIMESTAMP Time Stamps
  17. Appendix G: Trace for Creating a Memory Map When Importing a COBOL Copybook

Navigator User Guide

Navigator User Guide

Back Next

Database Row Test Dialog Box

Database Row Test Dialog Box

In the Database Row Test dialog box, you can set options for a database row test.
The dialog box includes the following options:
DB Type
The type of data source or access method. For extraction maps, default is
CAPXRT
.
Select an option and enter information in the related fields that depend on the option type:
Option
Description
Related Fields
AS4_META - Use this option only at the direction of Informatica Global Customer Support.
-
-
CAPX
An access method that reads changes from PowerExchange Condense condense files or PowerExchange Logger for Linux, UNIX, and Windows log files in batch and then stops.
In the
Override File Name
 field, optionally enter the name of the file that overrides the default file name.
CAPXRT
An access method that reads changes directly from the change stream or from PowerExchange Condense condense files or PowerExchange Logger for Linux, UNIX, and Windows log files in real time.
In the
Override File Name
 field, optionally enter the name of the file that overrides the default file name.
DB2
DB2 for z/OS, DB2 for i5/OS, and DB2 for Linux, UNIX, and Windows databases
In the
SSID or DBName
 field, enter the DB2 database name, or for DB2 for z/OS, enter the subsystem ID or data-sharing group name.
DB2390IMG
DB2 for z/OS image copy of uncompressed table spaces from a remote system
In the
Override File Name
 field, optionally enter the name of the file that overrides the default file name.
In the
SSID
 field, enter the DB2 for z/OS subsystem ID.
DB2400C
An access method that uses ODBC standard calls to access DB2 for i5/OS data
In the
SSID or DBName
 field, enter the DB2 database name.
DB2UDB
DB2 for Linux, UNIX, and Windows database
In the
SSID or DBName
 field, enter the DB2 database name.
IMSUNLD
IMS unload file
In the
File Name
 field, enter the name of the IMS unload file.
MSSQL
Microsoft SQL Server database
In the
DSN
 field, enter the SQL Server instance name.
In the
Database
 field, optionally enter a database name that overrides the database name that is specified for the connection.
MYSQL
MySQL database server
In the
Server
 field, enter the server name or IP address of the MySQL server where the source database is located.
NRDB
Nonrelational data sources such as a VSAM data sets, IMS databases, or flat files.
This data source type uses a three-tier naming convention in the generated SQL.
In the
Override File Name
 field, optionally enter the name of a file that overrides the default file name from the data map.
In the
File Password
 field, enter the password for the file, if required.
NRDB2
Nonrelational data sources
This data source type uses a two-tier naming convention in the generated SQL.
In the
Override File Name
 field, optionally enter the name of a file that overrides the default file name from the data map.
In the
File Password
 field, enter the password for the file, if required.
ODBC
ODBC data source
In the
DSN
 field, enter the ODBC data source name.
In the
Database
 field, enter the database name.
ORACLE
Oracle database
In the
SQL*Net Name
 field, optionally enter a TNS name for the Oracle instance.
PGSQL
PostgreSQL database server
Server
. The database server name.
Simulator
This option is primarily for Informatica internal use. Do not select it.
Ignore the
DB Qual1
 field.
TASK_CTRL
Option that enables you to issue a PowerExchange Listener command through the PowerExchange Navigator.
-
Location
Select the node name of the location of the data source.
This field lists the locations that are defined in NODE statements in the DBMOVER configuration file on the PowerExchange Navigator system. A value of
local
 indicates that the source is on the PowerExchange Navigator system.
If you are testing an IMS data map with the DL/1 access method, enter the node name of the location where the netport job runs. If you testing an IMS data map with the ODBA access method, enter the node name for the location where the PowerExchange Listener runs.
User ID
A user ID that allows access to the source. The type of user ID depends on the source type and PowerExchange security settings in the SECURITY statement of the DBMOVER configuration file.
For a source on a supported Linux, UNIX, or Windows system, if you have enabled PowerExchange LDAP user authentication and, if applicable, disabled relational pass-through authentication, the user ID is the enterprise user name. For more information, see the
PowerExchange Reference Manual
.
For a Microsoft SQL Server source for which you use Microsoft NTLM and Active Directory authentication, enter the user ID in the format
domain
\
user_name
. Then in the
Password
 field, enter the password for this user ID.
Password
A password for the user ID, if specified.
If the source is on an i5/OS or z/OS system, you can enter a valid PowerExchange passphrase instead of a password. An i5/OS passphrase can be from 9 to 31 characters in length. A z/OS passphrase can be from 9 to 128 characters in length. A passphrase can contain the following characters:
  • Uppercase and lowercase letters
  • The numbers 0 to 9
  • Spaces
  • The following special characters: 
    ’ - ; # \ , . / ! % & * ( ) _ + { } : @ | < > ?
    The first character is an apostrophe.
Passphrases cannot include single quotation marks (‘), double quotation marks (“), or currency symbols.
On z/OS, the allowable characters in the IBM IRRPHREX exit do not affect the allowable characters in PowerExchange passphrases.
On z/OS, a valid RACF passphrase can be up to 100 characters in length. PowerExchange truncates passphrases longer than 100 characters when passing them to RACF for validation.
To use passphrases, ensure that the PowerExchange Listener runs with a security setting of SECURITY=(1,N) or higher in the DBMOVER member. For more information, see "SECURITY Statement" in the
PowerExchange Reference Manual
.
Fetch
The type of information that the database row test accesses and displays. The options that are available depend on the
DB Type
 value. For the
TASK_CTRL
 type, this field lists the type of command to issue to a PowerExchange Listener.
For personal metadata profiles, the
Fetch
 list is not available, and the default value is
Data
.
The following table describes the options in the
Fetch
 list:
Option
Available for Data Source Types
Description
Columns
All, except TASK_CTRL
Displays metadata for columns.
Data
All, except TASK_CTRL
Displays rows of data.
Foreign keys
All, except TASK_CTRL
Displays metadata for foreign keys.
Primary keys
All, except TASK_CTRL
Displays metadata for primary keys.
Procedure Cols
  • AS4_META
  • DB2
  • DB2400C
  • ODBC
  • Simulator
Displays metadata for specific stored procedures.
Procedures
  • AS4_META
  • DB2
  • DB2400C
  • ODBC
  • Simulator
Displays metadata for the available stored procedures.
Records
  • NRDB
  • NRDB2
Displays metadata for NRDB and NRDB2 records.
Schemas
  • CAPX
  • CAPXRT
  • DB2
  • DB2390IMG
  • DB2400C
  • DB2UDB
  • IMSUNLD
  • MSSQL
  • MYS
  • NRDB
  • NRDB2
  • ODBC
  • ORACLE
  • PGSQL
Displays metadata for schema names for the specified data source type.
Tables
All, except TASK_CTRL
Displays metadata for tables.
List Locations
TASK_CTRL
Displays information about the NODE statements that are defined in the DBMOVER configuration file on the system where the PowerExchange Listener is running.
List Task
TASK_CTRL
Displays information about each active PowerExchange Listener task, including the TCP/IP address, port number, application name, access type, and status.
Stop Task
TASK_CTRL
Stops an individual PowerExchange Listener task based on the application name that you specify.
Default is
Data
. Use
Data
 to preview data.
Access Methods
The
Access Methods
 list is available if you selected the following combinations of options:
  • The
    DB Type
     value is
    NRDB
     or
    NRDB2
    , and the
    Fetch
     value is
    Tables
     or
    Columns
  • The
    DB Type
     value is
    CAPX
     or
    CAPXRT
    , and the
    Fetch
     value is
    Tables
    .
Select one or more access methods if you want to retrieve information for specific access methods. PowerExchange adds filtering keywords to the DTLDESCRIBE statement in the
SQL Statement
 box.
If you do not select an access method, the DTLDESCRIBE statement returns information for all access methods.
The following table describes the options in the
Access Methods
 list:
Access Method
Description
DTLDESCRIBE Keyword
DM_ADABAS
Adabas
A
DM_CAPX
  • CAPX
  • CAPXRT
C
DM_DATACOM
Datacom
X
DM_DB2
  • DB2 for i5/OS
  • DB2 for z/OS
Z
DM_DB2390IMG
DB2390IMG
G
DM_DB2UNLD
DB2 unload file
W
DM_DL1
IMS DL/1 batch
D
DM_ESDS
VSAM ESDS
E
DM_IDMS
IDMS
I
DM_KSDS
VSAM KSDS
K
DM_MQ
MQSeries
Q
DM_ODBA
IMS ODBA
O
DM_RRDS
VSAM RRDS
N
DM_SEQ
Sequential data set or flat file
S
DM_TAPE
Tape
T
DM_USER
User access method
U
DM_XDB2
DB2 for i5/OS or DB2 for z/OS extraction map. Displayed only if the data source type is CAPX or CAPXRT,
B
DM_XDB2UDB
DB2 for Linux, UNIX, and Windows extraction map . Displayed only if the DB Type is CAPX or CAPXRT,
V
DM_XMSSQL
Microsoft SQL Server extraction map. Displayed only if the DB Type is CAPX or CAPXRT,
L
DM_XORACLE
Oracle extraction map. Displayed only if the DB Type is CAPX or CAPXRT,
P
To clear all selections in the
Access Methods
 list, right-click in the
Access Methods
 list and click
Deselect All
.
SQL File
Uses a file that contains an SQL statement instead of using the generated SQL in the
SQL Statement
 box. If you select this option, enter the path and file name of the SQL file in the
SQL File
 box, or click the Browse button to browse to the file.
Default is cleared.
Edit
Enabled if the
SQL File
 option is selected.
Click
Edit
 to edit the SQL file specified in the
SQL File
 box.
SQL Record Length
Enabled if the
SQL File
 option is selected.
The record length of the SQL in the SQL file.
SQL Statement
Displays the generated SQL, DTLDESCRIBE SQL, or PowerExchange Listener command statement for the specified data source type and
Fetch
 options.
You can edit the statement in the
SQL Statement
box.
If you select the
SQL File
 option, the
SQL Statement
 box is disabled.
PowerExchange generates the following statements in the
SQL Statement
box for the following data source type and
Fetch
 option combinations:
  • Any data source type except
    TASK_CTRL
    , and
    Data
     in the
    Fetch
     list
    An SQL statement is generated and displayed in the
    SQL Statement
     box. PowerExchange generates the following SELECT statement for data maps that use a two-tier naming convention: 
    select * from schema.
    map_table
    PowerExchange generates the following SELECT statement for data maps that use a three-tier naming convention: 
    select * from 
    schema
    .
    map
    .
    table
  • Any data source type except
    TASK_CTRL
     and a metadata option in the
    Fetch
     list
    A DTLDESCRIBE statement is generated and displayed in the
    SQL Statement
     box. The metadata options include
    Columns
    ,
    Foreign Keys
    ,
    Primary Keys
    ,
    Procedure Cols
    ,
    Procedures
    ,
    Schemas
    , and
    Tables
    .
  • The
    TASK_CTRL
     data source type and a PowerExchange Listener command in the
    Fetch
     list
    A PowerExchange Listener command is generated and displayed in the
    SQL Statement
     box.
    Use the
    AS4_META
     data source type at the direction of Informatica Global Customer Support.
Meta Data Filters
Depending on the selected
DB Type
 option and the
Fetch
 option, optionally enter filter criteria in the
Meta Data
 fields.
None of the filter fields are available if you select
Data
 in the
Fetch
 list.
In any filter field, you can use the following wildcard characters:
  • Asterisk (*) represents one or more matching characters.
  • Question mark (?) represents a single matching character.
The following table identifies the filter fields that are available for different combinations of
DB Type
 and
Fetch
 options:
DB Type
Fetch Options
Filter Fields
AS4_META, Simulator
Columns, Foreign Keys, Primary Keys, Tables
  • Table
CAPX, CAPXRT, DB2390IMG, IMSUNLD, NRDB2, MYSQL, Oracle, PGSQL
Columns, Foreign Keys, Primary Keys, Tables
  • Schema
  • Table
CAPX, CAPXRT, DB2390IMG, IMSUNLD, NRDB2, MYSQL, Oracle, PGSQL
Schemas
  • Schema
DB2, DB2400C, DB2UDB
Columns, Foreign Keys, Primary Keys, Tables
  • Creator/Schema
    For DB2 for i5/OS, maximum length is 10 characters. For DB2 for z/OS, maximum length is 128 characters
  • DBName/Definer
  • Table
    For DB2 for i5/OS, maximum length is 32 characters. For DB2 for z/OS, maximum length is 128 characters.
DB2, DB2400C, DB2UDB
Schemas
  • Creator/Schema
DB2, DB2400C, ODBC
Procedure calls, Procedures
  • Catalog
  • Schema
  • Procedure Name
MSSQL, ODBC
Columns, Foreign Keys, Primary Keys, Tables
  • Owner
  • Table
For both fields, maximum length is 128 characters.
MSSQL, ODBC
Schemas
  • Owner
NRDB
Columns, Foreign Keys, Primary Keys, Records, Tables
  • Schema
    Maximum length is 10 characters.
  • Mapname
    The name of a PowerExchange data map. Maximum length is 10 characters.
  • Table
    Maximum length is 128 characters.
NRDB
Schemas
  • Schema
Also, in the
Meta Data
 group box, select any of the following check boxes if available:
  • Respect case
    . By default, text entered in the filter fields is converted to the standard case of the data source. Select this check box for the filter fields for which you do
    not
     want PowerExchange to convert text to the standard case of the data source. For example, for an Oracle source, uppercase is the standard. If this check box is cleared, the entries
    scott
     and
    SCOTT
     would both be converted to
    SCOTT
    . However, if you selected this check box, the
    scott
     entry would be retained in lowercase.
  • Comments
    . Select this check box to include any comments in the metadata that the row test fetches for database objects.
  • Extensions
    . Select this check box to return extended metadata, if appropriate for the select data source type.
Advanced
Available for the
CAPX
,
CAPXRT
,
DB2390IMG
,
IMSUNLD
, IMS
NRDB
, and
NRDB2
 data source types.
Click
Advanced
 to display the
Advanced Parameters
 dialog box. In this dialog box, you can enter parameter values that override certain settings in PowerExchange configuration files, data maps, and extraction maps.
Application
Required for the
CAPX
 and
CAPXRT
 data source types.
The application name. Enter a character string of 1 to 20 characters.
Escape Character
Enter the escape character that to use to delimit an asterisk (*) or question mark (?) that is used as a literal value rather than as a wildcard in the
Meta Data
 filter boxes.
For example, if you specify an escape character of
~
, a filter value of
tab*
 returns all tables beginning with
tab
. A filter value of
tab~*
 returns the table named
tab*
.
Do not use an escape character with data sources that are multibyte-enabled.
Get
n
 Rows
Indicates the number of rows to fetch.
Valid values are 1 to 99999. Default is 10.
A large value can increase PowerExchange Navigator response time and CPU usage.
Skip First
n
 Rows
Indicates the number of initial rows of data to skip when the row test fetches data for display. If you are performing a row test on a large file, you can use this option to have the row test skip to a specific point in the file before displaying data. This option can help you diagnose problems in large files faster because only the data of potential interest is returned for analysis.
This option is available only if you select
CAPX
,
CAPXRT
,
NRDB
,
NRDB2
, or
IMSUNLD
 in the
DB Type
 list and select
Data
 in the
Fetch
 list.
Valid values are 0 to 99999. Default is 0, which causes no rows to be skipped.
A large value can increase PowerExchange Navigator response time and CPU usage.
If you are testing a SEQ data map that has the
Variable
 property set to
VS
 to indicate a variable-length stream data file, the database row test returns warning message PWX-03042 and the
Skip First
n
 Rows
 option is ignored. The PowerExchange Navigator cannot skip rows for a variable-length data file.
0 COMMENTS
We’d like to hear from you!