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