14.2. Constants, Functions, Operators, mathematical expressions
14.2.1. Fortran Syntax
Prev  Next

14.2.1. Fortran Syntax

Fortran syntax

.EQ.

eq ual (equal)

.GT.

g reater t hen (greater than)

.GE.

g reater e qual (greater than or equal to)

.LT.

l ower t hen (less than)

.LE.

l ower e qual (less than or equal to)

.AND.

(both conditions - right and left of .AND. - must be fulfilled)

.OR.

(one of the two conditions - to the right or left of .OR. - must be fulfilled)

.NE.

n ot e qual (unequal)

The following examples show key values:

  • (ERP_PDM_NUMBER.NE.'')

    The expression is true if the relevant field in the ERP_PDM_NUMBER column is not empty.

  • ((ERP_PDM_NUMBER.NE.'').AND.(ACTIVE_STATE.EQ.1))

    The expression is true if the relevant field in the ERP_PDM_NUMBER column is not empty AND the relevant field in the ACTIVE_STATE column has the value 1 ( =released [Released] ).

  • (PRICE.LT.0.4)

    The expression is true if the relevant field in the PRICE column has a value less than or equal to 0.4.

  • (REQUESTED_STATE.EQ.2)

    The expression is true if the relevant field in the REQUESTED_STATE column has the value 2 ( =expired [Expired] ).

  • ((ACTIVE_STATE.EQ.1).AND.(LOCATION1.NE.''))

    The expression is true if the relevant field in the ACTIVE_STATE column has the value 1 ( =released [Released] ) AND the relevant field in the LOCATION1 column is not empty.

  • (CONTAINS(ERP_PDM_NUMBER,'AA').EQ..TRUE.)

    The expression is true if the relevant field in the ERP_PDM_NUMBER column contains the substring 'AA'.

  • (CONTAINS(ERP_PDM_NUMBER,'AA').EQ..FALSE.)

    The expression is true if the relevant field in the ERP_PDM_NUMBER column does NOT contain the substring 'AA'.

Prev Up Next
14.2. Constants, Functions, Operators, mathematical expressions  Home 14.2.2. SQL Syntax