Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2010
    Posts
    19

    Unanswered: is there sq lstatement to find type and size of table column

    hello

    i want to ask is there some way to find the type and the size of table column ?

    please help

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Syscat.columns

  3. #3
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Let's not forget that you might want to download "SQL Reference Vol.1.pdf" you can find all kind of useful info in there
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  4. #4
    Join Date
    Aug 2010
    Posts
    40
    Quote Originally Posted by josemourinho View Post
    hello

    i want to ask is there some way to find the type and the size of table column ?

    please help

    if you know the table do a describe:

    describe select * from TABLE_NAME;

  5. #5
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    really?

    wouldn't be "describe table tabname"
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

Posting Permissions

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