4
votes
2answers
82 views
How to avoid execution of DatabaseStart Event
When your Database contains a EVENT of type DatabaseStart and you are able to crash the Database Engine during startup with your fabulous code.
How would you fix the database to …
1
vote
1answer
19 views
Unload just users (userids and grant user permissions)?
Is there a way to just unload users (userids and grant user permissions)? Using dbunload 11.0.1.2044, many options will skip the section. The only way I've found is to do a full …
0
votes
1answer
15 views
Will updating a NULL timestamp rewrite the row?
Will a timestamp value which is updated from initial NULL to a real value lead to a rewrite of the affected row? If the NULL timestamp value has the same size as a filled timestamp …
0
votes
1answer
31 views
dbunload - How to skip data for tables?
The SQL Anywhere Unload Utility Version 11.0.1.2044 (dbunload.exe) has an option to skip unloading the data for certain tables:
-e no data output for listed tables
Why does …
2
votes
2answers
63 views
How do I fix “The ability to edit data in a linked Excel spreadsheet has been disabled”?
When trying to INSERT to an Excel 2007 sheet from SQL Anywhere 11.0.1.2276, I get the following error on Windows XP SP3:
Could not execute statement.
Server 'EXCEL': [Microsoft][ …
1
vote
4answers
63 views
How to ALTER a table created with SELECT INTO LOCAL TEMPORARY TABLE…?
SA 11.0.1.2376
When I create a local temporary table by means of a SELECT INTO LOCAL TEMPORARY TABLE, I am not able to alter that table since ALTER TABLE returns a "table not foun …
1
vote
2answers
38 views
Legacy collation matching
We unloaded 40 or so databases to Sybase 11 using
the "-an" flag and it preserved our legacy collation sequence of "850".
However, when we use dbinit to create new databases we are …
2
votes
2answers
44 views
Why does my cursor FETCH loop stop after one pass?
I am using ASA 11.0.1 build 2044.
I have a procudure that dynamically builds a command string to 1) delete rows from a table and 2) run load table to re-populate it with new data. …
1
vote
2answers
32 views
How to retrieve the names of all changed columns between to identical tables
What I'm trying to do is the following:
I'm synchronizing data from 1 database to another database using proxy tables.
Because sybase doesn't allow me to update proxy tables curre …
0
votes
0answers
27 views
How can one database prevent another from being started on the same engine?
This is a question about protecting an embedded database from external Forces Of Evil.
Let's say server S has started database D, and there is a DatabaseStart event in database D …
1
vote
1answer
31 views
How do I get a copy of procedure profiling statistics?
Hi
v10.0.1
When profiling a procedure I don't seem to be able to copy the line by line stats. You can get the procedure text but not the numbers. I wonder if they can be extract …
3
votes
4answers
146 views
Database Recovery: What Would You Do If…
Title isn't that great, so feel free to change.
Basically, I will describe an issue we had this week. I want to get responses from everyone on what you would have done in the sce …
0
votes
1answer
58 views
Return Query Result In Different Language?
We have been asked if it is possible to translate some reports to different languages on the fly (from an EN based database).
So my question is, can I translate data stored as ENG …
2
votes
2answers
39 views
MySQL proxying …
Hi,
How can I define a MySql "Remote Server" on Linux ?
Can I define some proxy table to INSERT data on MySql server ?
Thanks.
4
votes
6answers
144 views
How can I improve this stored function performance?
create function bludata.onlyNumber(in val long varchar)
returns long varchar
begin
declare sTemp long varchar;
declare iCount integer;
set iCount=1;
set sTemp='';
while i …
