Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    18

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

    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.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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?

  3. #3
    Join Date
    Oct 2003
    Posts
    18
    Unfortunately not.
    We'll send a change request to the export team...

    Thanks for your reply!

    S.B.

    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •