How to Generate Files from the Command Line

Previous Next

It is possible to generate flat files and database files from the command line. These include a .CON, a .JOB, and an .ESI file, and user statement and database installation files. One of the main advantages of generating flat files from the command line is that a USoft application does not need to be opened and that the generated files can be distributed to several client machines.

To generate the .ESI file for the TRAVEL application, for example, use the following command line :


-database DB001

-app TRAVEL -u TRAVELUSER -pw traveluser



-generate C:\Usd70\app\TRAVEL_70.esi


This option does not start up the GUI, and the process is exited once the file is created.

An alternative manner is to replace the –generate option with:

-exe "esi-create-schema-file(TRAVEL_70) application-exit(IMMEDIATE)"

This will start up the GUI, but will exit the application once the file is created.

The esi-create-schema-file() part of the command can be replaced with:

create-conceptual-file(:appname.con) for a conceptual file;

create-application-text-file(:filename) to generate a user messages (.UMG) file from the Definer, with parameter:

–app USD

create-system-message-file(:filename) to generate a system messages (.SMG) file from the Definer, with parameter:

–app USD

teamwork-export(:export_id, :filename) to generate a TeamWork export (.EXP) file, with parameter:

–app USD

top-batch-create-definition-file(:filename) to generate a job file, with parameter:

–app USD

creins('-i', sitenr, user-statement filename, dba-statement filename) for user statement and dba statement files, with parameter:

–app USD

You can also replace the –exe option with:

-run "script-file-name"

where a script file contains all actions to be executed. In this case, the application exits automatically.