Issue with server routines calling teradata database.
Posted: Fri Aug 29, 2008 8:31 am
Hi,
I am facing an issue with server routines when I trying to migrate from DB2 to Teradata.
Routines with Db2 calls was written in DS 7.5 versions
We are using DS version 8 and changing the routine which calls Teradata version 12 now.
below is the snapshot of initial routine:------------------------------------------
sSQL = 'connect to ':pUKDWDATABASE:' user ':pUKDWUSERNAME:' using ':pUKDWPASSWORD
cmd = 'db2 -x "':sSQL:'"'
if sMSG = '' then sMSG = cmd
Call DSExecute('UNIX',cmd,sOutput,sError)
Below is the snapshot of routines changed to Teradat:
-------------------------------------------------------------
sSQL = ' bteq .logon ':pTDDATABASE:'/':pTDUSERNAME:', ':pTDPASSWORD
if sMSG = '' then sMSG = cmd
Call DSExecute('UNIX',sSQL,sOutput,sError)
It compiles. But it jus hangs up and does not run.
Please let me know if there are any solutions.
I am facing an issue with server routines when I trying to migrate from DB2 to Teradata.
Routines with Db2 calls was written in DS 7.5 versions
We are using DS version 8 and changing the routine which calls Teradata version 12 now.
below is the snapshot of initial routine:------------------------------------------
sSQL = 'connect to ':pUKDWDATABASE:' user ':pUKDWUSERNAME:' using ':pUKDWPASSWORD
cmd = 'db2 -x "':sSQL:'"'
if sMSG = '' then sMSG = cmd
Call DSExecute('UNIX',cmd,sOutput,sError)
Below is the snapshot of routines changed to Teradat:
-------------------------------------------------------------
sSQL = ' bteq .logon ':pTDDATABASE:'/':pTDUSERNAME:', ':pTDPASSWORD
if sMSG = '' then sMSG = cmd
Call DSExecute('UNIX',sSQL,sOutput,sError)
It compiles. But it jus hangs up and does not run.
Please let me know if there are any solutions.