C-LANG Statements › JOB_CRITERIA Statement—Specify the Evaluation Criteria for a Return String

JOB_CRITERIA Statement—Specify the Evaluation Criteria for a Return String

The JOB_CRITERIA statement defines a regular expression used to evaluate a string returned by an SQL statement or a stored procedure.

Supported Job Types

This statement is optional for the following job types:

• Database Stored Procedure
• SQL

Syntax

This statement has the following format:

JOB_CRITERIA regexp

regexp

Defines a regular expression that is used to evaluate a return string. If the return string matches the regular expression, the job completes successfully. Otherwise, the job fails.

Limits: Up to 256 characters; case-sensitive

Note: Each return string includes the field name from the SELECT statement and its value, separated by an equal sign (=). For example, consider the query SELECT ORD_NUM FROM SALES. To match order number A2976, specify the regular expression ORD_NUM=A2976. Specifying the regular expression A2976 does not match any return string causing the job to fail. You can also specify the regular expression .*A2976, which matches any return string that ends with A2976.

Notes:

• Enclose values that contain delimiters (such as spaces) in double quotation marks.
• This field only applies to SQL queries that are SELECT statements.
• To compose a regular expression, follow the rules for Java class java.util.regex.Pattern. You can find these rules using a Google search for java pattern.
• You can use escape sequences in the regular expression. The following characters have a special meaning in regular expressions. To use these characters literally, precede the characters with one backward slash (\).
  • \—backward slash
  • [—opening bracket
  • *—asterisk
  • |—vertical bar
  • {—opening brace
  • +—plus sign
  • (—opening parenthesis
  • ^—caret (circumflex)
  • ?—question mark
  • )—closing parenthesis
  • $—dollar sign
  • .—period

  For example, to match the characters *.* literally, specify \*\.\* in your regular expression. The backward slashes escape the characters' special meanings.

• JOBCRIT is an alias of JOB_CRITERIA.

Example: Define Basic Success Criteria

In the following example, if the SQL query returns a PartNo that begins with IDG, the job completes successfully.

AGENT CYBDB1
SQL 'SELECT PartNo FROM Inv_List WHERE Stock > 30'
JOB_CRITERIA PartNo=IDG.*

Example: Define a More Complex Success Criteria

In the following example, if the SQL query returns an ID that matches the specified regular expression, the job completes successfully.

AGENT CYBDB1
SQL 'SELECT ID FROM Proc_List WHERE Orders > 30'
JOB_CRITERIA 'ID=\w{2,4}'

The regular expression is interpreted as follows:

• \w—A word character [a-zA-Z0-9]
• {2,4}—Match at least 2 times but not more than 4 times

To illustrate the last item {2, 4}, consider the syntax:

'ID=b1{1,3}c'

Evaluating this expression yields the following conditions:

• The line contains the text b1.
• Numeric 1 should exist at least once, but not more than three times.
• The specified string must be followed by the letter c.