Hello.
I have multiple instances running. For each instance i have create links that start dbisql.exe with the Connection String for that instance.
In the String i don't include the Password for security reason.
The behaviour since years the behavi...
I have changed database file to 17.0.9.4803 from 16.0.0.2344.
After that change my Web Client Procedures no longer worked. The login proecedure can be seen as an example.
CREATE OR REPLACE PROCEDURE "dba"."alfresco_login"(
in "HostURL" varchar(256),...
Hello.
If have the following Event defined in my Database
CREATE EVENT "dba"."CLEANUP"
SCHEDULE "CLEANUP" START TIME '06:00' ON ( 0 )
AT CONSOLIDATED
HANDLER
BEGIN
-- Process something
END;
In Sybase Central the next planed execution is shown...
I get a JSON Array from an external System. When no data is available the system insert the string null in the Data. When the Data is parsed with sp_parse_json the returned data contains a 0 for that element instead of a SQL NULL.
BEGIN
declare cJs...
Sometimes the Warning helps me find a Problem when I use SUM or AVG and the existence of null values can lead to a wrong/unexpected result. I have traced a not working Query in my app down to this.
Test Case
BEGIN
declare local temporary table ...
Hello Volker. Thanks for testing.
I have changed my command to
"%SQLANY17%\\Bin64\\dbisql.exe" -c "SERVER=XXX;DBN=yyyy;UID=myuser;host=x.x.x.x:2638"
My dialog always comes up with "Connect to a running Database on another computer".
The Host and Po...
Hello Reg.
No I connect to a normal SQL Anywhere instance.
The caption of the screen shows "Connect to a SQL Anywhere Database"
Adding the -sa Parameter doesn't change the behavior.
When you say working fine for me you use the same EBF 7312 as me?...
When you have a large data set and you need to filter it you can't easily filter the raw data when you need the window function results based on the complete data set like above.