Zoltan,
This works (NOTE: don't put spaces around the comma's, this might be your
problem):
//TSO1 EXEC PGM=IKJEFT01
//SYSPRINT DD SYSOUT=X
//SYSTSPRT DD SYSOUT=X
//SYSTERM DD SYSOUT=X
//SYSOUT DD SYSOUT=X
//SYSTCPD DD DSN=SYS1.TCPPARMS(TCPDATA),DISP=SHR
//DSCOPT DD DSN=SYP.TSM.TSOADMIN.OPTIONS,DISP=SHR
//DSCLANG DD DSN=SYS2.TSM.SANSMSG(ANSMENU),DISP=SHR
//SYSTSIN DD *
DSMADMC -ID=id -PA=password -OUT='OS390 data set name' +
SELECT STGPOOL_NAME,SUM(NUM_FILES) AS FILES, +
SUM(LOGICAL_MB) AS MB,NODE_NAME FROM OCCUPANCY +
GROUP BY STGPOOL_NAME,NODE_NAME ORDER BY NODE_NAME,STGPOOL_NAME
Luuk Kleibrink
Delta Lloyd Nuts Ohra
