>        I am running TSM 4.1.3 on OS390.  I am trying to run a batch job
>that has a list of select commands  to validate the contents of different
>filespaces.  If one of the filespaces is empty or the does not have a match
>for the select command I get the following message and it does not continue
>on to the next select command.  IS there a way around this?   Is there any
>good documentation anywhere on the SQL commands anywhere?
>ANR2034E SELECT: No match found using this criteria.
>ANS8001I Return code 11.
>ANS8029E Macro processing terminated.

By "batch job", you mean a TSM Macro?
Consider using TSM Server Scripts instead: they are similar to Macros,
except live in the TSM db and provide rudimentary conditional processing,
per Return Codes documented in Appendix C of the Admin Ref manual.

There is a lot of SQL info out on the web.  Some sites I've found useful:
  SQL:  http://www.katungroup.com/   Select "Database" from lefthand panel menu
        http://www.sqlcourse.com/       http://www.sqlcourse2.com/
        http://www.dcs.napier.ac.uk/~andrew/sql/
        http://w3.one.net/~jhoffman/sqltut.htm    Intro to SQL
        "Using the ADSM SQL Interface"  (by IBMer Andy Raibeck)
            http://www.uni-karlsruhe.de/~rz57/ADSM/3rd/handouts/raibeck.ps
            (a PostScript file, to print or see with a utility like the free
             Ghostscript or GSview)

Richard Sims, BU