Friday, 13 September 2013

DB2 Supress 'The command completed with no results returned'

DB2 Supress 'The command completed with no results returned'

I'm running SQL scripts on DB2 9.7.0.6 (AIX).
Client is Embacadero's Rapid SQL 7.7
I insert the following code at the beginning of my stored procedure to
calculate the date for me.
DROP VARIABLE FOLM;
CREATE VARIABLE FOLM CHAR (10);
SET FOLM = (SELECT CURRENT_DATE - (DAY(CURRENT_DATE)-1) DAYS - 1 MONTH
FROM SYSIBM.SYSDUMMY1);
When I run the stored proc, the above code produces these three lines
before the results of my procedure:
The command completed with no results returned
The command completed with no results returned
The command completed with no results returned
How can I supress this?

No comments:

Post a Comment