Results 1 to 5 of 5

Thread: DSNUTILB Load

  1. #1
    Join Date
    Aug 2008
    Posts
    3

    Unanswered: DSNUTILB Load

    Hi,

    Can anyone let me know how to load a field in a table with CURRENT DATE using DSNUTILB .

    Thanks in Advance.

    Thank you,
    Rajan Babu.

  2. #2
    Join Date
    Dec 2005
    Posts
    273
    high,

    you can't specify this in the load-control-statement.

    If the column is NOT NULL WITH DEFAULT, just omit that column in the load-control-statement, as CURRENT DATE is the default value.

    otherwise, you have to modify the load dataset before loading it into the table

  3. #3
    Join Date
    Aug 2008
    Posts
    3

    DSNUTILB Load

    Thank you Umayer,

    Can you please let me know is there anyway to load CURRENT DATE - 1 DAY ?

  4. #4
    Join Date
    Dec 2005
    Posts
    273
    "CURRENT DATE - 1 DAY" cannot be specified as a default value.

    Best way is, to modify the load dataset before loading it into the table

  5. #5
    Join Date
    Aug 2008
    Posts
    3

    DSNUTILB Load

    Thank you!!! Umayer

Posting Permissions

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