I have the following script in ISQL:
CREATE TABLE Temp (Col1 VARCHAR(10), Col2 VARCHAR(10));
INSERT INTO Temp VALUES('AAA', 'BBB');
BEGIN
DECLARE r_Temp Temp%ROWTYPE;
DECLARE v_Dummy VARCHAR(10);
SELECT MAX(Col1) INTO r_Temp.Col1 FROM Temp;
...
We have a problem with one specific procedure which often gets invalidated for unknown reasons. If the procedure is called from ISQL the message reported is "Procedure 'xxxx' is no longer valid".
When this status is reported, we usually call "ALTER P...
I discovered that Windows Performance Monitor offers counters like "User Defined Rate: Counter1" for an SQL Anywhere 17 Database, and found sa_user_defined_counter_add.
So I hoped to use the procedure to be able to track some db application events i...
This relates to https://sqlanywhere-forum.sap.com/questions/38148/how-to-interpret-diagnostic-file-with-orgeclipsejettyioeofexception
We have an installation using an ODATA server on SQL Anywhere Network Server Version 17.0.11.6933.
The installation ...
We have an installation using an ODATA server on SQL Anywhere Network Server Version 17.0.11.6933.
The installation work fine up to a certain request rate, after which the response time deteriorates rapidly. We are now trying to find the bottleneck. ...
Thanks, that fixes the problem!
Is this intended behavior or a workaround? From the docs I'd assume that the INTO VARIABLE clause is intended for putting a result into a row variable, as in "SELECT * INTO VARIABLE r_Temp FROM Temp", but r_Temp.Col1 ...
According to Release Notes this seems to be fixed bug in EBF Build 7181:
================(Build #7181 - Engineering Case #827221)================
The result from a remote procedure that returns an NCHAR, NVARCHAR, LONG
NVARCHAR, etc. column is not...
In fact we have changed the code so the events can (and do) run in parallel, which resulted in considerable better performance and user experience.
Nevertheless that hint about semaphores may be useful in the future.
If anyone wants to know, we found the (one?) cause for the troubles we had.
We were triggering events in paralell, but the event's code used a mutex to serialize access. Usually the code was running quickly so there was no problem. But under increase...
This looks very interesting, do you know how the target of the file parameter has to be encoded? Like PEM or DER or Java Certificate Storage or some PKCS#? Or is this OS dependent?
