I'm trying to issue SELECT statements in a batch job on MVS. It runs
beyond the length of a line,as follows:
//SYSIN DD *
SELECT NODE_NAME,FILESPACE_NAME,BACKUP_END FROM FILESPACES WHERE
BACKUP_END < '05/26/1998'
QUIT
and gives me the error
adsm> ANR2909E The SQL statement is incomplete; additional tokens are
required.
ANS8001I Return code 3.
adsm> ANR2000E Unknown command - BACKUP_END.
ANS8001I Return code 2.
I have tried putting a continuation character in column 72, but that didn't
help.
Also, does any know how to specify Today in a select statement? So I can
say where backup_end < Today(date)-1
or something along those lines?
Thanks!!
Julie Phinney
jphinney AT humana DOT com
|