Results 1 to 2 of 2

Thread: tableid

  1. #1
    Join Date
    Dec 2004
    Posts
    10

    tableid

    hi, I get an error while running some sql on my db2 7.2.

    The error says Assignment of a NULL value to a NOT NULL column.... TBSPACEID=2, TABLEID=78, COLNO=9..

    How can I find out what table has ID 78 and what col has id 9 ?

    Regards

    Kris

  2. #2
    Join Date
    Dec 2001
    Posts
    79
    select tabname, colname from syscat.columns where colno=9 and tabname=(select tabname from syscat.tables where tbspaceid=2 and tableid=78)"

Posting Permissions

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