How to Generate Files from the Command Line

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 :

usd.exe

-database DB001

-app TRAVEL -u TRAVELUSER -pw traveluser

-oracle

-messagesToFile

-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.