SQL Anywhere 17
According to the help the SQL Remote -g n option groups transactions containing fewer then n (default 20) operations.
My question is what happens if one of the grouped transactions fails, do all the transactions in the group fail?
T...
When creating an existing table I add the LOCAL ONLY syntax to prevent the creation from failing if the remote server does not exist. Is there an equivalent for procedure/functions?
Thanks,
Jim
We are adding a Cross Reference table to identify parts that are equivalents. This is the first time I have modeled this any comments or suggestions are appreciated.
Thanks
Jim
The core Parts Table has a single surrogate integer primary key "PartId...
I'm having an issue with DBISQL 17.0.11.7058 hanging on "connecting to database" in a Windows 10 environment. This occurs both when executing directly or via SQL Central. The issue started 3 - 5 days ago. I have reviewed all updates to the OS sinc...
SQL Anywhere 17.0.10.6160
I am testing the implementation of replication error and replication error piece database options. The docs say replication error procedure is called twice once with the error and then again with the SQL statement which ca...
That's my understanding as well. We use SQL Remote, we've done some work with MobiLink but most our remotes are maritime vessels with low bandwidth and inconsistent connections.
In doing some more testing the LOCAL ONLY after the CREATE EXISTING TABLLE syntax fails if the remote server is not defined. However it works if the remote server is defined but doesn't actually exist (no connection available).
When the remote ser...
Sure It's the CREATE EXISTING TABLE syntax with LOCAL ONLY for example
CREATE EXISTING TABLE Owner.TableName(
AttributeNameOne INTEGER NOT NULL,
AttributeNameTwo CHAR(128) NOT NULL
) AT 'Server;Owner;TableName' LOCAL ONLY;
You can see this i...
