Focal Point
reporting From Teradata

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4231078822

May 21, 2007, 04:47 AM
focuzsambit
reporting From Teradata
How do we set the connection attribute for Webfocus reporting from Teradata.

I mean wat is the exact syntax, like for Oracle we use below statements.

*******************************************************

ENGINE SQLORA SET CONNECTION_ATTRIBUTES RCD4PRD/apl_ccam9,proc
SQL SQLORA SET SERVER RCD4PRD
SQL SQLORA SET VARCHAR OFF
SQL SQLORA SET ORACHAR FIX
SET LINES=999
SET PAGE=OFF
SET ASNAMES=ON
SET NODATA = ''
SET EMPTYREPORT=ON
SET ALL=ON
*******************************************************

Please pass if you have any information.
Also if possible any clone program.


WF Server: 7.1.4 on Z/OS and Linux, ReportCaster
Data: DB2, DB2/UDB, Adabas, SQL Server, Oracle Output: HTML,PDF,Excel2K
WF Client: Servlet, CGI
May 21, 2007, 05:06 AM
Alan B
The basic syntax is the same, except instead of SQLORA you use SQLDBC:
ENGINE SQLDBC SET CONNECTION_ATTRIBUTES TDPn/userid,password
SQL SQLDBC SET SERVER TPDn
.
.
with suffix in mfd of SQLDBC


Alan.
WF 7.705/8.007