Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2010
    Posts
    94

    Unanswered: DB2 Column Length Reduction

    Hello,

    It looks like we cant reduce the length of a column in DB2 LUW 9.5 FP2; even if the new/reduced column length would not cause data truncation.

    Any ideas on how we could achieve column length reduction?

    Thanks!

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Re-create the table and reload data.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Oct 2010
    Posts
    94
    Thanks n_i,

    Re-create the table and reload data.
    We did have that down as an option. Althought, is that the only way out? some of these tables are sizeable?

  4. #4
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    some of these tables are sizeable?
    Sounds like not the way you want. Suggest you proceed as mentioned.
    Re-create the table and reload data.

Posting Permissions

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