Hi Larry
If you don't have TAA tools you can always use SQL, providing you have SQL!
SELECT substr(DBFFIL,1,10) as Physical_File,
DBFLIB as Physical_Library,
DBFLDP as Logical_Library,
DBFFDP as Logical_File
FROM qadbfdep WHERE
dbflib <> dbfldp ORDER BY dbfldp, dbffdp
Hope this helps.
Regards
Andy Youens | Senior IBM Consultant | formaserve systems ltd
v 01908 609500 | 07770 380276 |
http://www.formaserve.com
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [
mailto:midrange-l-bounces@xxxxxxxxxxxx]
On Behalf Of Ketzes, Larry
Sent: 23 April 2007 15:00
To: Midrange Systems Technical Discussion
Subject: TaaTools Command
Does anyone remember the Taatools command to check for logical files based
on physicals in a different library? I can't seem to remember the specific
command.
Thanks, Larry
Larry Ketzes
iSeries Senior Systems Administrator
American Life Insurance Company
One ALICO Plaza
600 King Street
Wilmington, DE 19801
Phone: 302-594-2146
Mobile: 302-559-1631
Fax: 302-830-4524
Email: larry.ketzes@xxxxxxx
(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.
midrange.com
