ADSM-L

Select help!

2000-04-18 09:06:22
Subject: Select help!
From: Tom Haddad <thaddad AT COLUMBIAENERGYGROUP DOT COM>
Date: Tue, 18 Apr 2000 09:06:22 -0400
Im running Adsm v3.1 on AIX 4.3   I want to produce this report with
SELECT.....

List the node names, their last_bytes_recvd and total the last_bytes_recvd.  I
get the info from the NODES table in the database.

When I code statement 1, i get the total. When I insert node_name and
lastsess_recvd fields  it fails with a syntax error (statement 2).

1     SELECT SUM(LASTSESS_RECVD) AS "Total Bytes" FROM NODES
2     SELECT SUM(LASTSESS_RECVD) AS "Total Bytes", NODE_NAME, LASTSESS_RECVD
FROM NODES
<Prev in Thread] Current Thread [Next in Thread>