Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2011
    Posts
    57

    Question Unanswered: column doesn't appear

    Hi everyone.

    I've an issue i have a table, and I alter it to add a new column, after that i try to insert values in the column but it's like the table doesn't have the column, i tought it need a reorg but doesn't work, Could anyone help me?

    Thanks

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Is this DB2 ? Do you get an error code ?

    =
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Sep 2011
    Posts
    57
    yes, is DB2 and the error is just like the column doesn't exist:

    Code:
    SELECT IDcol FROM PRUEBA.TABLA_PR_IN2
    "IDCOL" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=4.11.69
     
    Failed queries => 1
     
    Total execution time => 0 ms
    I've already check the name of the column and it's ok

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Code:
    select "IDcol" FROM PRUEBA.TABLA_PR_IN2
    try using double-quotes
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Sep 2011
    Posts
    57
    i've already also try it, getting the same error

    Code:
    select "IDcol" FROM PRUEBA.TABLA_PR_IN2
    "IDcol" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=4.11.69

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Please run this from the command line and post results:
    db2 "describe table PRUEBA.TABLA_PR_IN2"
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  7. #7
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    You did COMMIT the transaction with the ALTER TABLE statement?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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