PH - MS SQL Service access in Unix

[Bob Deskin]

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



From:
"Ken Langendock" <ken.langendock at rogers.com>
To:
"'cfinley'" <cfinley at xformix.com>, "'Jeff Hoffman'" 
<wonicon at optusnet.com.au>, <powerh-l at lists.sowder.com>
Date:
2009-08-14 09:04 AM
Subject:
RE: PH - MS SQL Service access in Unix
Sent by:
powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com