DSXchange

ray.wurlod wrote:... except that the error handling is abysmal, so you had better hope that you never get any errors. ...

Exactly ! if I have errors, I see it only in Datastage logs. Perhaps you can interpreted the routine's answers ....

But I wanted just to show how to create a connexion SQL in Datastage Basic.

thx you. I found response in searching on the Internet and it work : *************************************************** ** FUNCTION ExecSQLProc(dataSource,userName,password) ==> RETURN (Ans) *************************************************** $INCLUDE UNIVERSE.INCLUDE ODBC.H ** Initialise parameter...

If your not well versed in writing routines then I would suggest a workaround. Call the stord proc. in a before/after sql tab of DRS stage or from STP stage. You dont need to write a custom routine to do this. I need a custom routine because i would like to call it in each job Master (before/after ...

Hi,


I don't know Datastage Basic for develop my own routine. I need help about us.
I would like to call a stored procedure (SQL Server) in my own routine. How ?

Thx