RE: Using the contents of a filed for selection of the file

Sure,

But the second statement will be dynamic SQL that will have to be prepared and executed for each row
returned by the first statement.

The SQL statements would need to be embedded in an RPG program or in an SQL Stored Procedure.

HTH,
Charles

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jim Essinger
Sent: Friday, August 10, 2007 3:57 PM
To: Midrange Systems Technical Discussion
Subject: Using the contents of a filed for selection of the file

My question of today is, I know that in my library I have
lots of files with key field SSN in the text. I know from
another thread that I can query the QADBIFLD file and find
all the files in that library that have "SSN" in the text description.

I want to build a query that will do a select for each file
found in QADBIFLD and search for a SSN = 123456789, and do
something with that. So the field that contains the data for
file name (dbifil) is what I want to use. Something like;

With t1 as
(Select DBIFIL, DBIFLD
from QADBIFLD
where dbitxt like '%SSN%'
and DBILIB = 'MYLIBNAME')

Select * from (contents of dbifil) where (contents of dbifld)
= 123456789

Is this do-able??

Jim
--
This is the Midrange Systems Technical Discussion
(MIDRANGE-L) mailing list To post a message email:
MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting,
please take a moment to review the archives at
http://archive.midrange.com/midrange-l.

This e-mail transmission contains information that is intended to be confidential and privileged. If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please delete and otherwise erase it and any attachments from your computer system. Your assistance in correcting this error is appreciated.