DSXchange

Hi Mates,

I went for the sqlplus option. Thanks Saravanan. It's not that elegant but it's easier to implement.

Thanks all for the assistance. This forum is very useful.

Cheers,
Melquior

Hi there, I know that this topic was covered before using odbc plug-in to call a stored procedure but it seems to me so sloppy. So I would like to know if there is any other way to call a oracle procedure in oracle oci plug-in. I have tried calling the procedure in the after tab in oci plug-in but n...

You don't even need to use User Defined sql if you are doing that just to add the hint. With Column Generated I add it in the Derivation of the first field selected... works like a champ. For select statements anyway. :wink: Post the complete sql and the complaint. Thanks guys, I have sorted it out...

Hi,

I am trying to use the hint /*+ append */ on a user-defined sql (insert) but datastage complains about the syntaxe. Any ideas on how to work around this?

Cheers,