A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Which works fine but I'm migrating it to DB2. I have the following:
DECLARE @TotAcct VARCHAR(20) SET @TotAcct = ( SELECT COUNT(*) FROM ACCOUNT a ) PRINT 'Total Account: ' + @TotAcct
CREATE VARIABLE TotAcct INTEGER; SET TotAcct = ( SELECT COUNT(*) FROM ACCOUNT a); DISPLAY 'Total Account: ' + TotAcct; DROP VARIABLE TotAcct;
|Is there any way with db2look, or perhaps with some other system command, where you can see the exact command structure that created a database?||12||299|
|Which of these database tools could be used to monitor critical or disruptive events in DB2 UDB LUW environment? Please see body of text.||2||174|
|How to create a stored procedure in AS400||1||225|
|Problem with a LIKE clause with a "*" inside in VB.Net accessing a DB2/400 table||7||109|