Error displaying dates "9999-12-31".

Error displaying dates "9999-12-31".

book

Article ID: KB0088656

calendar_today

Updated On:

Products Versions
TIBCO Object Service Broker for z/OS -
Not Applicable -

Description

Resolution:
Using binary arithmetic it is possible to create date values greater than  "9999-12-31".
Prior to R4.1 these would display but the high order digit would be removed, e.g. "10000-01-01" would display as "0000-01-01" although the underlying data would be correct.
At R4.1 and above a conversion error is raised instead and the string is displayed as "*invalid*"

Environment:
============
ObjectStar R4.1 and Object Service Broker R5.0 on z/OS.

Symptoms:
=========
Rules manipulating dates > "9999-12-31" fail with a conversion error.

Cause:
======
Rather than display invalid data in a fixed length 12 byte field the product was changed to trap these situations.

Resolution:
===========
Add code to capture and deal with the conversion error.

Issue/Introduction

Error displaying dates "9999-12-31".