Executing ept file at comman line

Read(25) Label: commandline, esprocx, execute,

The command line is a user interface that enables you to execute a program by typing string type commands at prompts on DOS like platforms. It is supported by all operating systems under different features and names, such as the Linux console and Windows commands.

 

You need to start the esprocx.exe file to execute an .ept file from the command line. The file is settled under esProc\bin in esProc installation directory.

 

Syntax of the command is like this:

Esprocx [eptFile] [argN=value] [View=name] [Export=name]...

[eptFile]: Name of an ept file that is represented by an absolute path or a path relative to the search path or the main path.

[argN=value]: Specify a parameter for eptFile in the format of “parameter name=parameter value”.

 

Note: Spaces are not allowed before and after a section break or an equal sign; section breaks are separated by spaces!

[View = vName]: Execute a view named vName in eptFile; by default all views in the file are executed.

[Export = eName]: Execute an exported view named eName under the view vName in eptFile; all exported views with that name are executed if no view is specified; by default all data in the exported view(s) are output.

 

●Example: Export data in STUDENT1.txt and STUDENT2.txt to a composite table and a bin file.

 

Below are data sources created based on the two text files:

 

Set a parameter:

Type in filter expression for data source STUDENTS2:

Create a view named view1 based only on the data source STUDENTS1:

Configure the export of data from view1( export1):

Create a view named view2 based only on the data source STUDENTS2:

Configure the export of data from view2( export1), which is the same as the above:

Configure the export of data from view2( export2):

Save the configurations as union.ept and execute it at command line using esprocx command.

1)  Execute an ept file that has a parameter and specifies a view and and exported view:

View data in the composite table file 2.ctx in the data file tool:

2)  Execute an ept file that specifies a view only:

View data in the bin file 1.btx in the data file tool:

3)  Execute an ept file that doesn’t specify both and the program will output all exported views in order:

View data in the composite table file 2.ctx in the data file tool:

If exported views of same structure are all configured to output to same target file in the same export style, they are output in order and the results are unioned all.

 

Suppose export1 under view1 and export1 under view2 are such exported views. Below is the bin file 1.btx receiving data output from the two exported views.