Can't use "describe" with 0xDBE and Sybase

Hello,

I use to use "describe tablename" to get its structure but when I launch it I have an error "procedure describe not found".

Bye,
Hervé

2 comments
Comment actions Permalink

Hello.

Do you mean the error message in the Database Console tool window? I also see it, but It is not 0xDBE output, it is the database answer returned by JDBC driver.

From this document:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sqlanywhere.11.0.1/dbadmin_en11/da-guitools-secta-4195292.html
I see that DESCRIBE is available only in Interactive SQL tool. I.e. it's not a part of Transact SQL. Probably that's why the database answers so.

Not sure is it possible to support Interactive SQL, but I've created a feature request for some future consideration: https://youtrack.jetbrains.com/issue/DBE-1089

Regards,
Alexander.

0
Comment actions Permalink

Hello Alexander,


Thanks for your answer.
Yes that's what I mean, the error message appears in the Database console.

You are right concerning Interactive Sql, I can use it with this tool.

Thanks for your help and for the feature request.

Bye,
Hervé

0

Please sign in to leave a comment.