Running From the Command Line

Restriction: This topic applies to Windows environments only.

In addition to running a SQL script from SQLWizard, you can run it directly from your development environment's command prompt.

Note: You can run a script file by double clicking the SQL file name in the Windows File Manager.

To run a script from the development environment's command prompt, call the xwiz40n program file, and pass it the name of your script file as shown below:

xwiz40n [-iiniFile] filename.SQL

where:

`iniFile`	is the initialization file that SQLWizard uses when it runs the script. If you don't specify an initialization file, XDB.INI in the working directory is used.
`filename`	is the name of your SQL script file. If you do not specify the path to `filename` the script file must be in the current application path (the application path is specified on the Paths tab. Note: The filename must include the extension "SQL" in its name (for example, sfile.sql).

The following example shows how a script called "newmember" would be called. In this example, the contents of file member.ini will establish SQLWizard's operating configuration.

xwiz40n -ic:\member.ini newmember.sql