on 2011 Apr 20 4:43 PM
Hi
How can I setup the the dbsrv12 process at startup with the option for the reserved keyword = 'LIMIT', which is by default disabled in SQL Anywhere 12. In an Interactive SQL session I can set it with SET OPTION PUBLIC.reserved_keywords = 'LIMIT', but I need it to set it persistant for a given dbsrv12 process or database. An additional question is how to do this setup when the dbsrv12 process starts up database (files) created with version 11 or 10 of SQL Anywhere. Do they have to be at least UPGRADEd or do they even have to be rebuilt for full functionality?
The article from Sybase describing the (new) situation is here: http://iablog.sybase.com/paulley/2010/04/keywords-and-upgrades/
Best regards, Robert
PS: I had quite a hard time to figure out what's going on when I changed from SQL Anywhere 11 to 12, as the application shows a weird behaviour in suppressing records when used with ORDER BY and LIMIT.
From my understanding Set Option should set the option permanent for the database. You could try this through the user interface of Sybase central if you have the feeling that it is not working wih dbisql. reserved_keywords is a database option so you will need to set it per database (not per engine)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In order to automatically set this (or other options) as default for newly created databases, you may add this (or adapt the existing value) in the saopts.sql file in the scripts subdirectory of your SQL Anywhere installation.
(Note, I have not used this approach myself so this is a mere guess. But a similar way exists to set authentication information for OEM databases.)
EDIT: saopts.sql is used with v10 and before. v11 and above seem to use the script optdeflt.sql in the according directory. Note: I am not sure whether these scripts are overwritten when applying MRs or EBFs. Handle with care:)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
To make it default, depends of the version and engine:
https://groups.google.com/forum/m/#!topic/venenuxsarisari/J9VfoUaV_XY
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
69 | |
9 | |
8 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.