Skip to main content

Imported SQL Properties

  • Updated
Not yet followed by anyone

BackPrevious Topic  Next TopicNext

Imported SQL Properties

This topic describes the properties of an Imported SQL object in a catalog.

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

Data type: String

DescriptionSpecifies the description of the imported SQL.

Data type: String

Maximum DurationSpecifies the maximum elapsed time allowed to fetch data from the data source when the imported SQL runs, measured in seconds. By default, the property value is blank, meaning the time is unlimited. For more information, see Limiting the Query Run Time and Number of Records.

Data type: Integer

Maximum RowsSpecifies the maximum number of rows to be fetched from the data source when the imported SQL runs. By default, the property value is blank, meaning the number is unlimited. For more information, see Limiting the Query Run Time and Number of Records.

Data type: Integer

NameSpecifies the mapped name of the imported SQL in the catalog.

Data type: String

QualifierSpecifies the name of the database catalog for the imported SQL.

Data type: String

Read OnlySpecifies whether the imported SQL is read only. Choose an option from the drop-down list.
  • default - Select to apply the setting from the database.
  • read & write - Select to allow users to access the database in read-write mode.
  • read only - Select to allow users to access the database in read-only mode. This option can speed up the transaction of the catalog.

Data type: Enumeration

Transaction ModeSpecifies the transaction mode for the imported SQL. Choose an option from the drop-down list.
  • default
    Select to apply the setting from the database.
  • none
    Select to not use transactions for the imported SQL.
  • read uncommitted
    Select to allow dirty reads, non-repeatable reads, and phantom reads to occur for the imported SQL. This mode can speed up the transaction of the catalog.
  • read committed
    Select to prevent dirty reads, and allow non-repeatable reads and phantom reads to occur for the imported SQL.
  • repeatable read
    Select to prevent dirty reads and non-repeatable reads, and allow phantom reads to occur for the imported SQL.
  • serializable
    Select to prevent dirty reads, non-repeatable reads, and phantom reads for the imported SQL.

Data type: Enumeration

BackPrevious Topic  Next TopicNext

Recently viewed articles