Scripting - Options

• Sdelim

  Specifies the delimiter to be used for delimiting SQL statements. You can specify go, / or some other character. 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.

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

• DateFormat

  Specify the date format to be used for subsequent exports.

• TimeFormat

  Specify the time format to be used for subsequent exports.

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

Examples:

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

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