[Bulk] RE: PH - MS SQL Service access in Unix

[Ken Langendock]

So does this mean you work against MySQL also?

Ken


-----Original Message-----
From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Bob Deskin
Sent: August 14, 2009 9:49 AM
To: 'Jeff Hoffman'
Cc: powerh-l at lists.sowder.com
Subject: [Bulk] RE: PH - MS SQL Service access in Unix

PowerHouse 4GL 8.43D1 (current version is 8.43F) and up use DataDirect 
ODBC to access SQL Server from UNIX/Linux to Windows. I can't say anything 
about performance because every network and situation is different.

As for "direct access", it depends what you mean. For all relational 
databases on UNIX/Linux, we have a data access layer that generalizes 
database calls. This data access layer hooks into the database 
gateway/client/ODBC driver which actually talks to the database.

The only way to know what your situation will be like is to test it. If 
you can get sample software and test the connection, that should be part 
of your evaluation. The nice thing is that PowerHouse makes the 
application end easy. Given a sample database, you can generate SQL as 
required and really all you need is the DATABASE statement in PDL to 
connect. Test QUICK response and also processing times in QUIZ or QTP with 
complex ACCESS statements. And note that in almost all cases, a DECLARE 
CURSOR plus a simple ACCESS <cursor> will be much more efficient than the 
corresponding complex ACCESS linkage.

Bob