SQL question - Library that file resides in as a column in SELECT stmt output.

["Rusling, John B. (Alliance)" <jbrusling@xxxxxxxxxxxxxxx>]

I have a SELECT statement, looks like this -


SELECT code, id, seq, startpos
  FROM sf
     ....+....1....+....2....+....3....+. 
     Code   ID   Sequence  Start Position 
     SR10   IT        0            1      
     SR10   IT        0           36      
     SR10   IT        0           37      
     SR10   IT        0           38      
     SR10   IT        0           39      
     SR10   IT        0           40      
     ********  End of data  ********      


I'd like the library that the file (sf) resides in to be a column in
the output of the SELECT statement.


     ....+....1....+....2....+....3....+....4....+....5....+ 
     Code   ID   Sequence  Start Position     Library
     SR10   IT        0            1          MYLIB
     SR10   IT        0           36          MYLIB
     SR10   IT        0           37          MYLIB
     SR10   IT        0           38          MYLIB
     SR10   IT        0           39          MYLIB
     SR10   IT        0           40          MYLIB
     ********  End of data  ********      



Is there a Function/Column keyword or something/someway to do this?



Reason for this is -

I have an file that resides in multiple libraries.
 (identical file, same fields etc.)

I'd like to check some of the field values for validity (in all the
libraries the file exists.)

I thought I might use "UNION" to put them all together and test them all at
once but this wouldn't do me any good w/o the "originating" library.

tfahmf  John B.