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.4.0
  • 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

Field Properties - Name

Field Properties - Name

View or edit field properties.
Field Name
A user-defined name for the field. The field name must be unique within the record.
When you add a column to a table based on this field, you reference this field name.
Valid characters are ASCII alphanumeric characters and the pound and yen sign. The first character must be alphabetic. Maximum length is 30 characters.
Adabas Name (Adabas only)
The Adabas name for the field.
Field Type, Precision, Scale, and Length
The field type that PowerExchange uses and the valid precision, scale, and length values for that field type. For some field types, you can edit the precision, scale, or length.
Do not edit field properties for DB2 10 for z/OS TIMESTAMP columns for which metadata was imported from a DB2 catalog or DB2 unload file.
The following table lists, for each field type, the values that you can enter for precision, scale, and length:
Field Type
Precision
Scale
Length
BIN
-
-
1 through 32767
BLOB
-
-
1 through 8000000
CHAR
-
-
1 through 32767
CLOB
-
-
1 through 8000000
DOUBLE
-
-
-
FLOAT
-
-
-
GROUP
-
-
-
NUM16
-
0 through 5
-
NUM16U
-
0 through 5
-
NUM32
-
0 through 10
-
NUM32U
-
0 through 10
-
NUM64
-
0 through 19
-
NUM64U
-
0 through 19
-
NUM8
-
0 through 3
-
NUM8U
-
0 through 3
-
NUMCHAR
1 through 100
0 through 50
1 through 100
PACKED
1 through 31
0 through 31
-
SPACKED
1 through 31
0 through 31
-
UPACKED
1 through 31
0 through 31
-
UZONED
1 through 31
0 through 31
-
VARBIN
-
-
1 through 32767
VARCHAR
-
-
1 through 32767
ZONED
1 through 31
0 through 31
-
You can specify a precision of up to 31 for certain field types, such as the PACKED field type, that are mapped to the Decimal transformation datatype in PowerCenter. However, PowerCenter supports a maximum precision of 28 for the Decimal datatype if you enable high precision in the session properties, or a maximum precision of 16 if you do not enable high precision. If you specify a precision greater than 28, PowerCenter uses a transformation datatype of Double, rather than Decimal, with a precision of 16.
For z/OS data sources, the field types correspond to COBOL PIC clauses. The following table shows the COBOL PIC clause for each field type and the precision, scale, and fixed length based on that PIC clause:
Field Type
COBOL PIC Clause
Maximum Precision
Scale
Fixed Length
BIN
X(nn)
-
-
32767
CHAR
X(nn)
-
-
32767
DOUBLE
COMP-2
-
-
8
FLOAT
COMP-1
-
-
4
GROUP
X(nn)
-
-
-
NUM16
S9(4) COMP
4
0 through 5
2
NUM16
S9(4) COMP-5
4
0 through 5
2
NUM16U
9(4) COMP
4
0 through 5
2
NUM16U
9(4) COMP-5
4
0 through 5
2
NUM32
S9(9) COMP
9
0 through 10
4
NUM32
S9(9) COMP-5
9
0 through 10
4
NUM32U
9(9) COMP
9
0 through 10
4
NUM32U
9(9) COMP-5
9
0 through 10
4
NUM64
S9(18) COMP
19
0 through 19
8
NUM64
S9(18) COMP-5
19
0 through 19
8
NUM64U
9(18) COMP
20
0 through 19
8
NUM64U
9(18) COMP-5
20
0 through 19
8
NUMCHAR
9(nn)
100
0 through 50
50
PACKED
1
S9(nn) COMP-3
31
0 through 31
-
SPACKED
2
-
31
0 through 31
-
UPACKED
3
9(nn) COMP-3
31
0 through 31
-
UZONED
9(nn)
31
0 through 31
-
VARBIN
X(nn) set by 2-byte length field
-
-
32767
VARCHAR
X(nn) set by 2-byte length field
-
-
32767
VARCHAR
X(nn) set by 2-byte length field
-
-
32767
ZONED
9(nn)
31
0 through 31
-
1. A PACKED field is a standard MVS binary decimal packed field. It contains a C, A, or F nibble to indicate a positive value or a B or D nibble to indicate a negative value. It can have an odd precision such as X'12345C' or an even precision such as X'01234C'.
2. An SPACKED field is a short number without a sign nibble. It is used to store information such as dates. It can have an odd precision such as X'012345' or an even precision such as X'1234'.
3. A UPACKED field is an unsigned PACKED field. However, it still contains the F nibble. It can have an odd precision such as X'012345F' or an even precision such as X'01234F'.
Implied Decimal Point
Select this option for a NUMCHAR field that implies, but does not actually contain, a decimal point. By selecting this option, PowerExchange aligns the data in the field. Default is cleared.
Field Format
For CHAR, VARCHAR, ZONED, UZONED, PACKED, SPACKED, or UPACKED field types, provides a character mask that defines the format of the input data and generates the appropriate output field. You can select a date, time, or time stamp format.
Date formats are:
  • D2-MM-Y2
  • D2-MM-Y4
  • MM-D2-Y2
  • MM-D2-Y4
  • Y2-MM-D2
  • Y4-MM-D2
Time formats are:
  • HH-MI-SA
  • HH-MI-SS
Time stamp formats are:
  • Y4-MM-D2-HH.MI.SS.N6
  • Y4-MM-D2-HH.MI.SS.N9
  • Y4-MM-D2-HH.MI.SS.N0 to Y4-MM-D2-HH.MI.SS.N12 (DB2 10 for z/OS extended-precision time stamps)
  • Y4MMD2HHMISSN6
  • Y4MMD2HHMISSN9
  • Y4MMD2HHMISSN0 to Y4MMD2HHMISSN12 (DB2 10 for z/OS extended-precision time stamps)
Do not edit DB2 V10 for z/OS extended-precision time stamps based on a DB2 catalog or unload file that you imported for a data map.
Click the arrow to the right of the
Field Format
 list to insert specific mask characters.
The following table describes the character masks in the field formats. The table also lists additional character masks that you can add to a field format:
Character Mask
Description
Valid Input Values
D2
Days.
1 through 31
D3
Julian days.
1 through 366
For example, 001 is January 1 and 032 is February 1.
HH
Hours.
-
HH12
Hours in 12-hour format.
1 through 12
HH24
Hours in 24-hour format.
0 through 23
LA
The before noon or after noon indicator, in long format.
a.m. or p.m.
LM
Long month.
January, February, and so on
MI
Minutes.
0 through 60
MM
Months.
1 through 12
NATDATE
Adabas natural date.
-
NATTIME
Adabas natural time.
-
N
n
Number of fractional seconds.
The
n
 value is a number from 1 through 6.
SA
The before noon or after noon indicator, in short format.
am or pm
SM
Short month.
The first three characters of a long month name, such as APR, SEP, and so on
SS
Seconds.
0 through 60
Y2
A 2-digit year.
00 through 99
Y4
A 4-digit year that includes the century and the year.
0000 through 9999
YYY
A year and century indicator (th or st, such as 20th or 21st) for PACKED fields.
Examples:
990823 for 23rd Aug 1999
1000914 for 14th Sep 2000
1010129 for 29th Jan 2001
The following table shows example field formats with their corresponding input and output values:
Example Format
Input
Output
D2-MM-Y2 HH:MI/N3
02-07-09 02:45/123
20090702024500123000
Y2-SM-D2
09-APR-01
20090401
HH:MI:SS LA
01:30:23 p.m.
133023
Y2D3
96366
19990401
Use the following guidelines when entering character masks:
  • Use alphanumeric characters in the mask if the field is nonnumeric.
  • In the character mask, match the spacing and characters in the input.
  • If the mask is longer than the input field, PowerExchange adds leading zeros to the input field to pad it to the length of the mask. For example, if the mask six characters long, such as D2MMY2, and the input field is five bytes long, PowerExchange adds a leading zero to pad the field to six characters.
  • If any characters are missing from the mask, PowerExchange uses values from the
    Data Defaults
     tab on the
    Data Map Properties
     dialog box to fill in the missing values.
Record ID Values
Assigns one or more record ID values to a field, which PowerExchange uses in conjunction with an operator to filter the records at run time.
In the
Record ID Values
 list, select the
=
 or
<>
 button to select the operators for filtering the data:
  • Click the
    =
     button to display records with a record ID value equal to any of the specified record ID values.
  • Click the
    <>
     button to display records with a record ID value that is greater than or less than (but not equal to) any of the specified record ID values.
The data map stores the record IDs but not the data. Record ID fields might not appear in the column view of the data. You cannot use record ID filtering on WRITE.
To enter a hexadecimal record ID value of '0000', enter the following value for the record ID: 
X'0000'
Optional Field
Allows empty input fields. If the input field has no data, the output column is empty and marked as NULL. You must select this option for VARCHAR fields that you define as arrays.
Clear this option to prohibit input fields without data. Default is cleared.
Nullable Field
Allows a NULL value for a field.
Clear this option to use the characters that the data source uses to indicate a NULL value. Default is cleared.
The following properties appear for a field in in a DB2 unload file data map:
Null Field Control
Enables the
Field Name
 box. Default is cleared.
Field Name
If you select the
Null Field Control
 option, the
Field Name
 box is displayed or enables you to enter the control field that contains the null indicator for the field.
Hide from Table
Hides any columns based on this field in the
Table
 window. Default is cleared.
0 COMMENTS
We’d like to hear from you!