Results 1 to 2 of 2

Thread: DB2 & Java

  1. #1
    Join Date
    May 2004
    Posts
    2

    Unanswered: DB2 & Java

    Hello all.

    has anyone ever tried to describe a table using Java for a DB2 database. (Works really well for Oracle)

    Have tried just about everything from

    DESCRIBE tableName; (Oracle)
    DESCRIBE SELECT * FROM userName.tableName;

    Is there an easy way to do this ?

    thanks again all .. any help would be appreciated.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    That's because 'DESCRIBE' is not a SQL statement - it's a CLP command. You can only issue SQL statements with JDBC, such as this one:
    Code:
     
    select 
       colname, typeschema, typename, length, scale, nulls 
    from 
       syscat.columns 
    where 
       tabname='TABLENAME' and tabschema='USERNAME'

Posting Permissions

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