Hi Experts, I've got the following code in MS-SQL-Server
DECLARE @TotAcct VARCHAR(20)
SET @TotAcct = ( SELECT COUNT(*) FROM ACCOUNT a )
PRINT 'Total Account: ' + @TotAcct
Which works fine but I'm migrating it to DB2. I have the following:
CREATE VARIABLE TotAcct INTEGER;
SET TotAcct = ( SELECT COUNT(*) FROM ACCOUNT a);
DISPLAY 'Total Account: ' + TotAcct;
DROP VARIABLE TotAcct;
Trouble is I cannot figure out how to print the output as I've done in SQLServer.
I'm probably just missing something. Does anyone have any ides?