Hi gurus

on the OS390 server i have released the following batch job:

SELECT COUNT(*) AS NUMBER_OF_VERSIONS FROM BACKUPS -
WHERE NODE_NAME = 'EUCP01' -
AND LL_NAME LIKE 'QL%'

result:
NUMBER_OF_VERSIONS
--------------------------------------
                 1
                 1

then i have released the following job:

SELECT COUNT(*) AS "NUMBER_OF_VERSIONS" FROM BACKUPS -
WHERE LL_NAME = -
(SELECT LL_NAME FROM BACKUPS -
WHERE NODE_NAME='EUCP01' AND LL_NAME LIKE 'QL%' -
GROUP BY LL_NAME)

no results because job is swapped out .... looks like it is looping ....
any idea ???

thanks in advance.


=======================================================
             Ruud van Ruler
Shell Services International BV - ISES/32
Our Data Storage Management home page: http://sww2.shell.com/dstorage/
> Room 2A/D07
> Dokter van Zeelandstraat 1, 2285 BD Leidschendam NL
Tel : 070 - 3034644  /  Fax : 070 - 3034012
Email Internet: ruud.r.vanruler AT is.shell DOT com
                          rvanruler AT hotmail DOT com
Email X400:/S=vanRuler /I=R /C=GB /A=GOLD /P=Shell /O=IS


                                                            R.vanRuler
================================================================