Hi
Can I execute a stored proc thru SQL ? (DB2 OS390 ver 7)

Thanks

Yes, you can. Use call stored proc name.

can you please give me some examples...

Thanks
Mahendra

Call db2inst1.proc()

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

Mahendra

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.

Thanks dmmac