Scripting - Options

• Sdelim

  Specifies the delimiter to be used for delimiting SQL statements. You can specify go, / or some other character. Use semi to specify a semicolon.

  If this is not specified, AQT will use the value you have specified in Options > Run SQL > Statement Delimiter.

• StopOnError

  Specifies whether AQT is to halt the batch processing if it hits an error. Any error (either in the processing of an SQL statement, or an error in an –aqt statement) will stop the processing.

• Debug

  Specify this as Yes or No. Switches debug mode on or off.

• DbugFile

  This specifies the name of the debug file. If an unqualified name is specified, (example: aqtdebug_batch.txt) it will be placed in the workfiles directory.

  This debug file will be in use for this AQT session only. It will not be permanently changed.

• Lobdir

  Specify the directory used for writing LOB files. This can be useful if you are running multiple AQT sessions in batch and want to ensure that each session uses a separate directory for their LOB files.

• UR

  Specifies (Yes or No) whether Uncommitted Read is in effect for the current database.

• DateFormat

  Specify the date format to be used for subsequent exports. Note that the Export statement must specify userdate=y to use this format.

• TimeFormat

  Specify the time format to be used for subsequent exports. Note that the Export statement must specify userdate=y to use this format.

• SetExitCode

  This specifies whether AQT is to set the ExitCode when the batch process terminates. When AQT does this, AQT will crash - this is a problem we haven't been able to resolve. The crash does however notify you that the AQT batch process has hit an error, so may be useful.

  If SetExitCode is set to No, AQT will not set the exit code so will not crash. By default, SetExitCode is Yes.

• maxrows

  This specifies the maximum number of rows returned by a query. This is the same limit as specified on Options > Display Limits.

  This is mainly used in online-AQT. When running exports in batch-mode AQT, use the maxrows parameter of the export command.

• other

  You can specify any option that is present on the Options window. You refer to the option by the internal name of the option. The internal option name is described in Technical Notes on Options.

Examples:

--aqt options,stoponerror=yes,setexitcode=no

--aqt options,sdelim=go,lobdir="c:\aqt\workfiles\lobs",dateformat=mm-dd-yyyy

--aqt options,maxrows=200

Notes

• When you change an option it is only in effect for your AQT session. If you go to the Options window you will see the changed value of the option. If you then click on OK in the Options window, the new value will be saved and will be permanent (e.g. until you next change it).
• AQT can be configured so that some options are different for different database types (this is done with Options > Database Profiles). In this circumstance, the value in the Database Profile will take preference over the value you set here.