|
You can set compatibility options for the open connection using SET statement [T-SQL]. The list of other compatibility options is available here. p.s. if you like my googling skills, feel free to accept this answer, otherwise other members and me would like to know what kind of compatibility you are looking for. |
Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 03 Jul '18, 05:52
question was seen: 2,102 times
last updated: 04 Jul '18, 09:13
What compatibility mode are you trying to enable?
what ever I can. I need it for current session, but it would not let me. I tried set compatibility_mode on in Interactive sql, but no luck
I am using Sybase 16
I can only find compatibility_mode documented for Adaptive Server Enterprise (ASE). This forum is for SQL Anywhere and its components. If your question is related to ASE, you may want to ask this question in the
SAP Adaptive Server Enterprise Community.
What do you mean by "open session"?
Do you mean "open client"? If so, are you trying to use SQL Anywhere dbisql to edit an ASE database?
yes, I have query that was working in Sybase 11. After upgrade to Sybase 16 I have query that takes ages to execute. So, our plan is to set compatibility mode ON for that query. In document on Sybooks online http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00967.1550/html/MigrationGuide/CBHJACAF.htm
there is option, but I am unable to set it. Not in Interactive sql, not in dbisql. When I set it, it just end without any resault
This forum is for SqlAnywhere, I guess you should ask the question here: https://www.sap.com/community/tag.html?id=67837800100800005166