I need to submit multiple Teradata statements using same open connection; The
first statement is a stored procedure that inserts data into a temp table in
teradata, the second retreives with a select from that table. If the
connection from first is closed then the data in temp table does not persist.

Here are the two TeraData SQL statements:

CALL APPLPROC_PHI_NE.ODS_INST_PRVDR_RFRNCE_GLOBAL('PRVD R','300022','', 1,
'', INPUT_PARM,'' );
SELECT * FROM GLOBAL_PHI_NE.ODS_INST_PRVDR;

The error from trying to run both in DTS SQL task is:

"Call cannot be submitted in multi-statement request"

Any input is appreciated.

Do you know how I can transfer data from a table in SQL Server to a table in teradata, using DTS?


EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

I tried loading data to teradata using DTS earlier, but found out that its
far more faster to use Teradata's native utility 'mload'.
--
Black Bird


"Jafer" wrote: