Built-in qualification functions  Creating DB object qualifications

Chapter 3: Building Production Objects

Using compare operation qualifications

Select Compare Oper to have the SFM perform a specific comparison operation between the data in the Qualification Object Information windows’s FldObj or Datalink field and a literal, or the contents of another datalink object, or the contents of another input field. If the comparison operation fails, this qualification object fails.

With compare operations, the content referenced in the Qualification Object Information windows’s FldObj or Datalink field is the first operand in the equation and the Literal Value/Datalink/Input Field value listed below the operation is the second operand, as in “Field Object/datalink” “operation” “Literal Value/datalink/Field Object”.

Field (key)

Description

Oper

Enter the operation to use between the Qualification Object Information windows’s FldObj or Datalink field and the Literal Value/Datalink/Input Field value, or choose the operation from the drop-down list. Available operations are

  • Equal – the first operand is equal to the second operand.

  • Not Equal – the first operand is not equal to the second operand.

  • Less Than – the first operand is less than the second operand.

  • Greater Than – the first operand is greater than the second operand.

  • Less/Equal – the first operand is less than or equal to the second operand.

  • Greater/Equal – the first operand is greater than or equal to the second operand.

  • Missing – the first operand was not found in the incoming transaction.

  • Not Missing – the first operand is in the incoming transaction.

  • Empty – the first operand does not contain data.

  • Not Empty – the first operand does contain data.

  • inRange – the first operand is between the two values in the literal range (to be entered as “low,high”; for example, “3,6”).

  • outOfRange – the first operand is not between the two values in the literal range (to be entered as “low,high”; for example, “3,6”).

Literal Value

The byte-sensitive value against which the related input field is compared. Be careful when entering a Literal Value to match it to an expected input field value.

If you choose the Missing, Not Missing, Empty, or Not Empty operation, select Literal Value and enter any value. The SFM ignores this value for these four operations but still requires an entry in the field.

If you choose the inRange or outOfRange operation, a single field appears. Put the range in this field. The two range boundaries must be integers separated by a comma. For example, if the number must be between 13 and 35, the literal range would be “13,35”. If the range is invalid, the qualification object fails.

Datalink

Select to use the contents of a datalink as the second operand. Enter the name of the datalink object or click the down-arrow to the right of the field to choose from a list of existing datalink objects.

Input Field

Select to use the contents of a field object as the second operand. Enter the name of the field object select the input field from a list of existing field objects.





Copyright © 2005. Sybase Inc. All rights reserved. Creating DB object qualifications

View this book as PDF