I want to be able to look up a field in a master file across all procedure in all folders to see where its being used? I used to be able do a grep in UNIX but now we are on Windows 2008 server. Can some one please help or point me in the right direction?

Thanks,
prodrigu

This message has been edited. Last edited by: Kerry,

Do you want to search from within WebFOCUS ?

or more general, a windows search

Waz,

Both would be nice!!!

Thanks,
prodrigu

A couple of options.

1. Pure focus. USE APP LIST to get a list of APP directories, then process each with APP PATH and TABLE FILE SYSCOLUM.

1. Windows command FIND. USE APP LIST to get a list of APP directories, then process each with FIND "text" {directory}.

Waz,

I know this might sound like a stupid question but can you show an example of what you mean when you say process each with APP PATH and TABLE FILE SYSCOLUM?

Below is what my APP PATH looks like:

  
 APP LIST
 BEGIN-APP-LIST
 09/01/2012 09.09.56 acs
 30/07/2010 08.33.05 arodrigtst
 24/09/2012 10.45.10 bap
 24/04/2012 11.11.11 barreltracking
 11/09/2012 13.17.17 baseapp
 30/07/2010 08.33.05 bdelamtst
 30/07/2010 08.33.05 bhamptontst
 16/02/2012 15.53.39 brwdwinery
 27/09/2012 14.05.45 bsinghtst
 12/12/2011 13.36.21 btoraclehub
 21/06/2012 11.37.05 budget
 12/12/2011 14.06.35 chnprc
 12/12/2011 14.06.10 cnsrel
 12/12/2011 14.06.57 cube
 11/10/2012 14.57.17 cwt
 30/07/2010 08.33.05 ddosstst
 12/12/2011 14.07.40 demandplanner
 08/05/2012 16.39.16 distanalysis
 30/07/2010 08.33.05 dleonardtst
 12/12/2011 14.11.07 evm
 22/08/2012 14.52.43 fbealltst
 12/12/2011 13.37.08 fl2oraclehub
 12/12/2011 14.11.30 fourblock
 12/12/2011 14.12.01 frcst
 12/12/2011 13.37.52 ga1oraclehub
 17/09/2012 10.54.10 gal
 12/12/2011 14.13.47 gisr
 16/02/2012 15.55.06 glass
 16/03/2012 09.32.15 glc
 21/03/2012 12.22.03 gms
 02/04/2012 13.36.29 gmstest
 08/10/2012 13.30.52 growers
 23/10/2012 17.10.48 gwm
 12/12/2011 14.34.50 hris
 26/09/2011 11.02.19 ibinccen
 29/05/2012 11.28.28 ibisamp
 20/07/2012 12.07.10 ibistats
 27/09/2012 08.21.17 ids
 12/12/2011 13.38.24 il3oraclehub
 24/10/2012 05.37.24 intl
 18/04/2012 10.41.45 itementry
 11/09/2012 11.28.05 jdehub
 12/10/2012 14.31.54 jgreentst
 30/07/2010 08.33.05 jreyestst
 12/12/2011 13.45.36 ks1oraclehub
 27/07/2012 11.11.07 ksmithtst
 11/09/2012 12.56.52 life
 12/12/2011 14.37.59 livcrush
 12/12/2011 14.38.21 llink
 16/10/2012 16.53.29 malanistst
 11/09/2012 15.46.18 mdalby
 21/05/2012 11.26.32 mfg
 12/12/2011 13.46.21 midoraclehub
 25/09/2012 16.15.59 mlopeztst
 30/07/2010 08.33.05 mpepetst
 11/10/2012 16.17.02 mrodrigtst
 16/05/2012 11.21.28 myrptswrap
 30/07/2010 08.33.05 neighmytst
 22/10/2012 09.52.09 netezzahub
 12/12/2011 13.46.54 nj2oraclehub
 19/09/2012 04.57.53 njoshitst
 28/06/2012 10.01.27 nselphtst
 30/07/2010 08.33.05 nvolktst
 18/07/2012 14.54.49 ofscustserv
 16/02/2012 15.54.17 ofsrdcdep
 12/12/2011 14.42.48 opsstrat
 29/10/2012 16.15.36 oraclehub
 12/12/2011 13.47.21 pa1oraclehub
 30/07/2010 08.33.05 pegantst
 12/12/2011 13.47.42 psoraclehub
 30/07/2010 08.33.05 randertst
 30/07/2010 08.33.05 rbealltst
 13/08/2012 08.42.55 rdcrprts
 08/08/2012 16.49.49 rms
 12/12/2011 14.48.54 rsw
 30/07/2010 08.33.05 rwutst
 29/06/2012 09.49.52 scconv
 19/07/2012 08.05.30 scp
 29/10/2012 04.00.25 sims
 04/05/2012 08.10.36 sjvc
 04/04/2012 10.41.45 sonhndinv
 12/12/2011 13.39.33 sqlsrvhub
 31/07/2012 10.53.19 srvrmetrics
 30/07/2010 08.33.05 sserbetst
 22/05/2012 14.14.55 suppdev
 07/03/2012 09.48.52 telecom
 18/04/2012 10.22.24 tms
 12/12/2011 15.12.45 tnq
 31/07/2012 10.25.48 tworsha1tst
 12/12/2011 13.43.42 tx1oraclehub
 30/07/2010 08.33.05 ubangaloretst
 10/07/2012 13.31.01 uk1oraclehub
 10/10/2012 09.32.28 whsmgmtsys
 22/05/2012 14.47.15 whsmgmtsys_ent
 23/10/2012 15.31.52 wmg
 20/04/2012 14.56.17 wmgoraclehub
 05/10/2012 19.43.53 wmgplan
 12/10/2012 14.31.36 wmsburpts
 12/12/2011 13.40.13 wmsoraclehub
 12/12/2011 13.38.45 xmlhub
 21/06/2012 07.40.43 zzzadmin
 29/10/2012 16.16.20 foccache
 29/10/2012 14.35.18 myrptsinbox
 06/02/2012 11.38.22 gwinegifs
 END-APP-LIST

Try this.

APP LIST HOLD

-RUN

TABLE FILE FOCAPPL
PRINT APPNAME
ON TABLE SAVE AS TMP_APP
END

-RUN

-SET &APP_Count = &LINES ;

-REPEAT APP_LOOP &APP_Count TIMES

-READ TMP_APP NOCLOSE &APP_Name.A64.

APP PATH &APP_Name

-RUN

TABLE FILE SYSCOLUM
PRINT COMPUTE APP_DIR/A64 = '&APP_Name' ;
TBNAME
NAME
WHERE NAME EQ 'CAR'
END

-APP_LOOP

From the Data Management Console or Web Console open the synonym containing the field. Right click on the field and select Impact Analysis.

You will get a report that shows each procedure (and DataMigrator flow) that uses the field and how it is used.

I have been relying on Impact Analysis--both from the app and (as we use MR) from Domains.

We're also running on a Windows server, so I'll also use the built-in command FINDSTR. It offers a few more options.

You need to be on the server or have a drive mapped--the command doesn't like UNCs.

But here's an example.

 FINDSTR /I /S /M /C:"FILE CAR" d:\IBI\srv77\apps\*.* 

I -- case insensitive
S -- search current directory and subdirectories
M -- show just the file names, not the names and the line preview
C:"string" -- uses a literal. otherwise, it would search for occurences of file and of car

then the path to the directory I'm searching.

+1 on FINDSTR. Works just like grep. Supports RegEx. I like the line of Context by not using the /M switch.

Also, TextPad has an awesome 'Find In Files' search that is RegEx aware, searches subdirectories and when you click on the file name in the search results, it loads it into the main pane.

-ABT

Is this a programatically initiated search or user initiated ?

Did I spell programatically correctly ?

Thanks everyone for sharing!!!

For my case, nd solution works perfect!!!

Thanks,
prodrigu