*urgent* [LOAD] UDB v 7.1 OS/390 DATE problem

stefanB · #1 (**permalink**) 11-07-03, 04:38

Hi NG,

we've got a very urgent problem...

We are importing data with the LOAD utility. The input DATE field data is in the format DDMMYYYY (for days) and MMYYYY (for months).
The target data format is european DD.MM.YYYY (for days) and 01.MM.YYYY (for months).

The input format is not recognizable as a DATE input to a DB2 LOAD for UDB v 7.1 OS/390.

Unfortunately we don't have any tools to rebuild the input.

How can this problem be solved?!

It is very urgent...

Appreciate everyone's help!!!!!!

S.B.

Marcus_A · #2 (**permalink**) 11-07-03, 05:17

Dates can be in any of the following formats. You can omit leading zeros for month and day. Trailing blanks can be included, but no leading blanks are allowed.
- dd.mm.yyyy
- mm/dd/yyyy
- yyyy-mm-dd
- any local format defined by your site at the time DB2 was installed.

Looks like you maybe out of luck. You don't have any programmers who can put the dashes/slashes/periods in the date?

stefanB · #3 (**permalink**) 11-07-03, 06:08

Unfortunately not.

We'll send a change request to the export team...

Thanks for your reply!

S.B.

Quote:

Originally posted by Marcus_A
Dates can be in any of the following formats. You can omit leading zeros for month and day. Trailing blanks can be included, but no leading blanks are allowed.
- dd.mm.yyyy
- mm/dd/yyyy
- yyyy-mm-dd
- any local format defined by your site at the time DB2 was installed.

Looks like you maybe out of luck. You don't have any programmers who can put the dashes/slashes/periods in the date?

Internet Services

Web Development

Digital Marketing

Consumer Tech