Stored Procedures
Dear All,
Is it possible to reference a variable in a select statement in
a stored procedure, i.e
create procedure test_one ()define TABLENAME CHAR(20);
[snip]
select * from systables
where tabname = TABLENAME <----------------+[snip] |
end procedure |
|
This is what I am talking about.
Thanks,
##################### Manoj Schroff (Systems Engineer)
##### ############## Dallas Systems plc
##### ### Ocean House
## * # The Ring Tel: +44 (0)1344 420144
##### ## Bracknell Direct: +44 (0)1344 418448
###### # Berkshire
###### #### RG12 1AH Fax: +44 (0)1344 418400
####### ### ##### manoj@dalsys.com
############# ###### manoj@pipe.demon.co.uk
############# ####### http://www1.dalsys.com:8080/
##################### http://www.pipe.demon.co.uk
+--------------------------------------------------------------+
|"He who laughs last, obviously did not understand the joke !!"|
+--------------------------------------------------------------+