RE: TaaTools Command

["Andy Youens" <andy@xxxxxxxxxxxxxxxx>]

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.