Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2003
    Posts
    58

    Question Unanswered: unload with convertion

    hi, i have fields in tables that we want to convert from date to timestamp.
    in the new unload i don't find a way to get out a converted data (not like the old one where we could write a SQL statement).

    is there a way i don't know about ?

    thanks!

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    What DB2 platform and release?

  3. #3
    Join Date
    Jun 2003
    Posts
    58
    os/390

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I assume you have DB2 version 7?

    You can use DSNTIAUL which is now provided in source code format only and must be assembled (if not already done so). Check out Appendix D of the Version 7 Utility Reference manual.

    Using this program you can unload the data with a select statement and then concatenate the date and a string that is the rest of the time stamp.

  5. #5
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

    Re: unload with convertion

    use this:

    timestamp(<date>,<time>)

    for example:

    timestamp ('2003-01-01','00.00.00')

    Abel.

Posting Permissions

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