Does anyone know how to get these for PG?
Creation of synonyms currently does pick up the column comments for field descriptions, but titles are missing.
I found a techdoc describing a solution for MS SQL (https://techsupport.informationbuilders.com/techsps/ht/93512015.html), but that seems rather specific to that particular RDBMS.This message has been edited. Last edited by: FP Mod Chuck,
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 :
If PG is like Oracle where you add Remarks using the COMMENT ON COLUMN syntax then you only have one extended attribute. That extended attribute will end up in the DESCRIPTION= in your synonym. SQL Server allows you to add both Titles and Descriptions with the sp_addextendedattributes and WebFOCUS will populate both TITLE= and DESCRIPTION=. When I had to add business titles to columns in an Oracle environment, I ended up using COMMENT syntax, create the synonym and replace DESCRIPTION= with TITLE= in the synonym. It's pretty nifty little trick that'll allow you to enrich the synonym with titles for all the fields.
WebFOCUS 8204, Unix, Windows
|Powered by Social Strata|