Information
Space announcement: BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.

Supplied date pattern exits


This section describes the characteristics of the sample formatted date pattern exits provided with File-AID/Data Solutions.

Supplied Date Pattern Exits

Load Module Name

Date Pattern

Data Type(s)

Description

Example

MONTH-DAY-YEAR 

UDAA0100

MMDDYY

B,C,N,P

6 DIGIT Gregorian

090197

UDAA0102

MMDDCCYY

B,C,N,P

8 DIGIT Gregorian

09011997

UDAA0101

MM*DD*YY

C,N

8 CHAR. Gregorian

09/01/97

UDAA0103

MM*DD*CCYY

C,N

10 CHAR. Gregorian

09/01/1997

UDAA0112

MMMDDYY

C

7 CHAR. Gregorian

SEP0197

UDAA0113

MMM*DD*YY

C

9 CHAR. Gregorian

SEP/01/97

UDAA0114

MMMDDCCYY

C

9 CHAR. Gregorian

SEP011997

UDAA0115

MMM*DD*CCYY

C

11 CHAR. Gregorian

SEP/01/1997

UDAA0130

MDY

C

3 CHAR. Gregorian

090197 Pseudo packed.

UDAA0132

MMDDCCYYJJJ

B,C,N,P

11 DIGIT Gregorian/Julian

09011997244

UDAA0141

MMDDYYJJJ

B,C,N,P

9 DIGIT Gregorian/Julian

090197244

UDAA0137

MMYY

B,C,N,P

4 DIGIT Gregorian

0997 No day of month.

UDAA0140

MMCCYY

B,C,N,P

6 DIGIT Gregorian

091997 No day of month.

YEAR-MONTH-DAY

UDAA0104

YYMMDD

B,C,N,P

6 DIGIT Gregorian

970901

UDAA0106

CCYYMMDD

B,C,N,P

8 DIGIT Gregorian

19970901

UDAA0105

YY*MM*DD

C,N

8 CHAR. Gregorian

97/09/01

UDAA0107

CCYY*MM*DD

C,N

10 CHAR. Gregorian

1997/09/01

UDAA0138

DB2-TIMESTAMP

C,N

26 CHAR. Gregorian

1997-09-01- 23.59.59.999999

UDAA0116

YYMMMDD

C,N

7 CHAR. Gregorian

97SEP01

UDAA0117

YY*MMM*DD

C,N

9 CHAR. Gregorian

97/SEP/01

UDAA0118

CCYYMMMDD

C,N

9 CHAR. Gregorian

1997SEP01

UDAA0119

CCYY*MMM*DD

C,N

11 CHAR. Gregorian

1997/SEP/01

UDAA0124

YYMMDD-9COMP

B,C,N,P

6 DIGIT Gregorian

029098 (970901) 9’s complement

UDAA0125

CCYYMMDD-9COMP

B,C,N,P

8 DIG. Gregorian

80029098 (19970901) 9’s complement

UDAA0127

CYYMMDD-18

B,C,N,P

7 DIGIT Gregorian

0970901 (18970901) Digit 1: 0=18yy, 1=19yy, ETC.

UDAA0128

CYYMMDD

B,C,N,P

7 DIGIT Gregorian

0970901 (19970901) Digit 1: 0=19yy, 1=20yy, ETC.

UDAA0136

CYYMMDD-9COMP

B,C,N,P

7 DIGIT Gregorian

9029098 (19970901) Digit 1: 9=19yy, 8=20yy, ETC.

UDAA0133

CCYYMMDDJJJ

B,C,N,P

11 DIGIT Gregorian/Julian

19970901244

UDAA0134

CCYYJJJMMDD

B,C,N,P

11 DIGIT Gregorian/Julian

19972440901

UDAA0135

CFODATE

P

5+3 DIGIT Gregorian Two separate packed fields.

02373001 (19970901) MMMMMDDD (00001001 = 1/1/1800)

UDAA0209

YMD

C,M

3 Byte unsigned packed, Gregorian

970901

UDAA0210

CYMD

C,M

4 Byte unsigned packed, Gregorian

19970901

UDAA0211

YMD-9COMP

C,M

3 Byte, unsigned packed, 9s compliment, Gregorian

020998

UDAA0212

CYMD-9COMP

C,M

4 Byte, unsigned packed, 9s compliment, Gregorian

80020998

YEAR-MONTH

UDAA0126

CCYYMM

B,C,N,P

6 DIGIT Gregorian

199709 No day of month.

UDAA0139

YYMM

B,C,N,P

4 DIGIT Gregorian

9709 No day of month.

YEAR 

UDAA0129

CCYY

B,C,N,P

4 DIGIT Gregorian

1997 Just year.

UDAA0131

YY

B,C,N,P

2 DIGIT Gregorian

97 Just year.

DAY-MONTH-YEAR 

UDAA0108

DDMMYY

B,C,N,P

6 DIGIT Gregorian

010997

UDAA0110

DDMMCCYY

B,C,N,P

8 DIGIT Gregorian

01091997

UDAA0109

DD*MM*YY

C,N

8 CHAR. Gregorian

01/09/97

UDAA0111

DD*MM*CCYY

C,N

10 CHAR. Gregorian

01/09/1997

UDAA0120

DDMMMYY

C,N

7 CHAR. Gregorian

01SEP97

UDAA0121

DD*MMM*YY

C,N

9 CHAR. Gregorian

01/SEP/97

UDAA0122

DDMMMCCYY

C,N

9 CHAR. Gregorian

01SEP1997

UDAA0123

DD*MMM*CCYY

C,N

11 CHAR. Gregorian

01/SEP/1997

JULIAN DATES 

UDAA0200

YYDDD

B,C,N,P

5 DIGIT Julian

97244

UDAA0208

YYDDDHHMM

B,C,N,P

9 DIGIT Julian With time.

972442359

UDAA0201

CCYYDDD

B,C,N,P

7 DIGIT Julian

1997244

UDAA0202

00YYDDD

B,C,N,P

7 DIGIT Julian

0097244 (1997244) Digits 1-2: 00=19yy, 01=20yy, etc.

UDAA0203

YYDDD-9COMP

B,C,N,P

5 DIGIT Julian

02755 (97244) 9’s complement

UDAA0204

CCYYDDD-9COMP

B,C,N,P

7 DIGIT Julian

8002755 (1997244) 9’s complement

UDAA0205

00YYDDD-9COMP

B,C,N,P

7 DIGIT Julian

9902755 (1997244) 9’s complement and 99=19yy, etc. 98=18YY =

UDAA0206

CYYDDD

B,C,N,P

6 DIGIT Julian

097244 (1897244) Digit 1: 0=18yy, 1=19yy, etc.

UDAA0207

CYY-DDD

P

3+3 DIGIT Julian Two separate packed fields.

197244 (1997244) Digit 1: 0=18yy, 1=19yy, etc.

Miscellaneous

UDAA0213

YYQ-QUARTAL

B,C,N,P

3 DIGIT Gregorian

973

UDAA0214

CCYYMMDD-MORIZ

B,C,N,P

8 DIGIT Gregorian

10029099

UDAA0215

CCYYMMDD-HYPER

B,C,N,P

8 DIGIT Gregorian

19970133

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Compuware File-AID/Data Solutions 21.01