ADSM-L

SQL commands in TSO/batch

1998-05-26 17:13:14
Subject: SQL commands in TSO/batch
From: Julie Phinney <jphinney AT HUMANA DOT COM>
Date: Tue, 26 May 1998 16:13:14 -0500
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
<Prev in Thread] Current Thread [Next in Thread>
  • SQL commands in TSO/batch, Julie Phinney <=