DSXchange

Yes, general ODBC enterprise select and inserts work fine. In most cases the Store procedure works if it is very simple and don't pass nulls. The store procedure I am using reads values from an xml message to fill in columns of the table I am inserting.

The Store Procedured is spInsertIdealTrade which was imported into the DS as a Store Procedure. It is called from the Store Procedure stage with the folloowiing call {? = CALL spInsertIdealTrade;1 (?)} I was able to get past the original problem by adding the following 3 statements to the Stored Pro...

I don't use any Open or Close statements in the Store procedure. The unique item in the store procedure is I am reading an XML message and using path to parse the xml message to insert to a table.

I am trying to get a Stored Procedure to run from DataStage 8.0 to MS SQL server. The Store Procedure works great on SQL Server 2005, but when called from Data stage, I get the following error: APT_CombinedOperatorController,0: [DataDirect][ODBC SQL Server Driver][SQL Server]SELECT failed because th...

What does "processed" mean? I have implemented the End of Day message and it successuly stops the stop. However, it leaves the End of Day message on the queue. What do I need to do to get the message to be "processed" and deleted off the queue when the job is done.