SQL

The SQL field specifies the SQL statement to capture the cases for which the derivation rule is applicable.

Note:

The SQL statement must follow the correct syntax.

The system does not validate the length of the new values against the database. Make sure that new values being inserted into the Oracle Argus Insight data mart do not exceed the limit defined in the database.

Guidelines for correct syntax:

• The SQL query configured against a rule should not contain the table name. It should contain only the primary key column name(s) of the field in the SELECT clause. For example:

  Correct: SELECT CASE_ID FROM RPT_CASE WHERE…
  Incorrect: SELECT RPT_CASE.CASE_ID FROM RPT_CASE WHERE…
  

• Make sure that there is only one space after the SELECT clause in the SQL query. For example:

  Correct: SELECT CASE_ID, SEQ_NUM FROM RPT_PRODUCT WHERE…
  Incorrect: SELECT     CASE_ID, SEQ_NUM FROM RPT_PRODUCT WHERE…
  

• Make sure that no Oracle keyword (such as DISTINCT) is used after the SELECT clause in the SQL query. For example:

  Correct: SELECT CASE_ID, SEQ_NUM FROM RPT_PRODUCT WHERE…
  Incorrect: SELECT DISTINCT CASE_ID, SEQ_NUM FROM RPT_PRODUCT WHERE…