Dear all,
I was trying to stress a SQL Anywhere (network) server with concurrent INSERT xacts from 20 concurrently running dbisql[c] scripts. The database was created using default settings, pre- populated with a 1M2 row table (the good old IQ megaph...
Hi all,
I'm running SQL Anywhere 17 (2757) on a win7 Pro (64bit) notebook and a Raspberry Pi 3 with Raspbian. I wonder if SQL Anywhere Cockpit is supposed to run on the Raspberry.
I ran this sequence against the Win7 machine:
@set pwd=cockTale
@set...
Dear forum members,
I wonder if anyone of you has experienced something similar or can help.
On a customer's server (Win 2012 64bit), I've created an ODBC Data Source using the iAnywhere Oracle ODBC driver (v.16) on top of an "Oracle instant client"....
You may want to check
https://developers.sap.com/trials-downloads.html?search=SDK%20for%20SAP%20Adaptive%20Server%20Enterprise%2016
This seems to work for P- Users (SAP Community Users, free registration req'ed).
HTH
Volker
DB-TecKnowledgy
I checked the note and followed the download link but neither SDK FOR ASE nor SDK FOR SAP ASE showed any result.
My best guess usually is the ASE Express Edition. jConnect afaik is Pure Java, so the OS restriction of the XE shouldn't be an issue.
The query plan and statistics should provide a hint. The way you describe the behavior (> 5 min sequential; < 1 min 8 way parallel) indicates that parallel execution is efficient. My first look would be at the differences between the two execution pl...
Evolution of statement:
with teQ ("Quarter") as (select distinct quarter (OrderDate) from SalesOrders),
teY ("Year") as (select distinct year (OrderDate) from SalesOrders)
select teQ."Quarter", teY."Year"
from teQ cross join teY
order by teY."Ye...
If you provide a table or table expression covering all combinations of your cube dimensions, OUTER JOIN it with the base table as the inner table, and finally COUNT against a column in the inner table (which would be treated as NULL for non-matches)...
