Archives of the TeradataForum

Message Posted: Fri, 05 Mar 2004 @ 11:31:25 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Store procedure Select into

From:		Victor Sokovin

i'm just having a first trial with STORE PROCEDURE (V2R4 / Bteq ) and i experience some difficulties with a SELECT COUNT(*) INTO :param FROM TABLE WHERE condition;

is it possible to set a parameter with a count(*) result ?

the message reports an incorrect sql statement.

I am not aware of any specific restrictions on COUNT. The statement should normally work unless you build it dynamically. There is a restriction on SELECT ... INTO with dynamic SQL. Perhaps if you could post the exact piece of code causing the problem, somebody could say more.

Regards,

Victor