Re: TSM on OS/390 and SQL Question.

2001-06-06 Thread John Naylor
Gene, You can specify a DD statement in your jcl for an output file eg //DSMOUTDD DSN=JNAYL0R..ADSM.BACKUP.D010606, // DISP=(NEW,KEEP),UNIT=3390,SPACE=(CYL,(1,1)), // DCB=(RECFM=VB,LRECL=250,BLKSIZE=25000) //INPUTDD * RUN CHECK_TOTAL_BACKUP DD:DSMOUT Gene

Re: TSM on OS/390 and SQL Question.

2001-06-06 Thread Alan Davenport
It's as simple as NOT putting spaces next to the and signs. I use this script to count the amount of tapes eligible for reclamation: select count(volume_name) as carts from volumes where pct_reclaim60 and stgpool_name='TAPEPOOL' If I were to have a space next to the it will not work but by