RE: Syntax for SELECT statement Stored Procedure???

["Dave Odom" <Dave.Odom@xxxxxxxxxxxx>]

Elvis,

I modified your code for my variables and ran it via Ops Navigator.  It
"compiled" successfully.  When I run the procedure using CALL from ISQL
(STRSQL) I get the message "CALL statement complete" but no output. 
I've run the same SQL via ISQL and it completes with one row returning.

What gives?   Why can't I see any output when I use the CALL or where
is the output?

Thanks,

Dave