May 21, 2007, 04:47 AM
focuzsambitreporting 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.
May 21, 2007, 05:06 AM
Alan BThe 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