Stored Procedures in Datastage

[admin]

Yes.

Do you have a history of the posts to this list? This was discussed a month or so back.

We are using Oracle stored procedures. The only real problem is the inability to get a status (success or otherwise) back from the procedure.

-----Original Message-----
From: Raymond Daignault [SMTP:diadoci@hotmail.com]
Sent: Saturday, September 09, 2000 7:38 AM
To: informix-datastage@oliver.com
Subject: Stored Procedures in Datastage

Hi Everyone,

Im doing some playing with Datastage and Stored Procedures. Is there anyone

out there using Stored Procedures?

If so are they working OK or are you experiencing problems with them.

Thanks in Advance,

Ray Daignault
Cellarmaster Wines _________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.


*************************************************************************
This e-mail and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in
error, please notify the sender by return e-mail, and delete this e-mail from your in-box. Do not copy it to anybody else

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

[admin]

Hi Everyone,

Im doing some playing with Datastage and Stored Procedures. Is there anyone
out there using Stored Procedures?

If so are they working OK or are you experiencing problems with them.

Thanks in Advance,

Ray Daignault
Cellarmaster Wines _________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.

[admin]

Hi,

I am new to the email alias. I am interested in knowing the issues/problem
of using stored procedures with DataStage.

Im trying to import Informix stored procedure definition into DataStage
(tried with different versions 3.6, 4.0 on NT and Unix) without success.
They all come back with error message during importing.

Also, do I really have to import the stored procedure definition
successfully before I can use in the transfomer stage ?


Thanks and regards,

At 04:46 PM 9/8/00 +1000, you wrote:
>Yes.
>
>Do you have a history of the posts to this list? This was discussed a
>month or so back.
>
>We are using Oracle stored procedures. The only real problem is the
>inability to get a status (success or otherwise) back from the
>procedure.
>
>-----Original Message-----
>From: Raymond Daignault [SMTP:diadoci@hotmail.com]
>Sent: Saturday, September 09, 2000 7:38 AM
>To: informix-datastage@oliver.com
>Subject: Stored Procedures in Datastage
>
>Hi Everyone,
>
>Im doing some playing with Datastage and Stored Procedures. Is there
>anyone
>
>out there using Stored Procedures?
>
>If so are they working OK or are you experiencing problems with them.
>
>Thanks in Advance,
>
>Ray Daignault
>Cellarmaster Wines
>_______________________________________________________________________
>__
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>Share information about yourself, create your own public profile at
>http://profiles.msn.com.
>
>
>***********************************************************************
>**
>This e-mail and any files transmitted with it may be confidential
>and are intended solely for the use of the individual or entity to
>whom they are addressed. If you have received this e-mail in
>error, please notify the sender by return e-mail, and delete this
>e-mail from your in-box. Do not copy it to anybody else
>
>***********************************************************************
>**

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