Versions Compared

Old Version 1

changes.mady.by.user Wara Hermosa

Saved on

compared with

New Version Current

changes.mady.by.user eric revollo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Field

Description

Display Data SQL

The generic syntax of a Display Data SQL statement should use RED placeholder parameters (e.g. $OBJECT$, $MAXDISPLAYDATA$).

Note

The $MAXDISPLAYDATA$ parameter is derived from the User Preferences > Common > Look and Feel > General > Maximum rows returned for Display Data setting.


Row Count SQL

The generic syntax of a Row Count SQL statement which should use RED placeholder parameters (e.g. $OBJECT$).

Bulk Table Row Count SQL

The SQL statement is used to return the table name, schema name, and row count of all tables for the connection.For example: SELECT table_name, schema_name, row_count FROM information_schema.tables.The variable $DATABASE$ can be used. The SQL statement defined in this field is used in the Browser Connection screen if the Include Rowcount option is enabled.

Note
  • The Include Rowcount option in the Browser Connection screen for Custom database connections is only available, if this field has been defined.
  • If the Include Rowcount option is enabled for a Custom database connection, then the SQL statement defined in this field is used to return the list of tables, schema, and row counts as the source of the row counts; instead of the SQL statement defined internally in RED.
  • The SELECT statement must follow the order "table_name, schema_name, row_count" as shown in the example above.


Default Table Create DDL Template

The default Template used for generating DDL for new Tables created on targets of this connection.

Note

This template is used in the validation done for custom database targets during Application Load Processing performed in the WhereScape Setup Administrator. Refer to Compile New and Changed Procedures in the RED Installation Guide for details.


Default View Create DDL Template

The default Template used for generating DDL for new Views created on targets of this connection

Table/Column Information SQL Block

The SQL Block Procedure used to query Table/Columns information; should use RED placeholder parameters (e.g. $DATABASE$, $SCHEMA$, $OBJECT$).

Default Table Alter DDL Template

The default Template used for generating DDL to alter existing Tables created on targets of this connection

Drop-Table SQL

The generic syntax of a Drop Table SQL statement should use RED placeholder parameters (e.g. $OBJECT$).

Drop View SQL

The generic syntax of a Drop View SQL statement should use RED placeholder parameters (e.g. $OBJECT$).

Truncate SQL

The generic syntax of a Truncate SQL statement which should use RED placeholder parameters (e.g. $OBJECT$).

Default Index Create DDL Template

The default Template used for generating DDL for new Indexes created on targets of this connection.

Default Index Drop DDL Template

The default Template used for generating DDL to drop existing Indexes created on targets of this connection.

Default Index Validate Block Template

The default Template is used for generating a block of SQL Statements to validate indexes created on targets on this connection.

Default Windows Action Script Template

The default Template is used for generating a Windows Script to perform actions on objects created on targets of this connection.

Default Unix Action Script Template

The default Template is used for generating a Unix Script to perform actions on objects created on targets of this connection.

Enable Automatic Creation of Indexes

RED's default behavior is to create indexes when creating new objects.

Default Pre-Load Action

The default Pre-Load Action to use for Load tables created on targets of this connection. Options include:

  • Truncate
  • Execute Pre-load SQL
  • Both Truncate and Execute Pre-Load SQL
  • No action
    If Execute Pre-Load SQL is selected, then the SQL statement to execute before the load takes place must be entered—refer to Pre-Load Action in Database Link Load Properties Screen for details.

Default Update Script Connection

The default Script Connection for new Update Scripts in tables created using this connection. This setting is only displayed in connections that have a target database type for which Update Script functionality is enabled, e.g. Custom database type.

Column Properties Configuration

List view of the available Column Properties Configs.

...