ODBC Enterprise stage...

allavivek · Post by **allavivek** » Mon Aug 16, 2010 3:00 pm

Hi All,

Iam using odbc enterprise stage as a lookup ..performing sparse lookup of table..

problem is before lookup it should execute 2 stored procedures and based on these procedures data is dumped in to table(view actually)..

i was trying to use open/close command and trying to call procedures as

call p1(.......);
call p2(....);

I was getting error as below...

main_program: Fatal Error: Invalid close command : call p1(...);
call p2(... );

can we call Multiple procedures by this close/open option??

Thanks...

ray.wurlod · Post by **ray.wurlod** » Mon Aug 16, 2010 5:05 pm

I have a vague recollection that a doubled semi-colon is required (;;). Search DSXchange.

allavivek · Post by **allavivek** » Tue Aug 17, 2010 8:20 am

ray.wurlod wrote:I have a vague recollection that a doubled semi-colon is required (;;). Search DSXchange. ...

Hi ray,

i tried giving ;; but it didnt work ..i tried searching dsxchange but couldnt find solution..

Q.is it possible to call 2 stored procedures at a time in open/close command...

Thanks..

allavivek · Post by **allavivek** » Tue Aug 17, 2010 8:32 am

I was giving below

callin 2 procedures in block.

BEGIN
proc1(..);
proc2('..) ;
COMMIT;
END;

Not getting any errors but stored procedures are not executing..
Is above format correct to execute 2 procedures??
iam using odbc enterprise stage..

thanks..

kumar_s · Post by **kumar_s** » Tue Aug 17, 2010 8:44 am

Does it have any OUT or Return?
Try with out Aruguments.

allavivek · Post by **allavivek** » Tue Aug 17, 2010 8:56 am

kumar_s wrote:Does it have any OUT or Return?
Try with out Aruguments. ...

Yes both procedures have arguments..

kumar_s · Post by **kumar_s** » Tue Aug 17, 2010 9:02 am

Try without Arguments. I read in one of the post that ODBC are not good in handling Procedures with Arguments.
Isnt Stored procedure stage working out for you?

allavivek · Post by **allavivek** » Tue Aug 17, 2010 9:07 am

kumar_s wrote:Try without Arguments. I read in one of the post that ODBC are not good in handling Procedures with Arguments.
Isnt Stored procedure stage working out for you? ...

I need to execute 2 procedures and as os i know STP can execute only one procedure...

chulett · Post by **chulett** » Tue Aug 17, 2010 9:55 am

So use two stages.