Syntax for calling a SQLServer procedure from powerbuilder
Posted on 2007-10-17
I have a SQL Server procedure which accepts three params and output is an integer. How do I call (I mean syntax) this from powerbuilder, I want the integer value to be available in powerbuilder into a varaiable. I would like to script it without creating a datawindow/datastore.
is it like
ll_ret_value = EXECUTE procedureName (:param1, :param2, :param3)
The procedure in SQL server is like:
CREATE PROCEDURE procedureName (@param1 varchar(11),@param1 varchar(11),@param1 varchar(11), @param4 int OUTPPUT)
This is a very straight forward question I guess.