Does anyone use this (IMHO fantastic) open source database with WebFOCUS?This message has been edited. Last edited by: Kerry,
WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux :
September 27, 2011, 05:52 PM
Waz
Have you checked to see if it is in the list of SQL adapters in your WebFOCUs server or Developer Studio ?
Its in mine, and I'm on 7.6.6 DS
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
September 28, 2011, 04:18 AM
Wep5622
It is listed, I just wonder how well it's supported? For example, I notice there's no mention of HOLD FORMAT POSTGRESQL or something similar in the Help files.
From the little bits of relevant-looking documentation I can find PG would appear to be less well supported than for example DB2, MSSQL or Oracle. Technically, PG could be supported just as well (those are its direct competitors).
For a laugh, I tried:
TABLE FILE CAR
PRINT CAR
BY COUNTRY
ON TABLE HOLD AS PGCAR FORMAT POSTGRESQL
END
And got: 0 NUMBER OF RECORDS IN TABLE= 10 LINES= 10 0 PS FILE SAVED ...
ROFL, that's not what I asked for!
WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux :