Creating a Script File

A script file is generally created by saving SQL statements from the SQL Edit window. For example, you can create a script by performing a query, then switch to the Edit window to incorporate additional SQL commands. You can also incorporate any of the special batch SQL commands, which functionality specific to batch operation.

SQLWizard's Export facility provides another way to create a script file. When you export data from XDB Server, you can optionally include SQL statements with it. This process creates a script file that, when run, automatically recreates the table from the exported data.

If you prefer, you can create a script by typing your SQL statements directly into a file using any ASCII text editor. Regardless of how you create your script file, the following script-file syntax must be observed:

• Commands can be placed on separate lines terminated by a semicolon (;) or on the same line terminated by a semicolon (;).
• Commands may be typed in upper or lower case.
• Spaces and blank lines can be included to improve readability. Spaces and blank lines are ignored by SQLWizard.
• Spaces are not required before and after an equal sign ( = ), however they can be included to improve readability.
• Comments can be inserted by bracketing them in comment characters (e.g., /*comment text */), or by prefixing them with two hyphens.

  Both comment types are shown below.

    /* Get customer list with company & state   */
    /* List customers with balance over $2,000. */
    SELECT company, state, balance  --retrieve columns
    FROM customer             --from customer table
    WHERE balance>$2,000;        --show records with 
    --balance over $2000