Skip to main content

Imported SQL Properties

  • Updated

Previous Topic  Next Topic

Imported SQL Properties

The properties of an imported SQL file are as follows:

Property NameDescription
Connection NameSpecifies the connection to execute the imported SQL file.

Data type: String

DescriptionSpecifies the description of the imported SQL file.

Data type: String

Maximum DurationSpecifies the maximum elapsed time allowed to fetch data from the data source when the SQL file runs, measured in seconds. If the value is set to zero or is blank, it means the time will be unlimited.

For usage about the property, see Limiting the Query Run Time and Number of Records.

Data type: Integer

Maximum RowsSpecifies the maximum number of rows that will be fetched from the data source when the imported SQL file runs. If the value is set to zero or is blank, it means the number will be unlimited.

For usage about the property, see Limiting the Query Run Time and Number of Records.

Data type: Integer

Name Specifies the name of the imported SQL file.

Data type: String

QualifierSpecifies the database's catalog name of the imported SQL file.

Data type: String

Read OnlySpecifies whether or not the imported SQL file will be read only.

Data type: Enumeration

Transaction Mode Specifies the transaction mode for the imported SQL file. Choose an option from the drop-down list.
  • default - Indicates the transaction information cannot be got from JDBC connection.
  • none - Indicates that transactions are not supported.
  • read uncommitted - Dirty reads, non-repeatable reads and phantom reads can occur. This mode will speed up the transaction of the catalog.
  • read committed - Dirty reads are prevented; non-repeatable reads and phantom reads can occur.
  • repeatable read - Dirty reads and non-repeatable reads are prevented; phantom reads can occur.
  • serializable - Dirty reads, non-repeatable reads and phantom reads are prevented.

Data type: Enumeration

An imported SQL file contains several columns, the properties of which are shown in the following topic: Imported SQL Column

Previous Topic  Next Topic