Results 1 to 2 of 2

Thread: db2 V 7 alter

  1. #1
    Join Date
    Sep 2003

    Unanswered: db2 V 7 alter

    there is a requirement to change the existing decimal (20,3) datatype to decimal (25,3) datatype in a table with records. if i m correct one cannot alter the column length to increase the length.
    I drop and recreate the table with the increased length after a unload.
    if the data is loaded back to the newly created table with the increased col length, will the load be succesful.

    pls suggest any inputs to handle this scenario

  2. #2
    Join Date
    Nov 2002
    you are correct, and you would still us the same load card that got created from thhe unload

    Isn't DB2 fun!

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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