var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Can I execute a stored proc thru SQL ? (DB2 OS390 ver 7)
Can I execute a stored proc thru SQL ? (DB2 OS390 ver 7)
Yes, you can. Use call stored proc name.
can you please give me some examples...
I ment an example with sql statement like SELECT etc...
I was trying to use the stored proc TDB2PLDD.WCM888
This SP Accepts a parameter as partial string S1 and gets a value from column A of table 1 where that partial string is found.
So if we pass the parameter as tdb2pldd.wcm888(CIND) it should return value 'CINDY' from Table 1 if column A of the table is having the value CINDY
So how shall I frame my Select statement using this stored proc ?
Thanks for all the help/info
You cannot call a stored proc embedded into a SELECT statement. You can do what you need to do if you create a function. Suggest taking the proc code and creating a function.