Updated on 2022-02-22 GMT+08:00

RDS SQL

Functions

The RDS SQL node is used to transfer SQL statements to RDS.

Parameters

Table 1 and Table 2 describe the parameters of the RDS SQL node.

Table 1 Parameters of RDS SQL nodes

Parameter

Mandatory

Description

Node Name

Yes

Name of the node. Must consist of 1 to 128 characters and contain only letters, digits, underscores (_), hyphens (-), slashes (/), less-than signs (<), and greater-than signs (>).

Data Connection

Yes

Name of the data connection.

Database

Yes

Name of the database. The database has been created. You are advised not to use the default database.

SQL or Script

Yes

You can select SQL statement or SQL script.

  • SQL statement

    In the SQL statement text box, enter the SQL statement to be executed.

  • SQL script

    Select a script to be executed. If the script is not created, create and develop the script by referring to Creating a Script and Developing an SQL Script.

    NOTE:

    If you select SQL statement, DLF cannot parse the parameters contained in the SQL statement.

Table 2 Advanced parameters

Parameter

Mandatory

Description

Node Status Polling Interval (s)

Yes

Specifies how often the system check completeness of the node task. The value ranges from 1 to 60 seconds.

Max. Node Execution Duration

Yes

Execution timeout interval for the node. If retry is configured and the execution is not complete within the timeout interval, the node will not be retried and is set to the failed state.

Retry upon Failure

Yes

Indicates whether to re-execute a node task if its execution fails. Possible values:

  • Yes: The node task will be re-executed, and the following parameters must be configured:
    • Maximum Retries
    • Retry Interval (seconds)
  • No: The node task will not be re-executed. This is the default setting.
NOTE:

If Timeout Interval is configured for the node, the node will not be executed again after the execution times out. Instead, the node is set to the failure state.

Failure Policy

Yes

Operation that will be performed if the node task fails to be executed. Possible values:

  • End the current job execution plan
  • Go to the next job
  • Suspend the current job execution plan
  • Suspend execution plans of the current and subsequent nodes