RE: SQL question - Library that file resides in as a column in SE LECT stmt output.

Or create an external UDF in RPG to pick up the library

Cheers
Colin.W

-----Original Message-----
From: DeLong, Eric [mailto:EDeLong@xxxxxxxxxxxxxxx] 
Sent: 17 February 2004 16:04
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: SQL question - Library that file resides in as a column in SE
LECT stmt output.


You could construct the SQL statement dynamically......

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Rusling, John B. (Alliance) [mailto:jbrusling@xxxxxxxxxxxxxxx]
Sent: Tuesday, February 17, 2004 9:49 AM
To: 'rpg400-l@xxxxxxxxxxxx'
Subject: SQL question - Library that file resides in as a column in SELECT
stmt output.


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.
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

This e-mail has been sent by a company of Bertram Group Ltd, whose registered 
office is The Nest, Rosary Road Norwich NR1 1TF. 
This message, and any attachments, are intended solely for the addressee and 
may contain privileged or confidential information.  If you are not the 
intended recipient, any disclosure, copying, distribution or any action taken 
or omitted to be taken in reliance on it, is prohibited and may be unlawful.  
If you believe that you have received this email in error, please contact the 
sender immediately. Opinions, conclusions and statements of intent in this 
e-mail are those of the sender and will not bind a Bertram Group Ltd company 
unless confirmed in writing by a director independently of this message. 
Although we have taken steps to ensure that this email and any attachments are 
free from any virus, we advise that in keeping with good computing practice the 
recipient should ensure they are actually virus free.