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é
Please sign in to leave a comment.
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.
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é