PowerExchange for CDC and Mainframe
- PowerExchange for CDC and Mainframe 10.5.2
- All Products
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
| -
|
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'.
|
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
|
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
|
X'0000'