unable to create.......... more information (said with rising tone a la
MasterMind)

-----Original Message-----
From: Kiran K Kurapaty <kiran@...> [mailto:kiran@...]
Sent: Tuesday, 11 February 2003 10:27 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] How do I write Stored procedure ??


Hi Guys,
I was going thru Stored Procedures...
I have a TempDrs table which has only one field called DR_ID which is
of VARCHAR(50) so I wrote a small SP like...

set term ^ ;
create procedure GETDRID_TEMP( sDRID varchar(50) )
returns ( rDRID varchar(50) ) as
begin
For select DR_ID from TEMPDRS where (DR_ID = :sDRID) into :rDRID
do Suspend;
end ^
set term ; ^

but am unable to create it.. can anybody help ???

pls am waiting for your feedback.

Kiran Kumar.




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/