Previous Topic

Next Topic

Book Contents

Book Index

Advanced Options

This tab contains some more advanced / less-frequently used options.

export_optadv

Option

Description

LOB options

These are discussed in Exporting LOBS.

Use date format as specified in Options > Display Format

Formats date columns as specified in Options > Display Format. If this is not specified, date columns will be formatted in yyyy-mm-dd format, which is the format most databases require for data being loaded.

Include this export in the Export History?

Specifies whether this export will be included in the Export History

Write Text > Before data

You can specify text that is to be written to the file before the query-data is written. This might (for instance) be a heading or a title line. It is also useful for separating query-data if you are appending many query-results to the same file.

Not relevant for Insert or XML exports.

Write Text > After data

You can specify text that is to be written to the file after the query-data is written. This might (for instance) be a closing line.

Not relevant for Insert or XML exports.

Text Before/After

In your text you can also specify a number of keywords:

<cr>

Line-feed (this enables you to specify a multi-line header).

<blank>

Blank line.

<numrows>

The number of rows exported. Can only be specified in Text after.

<sql>

Your query SQL.

<sqlc>

Your query SQL compacted. The SQL has line-feeds and extraneous blanks removed.