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.

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

Examples:

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

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

--aqt options,maxrows=200