Do anybody know the syntax of a script with a select statement and
redirected output under AIX environment?

example:
file /tmp/cccc contains:
select 'checkout libv' as "ADSM Cmd", -
  b.library_name, a.Volume_name, -
  'checkl=y rem=y' as "ADSM Parameter" from -
  volumes a,libvolumes b -
  where a.stgpool_name= '$1' -
  and a.status = 'FULL' -
  and a.volume_name = b.volume_name order by a.volume_name   >
/tmp/adsmlist.lst

adsm> define script xxx file=/tmp/cccc
adsm> run script xxx  stgpool01
ANR2907E Unexpected SQL operator token - '>'.
                                                             |
         ....................................................V..........
         .volume_name = b.volume_name order by a.volume_name >
/tmp/adsmlist.lst

In /tmp/adsmlist.lst I expect the sql-result. Start the same command from
the adsm command line and all things are ok.

regards
h.petersen