Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    18

    Unanswered:

    What is equivalant of desc table command of oracle in DB2?

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    assuming that in oracle desc stands for describe

    C:\Program Files\IBM\SQLLIB\BIN>db2 describe table eone.tdb_patch_dtl

    Column Type Type
    name schema name Length Scale Nulls
    ------------------------------ --------- ------------------ -------- ----- -----
    TITLE SYSIBM VARCHAR 100 0 No
    ACTION SYSIBM CHARACTER 1 0 No
    APPLIEDON SYSIBM TIMESTAMP 10 0 No
    REMARK SYSIBM VARCHAR 100 0 Yes

    4 record(s) selected.


    C:\Program Files\IBM\SQLLIB\BIN>db2 describe select * from eone.tdb_patch_dtl

    SQLDA Information

    sqldaid : SQLDA sqldabc: 896 sqln: 20 sqld: 4

    Column Information

    sqltype sqllen sqlname.data sqlname.length
    -------------------- ------ ------------------------------ --------------
    448 VARCHAR 100 TITLE 5
    452 CHARACTER 1 ACTION 6
    392 TIMESTAMP 26 APPLIEDON 9
    449 VARCHAR 100 REMARK 6

    Rahul Singh

Posting Permissions

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