Focal Point
Execute procedure from the command line?

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6441058302

December 28, 2006, 04:10 PM
Imhoff
Execute procedure from the command line?
Is there any way to execute a webfocus stored procedure from a command line? I'm trying to automate exporting data to csv files and was hoping to kick off the process from a bat file.

Thanks for any suggestions or examples that you may have.

Have a good day,
Michael
December 28, 2006, 04:22 PM
ibidevelop
Michael,

You can use ibiweb.exe -v IBIF_ex=fexname in a batch file but you're probably better off creating a t3i script such as the following:

miket3i.t3i
----------
%connect
%begin

EX FEXNAME

%end
%disconnect
%stop_server

The t3i script can be executed using "edastart -f" from a batch file.

mikebat.bat
----------
C:\ibi\srv71\wfs\bin\edastart -f miket3i

Hope this helps.

Joe
December 28, 2006, 04:26 PM
<RickW>
You may want to look into Reportcaster as an alternative for your automation.
January 09, 2007, 12:27 PM
Kerry
Hi Michael,

I checked this one with several internal people and was told that the suggestions made here should work (many thanks to Joe and RickW). If you still have problems, please contact Information Builders' Customer Support for assistance. The phone number is 1-800-736-6130, or you can access the online system InfoResponse.

Hope this helps. Smiler

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
January 10, 2007, 08:15 AM
RichH
Hi Michael.

Did you open a case? What problems are you having?


WebFOCUS 8202 Win 2012
Test - WebFOCUS 8203 on Win 2012