You are not logged in.
I've connected a tSybaseInput to a tSybaseConnect and managed to select some rows from a table (via a tFileOutputDelimted component - as there is not a BCP out function available!)
Now I want to add a stored procedure execution to the steps to write the select to an external file. I've added a sSybaseSP and set the SP Name as db.owner.sp_name but I'm getting a problem with the JAVA execution:
Exception in component tSybaseSP_1
com.sybase.jdbc3.jdbc.SybSQLException: Stored procedure 'handoff.dbo.upload_gats' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode.
It seems to be faily well docmented as a JAVA issue. But any ideas. Should I add the no chain option to the tSybaseConnection component - in the 'Additional JDBC paramters? What is the TALEND work around for this?