Using Stored Procedure in DataStage ?

[admin]

Hi,

1) I am having problem trying to import Informix Stored Procedure
definition into DataStage:

DSR.MetaGeta(GET.PROC.COLUMNS)
(SQLPrepare("{CALL "findcdrpackage04" (NULL,NULL,NULL)}")): BCI Error: SQLSTATE=51,CODE=-201,[Ardent][SQL Client][ODBC] [INTERSOLV][ODBC 20101 driver][20101]A syntax error has occurred.

Environment is: DataStage 3.6.3r2 on Tru64 4.0F, IDS 7.31FCx

Ive tried on a different environment with similar error message:

DSR.MetaGeta(GET.PROC.COLUMNS)(SQLPrepare("{CALL "return_call_type"
(NULL,NULL)}")): BCI Error: SQLSTATE=37000,CODE=-11060,[Ardent][SQL Client][ODBC][Informix][Informix
ODBC Driver]General error.Syntax error

Environment was: DataStage 4.01 on NT, IDS 9.20.TC1



2) Has anyone successfully used Informix Stored Procedure as a look up
function in Transformer stage ? My test procedure would have a single input
parameter and return a single value. And I would like the input rows of the
transformer stage to be passed as the stored procedures input parameter.
Is it achievable in DataStage ?



William Lam email: wlam@informix.com
Senior Consultant tel: (852)2824-0981
I.Intelligence fax: (852)2824-1863
Informix Software HK Ltd