Registered: Jun 2001
Location: USA
Posts: 3

DB2 Local Date Exit

We are facing a major data loading project where the user DATE field data is in the format YYYYMMDD. This format is not recognizable as a
DATE input to a DB2 LOAD.
I am looking at two alternatives.
1) reprocess the input (via ICETOOL) to insert '-' values so that DB2 can read YYYY-MM-DD.
2) Write a DB2 date exit (DSNXVDTX) that will either a) insert the '-'s or b) use LE (CEE) calls to convert YYYYMMDD to Lilian date, then back to ISO date.

Option 2. b) would be the most robust solution because it will actually validate the data, but I am concerned about the restrictions on DB2 exits. Specifically, No SVC calls (is CALL an SVC call). Is there a way to branch-entry into the LE modules?
Option 1 would cause a lot of setup work and ther reprocessing of Gigabytes (literally) of data.
Option 2. a) would be obviously be the quickest to implement, but if I can easily make the LE calls for 2. b) I would spend the extra time now up front.

Anybody been here before??

Report this post to a moderator | IP: Logged

Registered: Jun 2001
Location: USA
Posts: 3

With enough trial and error and reading the manuals I have found a workable solution to the problem.

Basically, we will preprocess the data because the date exit requires a 10 character input and YYYYMMDD is only 8 characaters. As long as we have to stuff characters, we will stuff it to look like YYYY-MM-DD. DB2 understands this format

Report this post to a moderator | IP: Logged