Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2010
    Posts
    1

    Unanswered: QL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=8, TABLEID=2580

    Hi All,

    I am trying to customize a Siebel CRM Application (backend is DB2 on AIX 64)

    I am receiving below error in the application log files:

    "
    Error Error 1 2010-01-27 14:57:53 SQLError: sqlstate 23502: [IBM][CLI Driver][DB2/AIX64] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=8, TABLEID=2580, COLNO=12" is not allowed. SQLSTATE=23502
    "

    In the above error, it is pointing to TBSPACEID=8, TABLEID=2580, COLNO=12

    How can I find the names of the tablespace, table, column respectively from above information in the DB2 database.

    I apologize for this simple question. This is the first time I am getting to DB level troubleshooting with DB2

    Please let me know your thoughts.

    Thanks and Regards,
    Rishabh

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Look at SYSCAT.TABLES and SYSCAT.COLUMNS

Posting Permissions

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