CODEWITHSUNDEEP
phpdb2ibm-midrangeunixodbcdb2-400
tpk
tpk

Reputation: 2131

php + unixODBC + DB2 + DESCRIBE = token not valid?

Code I am trying to run:

$query = "DESCRIBE TABLE TABLENAME";
$result = odbc_exec($h, $query);

The result:

PHP Warning: odbc_exec(): SQL error: [unixODBC][IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0104 - Token TABLENAME was not valid. Valid tokens: INTO., SQL state 37000 in SQLExecDirect in ...

There were no other problems with SELECT, INSERT, UPDATE or DELETE queries on the same connection. Is this a syntax error?

Upvotes: 1

Views: 3279

Answers (4)

Paul Morgan
Paul Morgan

Reputation: 32568

This statement can only be embedded in an application program. It is an executable statement that cannot be dynamically prepared. It must not be specified in Java.

From the iSeries DB2 SQL Reference.

Upvotes: 1

Ian McLaird
Ian McLaird

Reputation: 5585

The iSeries flavor of DB2 does not support the SQL DESCRIBE statement. Instead, you have to query the system table:

select * from qsys2.columns where table_schema = 'my_schema' and table_name = 'my_table'

Upvotes: 6

pmg
pmg

Reputation: 108986

If you just need the column names try

select * from <TABLE> where 0 = 1

I don't know how to get the column types, indexes, keys, &c

Upvotes: 0

Mike Wills
Mike Wills

Reputation: 21275

To me it looks like you need to provide a way for the statement to return a value "Valid tokens: INTO" tells me that. I haven't used DESCRIBE before, but I would imagine that it returns something.

Interactive SQL doesn't allow the command so I can't really help you much further than that.

BTW, add the iSeries tag to your question. You might get a few more answers that way.

Upvotes: 0

Related Questions