IBM PureData System for Analytics, Version 7.1

Reference examples

The following table shows examples for references.
Table 1. Reference examples
Reference Meaning
BYTES &2 Error only internal @ reference is allowed for length-clause (in any format or zone-type).
BYTES @ An error length-clause cannot refer itself.
NULLIF & = '123' Self-reference (no number) is valid in null-clause.

The length must be BYTES/CHARS 3, for text-styles.

Matches (nullif evaluates to 'true') ONLY '123' (a row in the external file that contains '123').

NULLIF && = '123' Matches (nullif evaluates to 'true') '123', ' 123 ' ' 123 ', if SPACE is skipped.

Length must be at least BYTES 3 (text-styles) or BYTES 4.

NULLIF @ = 123 Valid for numerical zones.

Matches '123', ' 123 ' and so on, in text format, with spaces skipped.

NULLIF @ = '2000-01-01' Valid for date zones


Feedback | Copyright IBM Corporation 2014 | Last updated: 2014-02-28