Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] searching files on EDASERVE for SQL pass-thru usage
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] searching files on EDASERVE for SQL pass-thru usage
 Login/Join
 
Platinum Member
posted
Is there a[n easy] way to get a list of files (fex & html) that reside on the EDASERVE that use SQL pass-thru?
I tried logging into the server and just doing a Windows search, but all I get are html files, none of the fex files, and I know there are a bunch.

Thanks,
Deb

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


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 173 | Location: Indiana | Registered: December 05, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Deb

There is a free download called Windows GREP that will allow you to search for strings of data at a directory level. I think you can do the same with Notepad ++ as well


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1872 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Windows GREP is still around? I haven't used that in ages! Smiler I'll look for it.
Thanks!


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 173 | Location: Indiana | Registered: December 05, 2017Reply With QuoteReport This Post
Expert
posted Hide Post
Windows GREP is part of GNU Utilities


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6270 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
If you are in a hurry or are not allowed to install grep, Windows has the findstr command. For example:
findstr /i /n /s "sqlmss" c:\ibi\apps\*.fex 

Learn about all the options with:
findstr /? 

This looks like a good resource for findstr undocumented features

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


WF 8.2.06
Win10 / IE11
AHTML EXL2K PDF
 
Posts: 173 | Registered: October 19, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
dbeagan - That's what I ended up using. Thanks for posting!


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 173 | Location: Indiana | Registered: December 05, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Good One


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1872 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] searching files on EDASERVE for SQL pass-thru usage

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.