ADSM-L

Re: SQL on OS390

2001-07-13 02:46:59
Subject: Re: SQL on OS390
From: Luuk Kleibrink <luuk_kleibrink AT DELTALLOYD DOT NL>
Date: Fri, 13 Jul 2001 08:46:44 +0200
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
<Prev in Thread] Current Thread [Next in Thread>