Field Loop Expression Tokens

Field Loop Expression

Description

<IF ALPHA>

Data type is Alpha.

<IF ALLOW_LIST>

The field has allow list values.

<IF ALTERNATE_NAME>

The field has an alternate name specified. The <FIELD_ALTNAME> token will always return a value because if no alternate name is specified in the repository then it defaults to the fields real name. This token allows you to detect whether the alternate name is different from the real name.          

<IF ARRAY>

The field used to be part of an array with 1, 2, 3 or 4 dimensions.

<IF ARRAY_FIRST>

The field used to be the very first element of an array.

<IF ARRAY1>

The field used to be part of an array with 1 dimension.

<IF ARRAY1_FIRST>

The field used to be the very first element of an array with 1 dimension.

<IF ARRAY2>

The field used to be part of an array with 2 dimensions.

<IF ARRAY2_FIRST>

The field used to be the very first element of an array with 2 dimensions.

<IF ARRAY3>

The field used to be part of an array with 3 dimensions.

<IF ARRAY3_FIRST>

The field used to be the very first element of an array with 3 dimensions.

<IF ARRAY4>

The field used to be part of an array with 4 dimensions.

<IF ARRAY4_FIRST>

The field used to be the very first element of an array with 4 dimensions.

<IF ARRIVE>

The field has an arrive method specified.

<IF AUTO_SEQUENCE>
 

The field is an auto-sequence field. The underlying storage is an I8.

<IF AUTO_TIMESTAMP>
 

The field is an auto-time-stamp field. This expression will evaluate to true if the repository field is defined as type AutoTime (AT). The underlying storage is an I8.

<IF AUTO_TIMESTAMP_CREATED>
 

The field is an auto-time-stamp field AND is associated with a key segment that is defined as type AutoTime Created (C) . The underlying storage is an I8.

<IF AUTO_TIMESTAMP_UPDATED>
 

The field is an auto-time-stamp field AND is associated with a key segment that is defined as type AutoTime Created (C) . The underlying storage is an I8.

<IF BINARY>

The field is a binary field. Binary fields are also alpha fields.

<IF BOLD>

The field should be displayed in bold.

<IF BOOLEAN>

The fields data type is boolean. This only applies to fields whose actual Synergy data type is boolean, not to numeric fields with a coerced type of boolean.

<IF BZERO>

The numeric field should be displayed blank if the field value is zero.

<IF BREAK>

The field is a break field. This expression matches any type of break condition (change, always or return).

<IF BREAK_ALWAYS>

The field is a break field. The break field logic always executes whenever the field is processed.

<IF BREAK_CHANGE>

The field is a break field. The break field logic only executes when the value of the field changes.

<IF BREAK_RETURN>

The field is a break field. The break field logic only executes when the user presses RETURN on the field.

<IF CHANGE>

The field has a change method specified.

<IF CHECKBOX>

The field should be displayed as a check-box.

<IF COERCE_BOOLEAN>

The field data type is coerced to boolean.

<IF COMBOBOX>

The field should be displayed as a combo-box.

<IF CUSTOM_DBL_TYPE>

The field has a custom DBL data type specified via a special token. See <FIELD_CUSTOM_DBL_TYPE> for additional information.

<IF CUSTOM_SQL_TYPE>

The field has a custom SQL data type specified via a special token. See <FIELD_CUSTOM_SQL_TYPE> for additional information.

<IF CUSTOM_CONVERT_FUNCTION>

The f1eld has a custom conversion function specified via a special token. See <FIELD_CUSTOM_CONVERT_FUNCTION> for additional information.

<IF CUSTOM_STRING_FUNCTION>

The f1eld has a custom string ion function specified via a special token. See <FIELD_CUSTOM_STRING_FUNCTION> for additional information.

<IF DATE>

The field is a date. This includes all types of date and nullable date types.

<IF DATEORTIME>

The field is a date, time, or nullable date or time.

<IF DATETODAY>

The date field should default to the current date.

<IF DATE_JULIAN>

The field is a date or nullable date of type YYJJJ or YYYYJJJ.

<IF DATE_NOT_JULIAN>

The field is a date or nullable date, but not a Julian date. It could be a reverse date or a period date.

<IF DATE_NOT_NULLABLE>

The field is a date, but not a nullable date.

<IF DATE_NOT_PERIOD>

The field is a date or nullable date but not a period date. It could be a reverse date or a Julian date.

<IF DATE_NOT_YMD>

The field is a date or nullable date, but is NOT a YYMMDD or YYYYMMDD date.

<IF DATE_NOT_YYYYMMDD>

The field is a date or nullable date, but is NOT a YYYYMMDD date.

<IF DATE_NULLABLE>

The field is a NULLABLE date.

<IF DATE_PERIOD>

The field is a date or nullable period date (YYPP or YYYYPP).

<IF DATE_YMD>

The field is a date or nullable date of type YYMMDD or YYYYMMDD.

<IF DATE_YYMMDD>

The field is a date or nullable date of type YYMMDD.

<IF DATE_YYYYMMDD>

The field is a date or nullable date of type YYYYMMDD.

<IF DATE_YYJJJ>

The field is a date or nullable date of type YYJJJ.

<IF DATE_YYYYJJJ>

The field is a date or nullable date field of type YYYYJJJ.

<IF DATE_YYPP>

The field is a date or nullable date of type YYPP.

<IF DATE_YYYYPP>

The field is a date or nullable datye of type YYYYPP.

<IF DECIMAL>

The field data type is decimal. Note that date, nullable date and time fields are NOT treated as decimal fields with this conditional test.

<IF DEFAULT>

The field has a default value specified.

<IF DESCRIPTION>

The field has a description specified.

<IF DISABLED>

The field is defined as being initially disabled.

<IF DISPLAY>

The field has a display method specified.

<IF DISPLAY_LENGTH>

The field has a display length specified.

<IF DRILL>

The field has a drill method specified.

<IF ECHO>

The field should echo characters as they are typed.

<IF EDITFORMAT>

The field has an edit format method specified.

<IF ENABLED>

The field is defined as being initially enabled.

<IF ENUM>

The field is an ENUM field. This is a real language enumeration, not a UI Toolkit enumerated field.

<IF ENUMERATED>

The field has a UI Toolkit enumeration specified. This is not the same as being a real language ENUM field.

<IF EXPLICIT_GROUP>

The current field is an explicit group that was not expanded into individual fields.

<IF EXPLICIT_GROUP_NO_EXPAND>

Explicit groups are not being expanded to individual fields (i.e. the -g e command line option is set).

<IF FIELD_POSITION>

The field has a UI field position specified.

<IF FIRST_UNIQUE_KEY_SEGMENT>

The field is a segment in the structures first unique key.

<IF FORMAT>

The field has a display format specified.

<IF GROUP>

The current field is an unexpanded implicit or explicit group.

<IF GROUP_MEMBER_PREFIX>

The current field is an unexpanded implicit or explicit group and has a member prefix specified.

<IF GROUP_MEMBER_PREFIX_COMPILER>

The Synergy compiler uses the group member prefix?

<IF GROUP_OVERLAY>

The current field is an unexpanded implicit or explicit overlay group.

<IF HEADING>

The field has a report heading specified.

<IF HELPID>

The field has a help identifier specified.

<IF HYPERLINK>

The field has a hyperlink method specified.

<IF I1>

The field is an I1.

<IF I2>

The field is an I2.

<IF I4>

The field is an I4.

<IF I8>

The field is an I8.

<IF I124>

The field is an I1, I2 or I4.

<IF INFOLINE>

The field has information line text specified.

<IF INPUT_CENTER>

Input should be performed center justified.

<IF INPUT_LEFT>

Input should be performed left justified.

<IF INPUT_RIGHT>

Input should be performed right justified.

<IF INTEGER>

The field data type is defined as integer.

<IF IMPLICIT_GROUP>

The current field is an implicit group that was not expanded into individual fields.

<IF IMPLICIT_GROUP_NO_EXPAND>

Implicit groups are not being expanded to individual fields (i.e. the -g i command line option is set).

<IF KEYSEGMENT>

The field is used as a segment in one or more access keys.

<IF LANGUAGE>

The field is available to the language.

<IF LEAVE>

The field has a leave method specified.

<IF LENGTH_OVER_8>

The length of the field is over 8 characters. This expression is primarily useful when dealing with numeric fields because decimal fields with a length of up to 8 digits are mapped to an int, whereas fields 9 characters or longer are mapped to a long.

<IF LONGDESC>

The field has a long description specified.

<IF MAPPED>

The field has a CodeGen field mapping specified.

<IF MAPPEDSTR>

The fields’ parent structure has a CodeGen structure mapping specified.

<IF MAPPING_FUNCTION>

The field has a mapping function defined.

<IF NAME_LINK>

The field allows linking by name.

<IF NEGATIVE_ALLOWED>

The field allows negative values. Use of this expression is only appropriate for numeric fields.

<IF NEGATIVE_ORZERO>

The field allows negative values or a value of zero. Positive values are not allowed. Use of this expression is only appropriate for numeric fields.

<IF NEGATIVE_REQUIRED>

The field requires a negative value. Use of this expression is only appropriate for numeric fields.

<IF NOALLOW_LIST>

The field does not have allow list values specified. (Deprecated use <IF NOT ALLOW_LIST>.)

<IF NOALTERNATE_NAME>

The field does not have an alternate name specified. The <FIELD_ALTNAME> token will always return a value because if no alternate name is specified in the repository then it defaults to the fields real name. This token allows you to detect whether the alternate name is the same as the real name. . (Deprecated use <IF NOT ALTERNATE_NAME>.)

<IF NOARRIVE>

The field does not have an arrive method.. (Deprecated use <IF NOT ARRIVE>.)

<IF NOBREAK>

The field id not a break field.. (Deprecated use <IF NOT BREAK>.)

<IF NOCHANGE>

The field does not have a change method.. (Deprecated use <IF NOT CHANGE>.)

<IF NOCHECKBOX>

The field should not be displayed as a check-box.. (Deprecated use <IF NOT CHECKBOX>.)

<IF NOCOERCEBOOLEAN>

The field data type is not coerced to boolean.. (Deprecated use <IF NOT COERCEBOOLEAN>.)

<IF NODEFAULT>

The field does not have a default value.. (Deprecated use <IF NOT DEFAULT>.)

<IF NODESCRIPTION>

The field does not have a description.. (Deprecated use <IF NOT DESCRIPTION>.)

<IF NODISPLAY>

The field does not have a display method.. (Deprecated use <IF NOT DISPLAY>.)

<IF NODISPLAY_LENGTH>

The field does not have a display length.. (Deprecated use <IF NOT DISPLAY_LENGTH>.)

<IF NODRILL>

The field does not have a drill method.. (Deprecated use <IF NOT DRILL>.)

<IF NOECHO>

The field should not echo characters as they are typed.. (Deprecated use <IF NOT ECHO>.)

<IF NOEDITFORMAT>

The field does not have an edit format method.. (Deprecated use <IF NOT EDITFORMAT>.)

<IF NOFORMAT>

The field does not have a format string.. (Deprecated use <IF NOT FORMAT>.)

<IF NOHELPID>

The field does not have a help ID.. (Deprecated use <IF NOT HELPID>.)

<IF NOHYPERLINK>

The field does not have a hyperlink method.. (Deprecated use <IF NOT HYPERLINK>.)

<IF NOINFOLINE>

The field does not have information line text.. (Deprecated use <IF NOT INFOLINE>.)

<IF NOLANGUAGE>

The field is marked as “Excluded by Language”.. (Deprecated use <IF NOT LANGUAGE>.)

<IF NOLEAVE>

The field does not have a leave method.. (Deprecated use <IF NOT LEAVE>.)

<IF NOLONGDESC>

The field does not have a long description specified.. (Deprecated use <IF NOT LONGDESC>.)

<IF NONEGATIVE>

The field does not allow negative values. This expression should only be used with numeric fields.. (Deprecated use <IF NOT NEGATIVE>.)

<IF NOPAINTCHAR>

The field does not have a custom paint character.. (Deprecated use <IF NOT PAINTCHAR>.)

<IF NOPRECISION>

The field does not have a decimal precision specified (i.e. it is not an implied decimal field).. (Deprecated use <IF NOT PRECISION>.)

<IF NOPROMPT>

The field does not have a prompt.. (Deprecated use <IF NOT PROMPT>.)

<IF NORANGE>

The field does not have a numeric range specified. This expression should only be used for numeric fields.. (Deprecated use <IF NOT RANGE>.)

<IF NOREPORT>

The field is marked as “Excluded by ReportWriter”.. (Deprecated use <IF NOT REPORT>.)

<IF NOSELECTIONS>

The field does not have selection list values.. (Deprecated use <IF NOT SELECTIONS>.)

<IF NOSELWND>

The field does not have a selection window name specified.. (Deprecated use <IF NOT SELWND>.)

<IF NOTALPHA>

The field data type is not defines as Alpha.. (Deprecated use <IF NOT ALPHA>.)

<IF NOTARRAY>

The field was not part of an array.. (Deprecated use <IF NOT ARRAY>.)

<IF NOTBINARY>

The field is not a binary field. Binary fields are also alpha fields.. (Deprecated use <IF NOT BINARY>.)

<IF NOTBOOLEAN>

The field is not a boolean field.. (Deprecated use <IF NOT BOOLEAN>.)

<IF NOTBZERO>

The numeric field should not be displayed as blank if the value is zero.. (Deprecated use <IF NOT BZERO>.)

<IF NOTDATE>

The field is not a date or nullable date.. (Deprecated use <IF NOT DATE>.)

<IF NOTDATEORTIME>

The field is not a date, nullable date or time.. (Deprecated use <IF NOT DATEORTIME>.)

<IF NOTDATETODAY>

The date field should not default to the current date.. (Deprecated use <IF NOT DATETODAY>.)

<IF NOTDECIMAL>

The field data type is not defined as decimal. Note that date, nullable date and time fields do not count as decimal with this conditional test.. (Deprecated use <IF NOT DECIMAL>.)

<IF NOTENUM>

The field is not a language ENUM field.. (Deprecated use <IF NOT ENUM>.)

<IF NOTENUMERATED>

The field is not a UI Toolkit enumerated field.. (Deprecated use <IF NOT ENUMERATED>.)

<IF NOTIMEOUT>

The field does not have an input timeout specified.. (Deprecated use <IF NOT TIMEOUT>.)

<IF NOTINTEGER>

The field data type is not defined as integer.. (Deprecated use <IF NOT INTEGER>.)

<IF NOTKEYSEGMENT>

The field is not used as a segment in any access key.. (Deprecated use <IF NOT KEYSEGMENT>.)

<IF NOTNUMERIC>

The field data type is not a numeric type.. (Deprecated use <IF NOT NUMERIC>.)

<IF NOTOVERLAY>

The field is not an overlay field or overlay group.. (Deprecated use <IF NOT OVERLAY>.)

<IF NOTPKSEGMENT>

The field is not a segment in the primary key.. (Deprecated use <IF NOT PKSEGMENT>.)

<IF NOTRADIOBUTTONS>

The field should not be viewed as a collection of radio-buttons.. (Deprecated use <IF NOT RADIOBUTTONS>.)

<IF NOTSTRUCTFIELD>

The field is not a struct field.. (Deprecated use <IF NOT STRUCTFIELD>.)

<IF NOTOOLKIT>

The field is marked as “Excluded by Toolkit”.. (Deprecated use <IF NOT TOOLKIT>.)

<IF NOTUPPERCASE>

The field should not be converted to uppercase. Only appropriate for alpha fields.. (Deprecated use <IF NOT UPPERCASE>.)

<IF NOTUSER>

The field is not a user-defined field type.. (Deprecated use <IF NOT USER>.)

<IF NOUSERTEXT>

The field does not have user text specified.. (Deprecated use <IF NOT USERTEXT>.)

<IF NOVIEW_LENGTH>

The field does not have a view length specified.. (Deprecated use <IF NOT VIEW_LENGTH>.)

<IF NOTTIME>

The field is not marked as a time field.. (Deprecated use <IF NOT TIME>.)

<IF NOTUSERTIMESTAMP>

The field is not a user-defined time-stamp field. (See <FIELD_SQLTYPE> for more information).. (Deprecated use <IF NOT USERTIMESTAMP>.)

<IF NOWEB>

The field is marked as “Excluded by Web”.. (Deprecated use <IF NOT WEB>.)

<IF NUMERIC>

The field data type is defines as a numeric type.

<IF OCNATIVE>

The fields Objective-C data type is a native type (e.g. int or BOOL).

<IF OCOBJECT>

The fields Objective-C data type is an object type (e.g. NSString or NSDate).

<IF ONLY_PKSEGMENT>

The field is the only segment in the primary key.

<IF OPTIONAL>

The field is marked as optional (i.e. not required).

<IF OVERLAY>

The field is an overlay field or overlay group.
NOTE: This token should only be used when overlay fields are being included in processing via the -f o command line option.

<IF OVERLAY_OFFSET>

The field has an overlay offset defined.
NOTE: This token should only be used when overlay fields are being included in processing via the -f o command line option.

<IF PAINTCHAR>

The field has a custom paint character specified.

<IF PAINTFIELD>

The field is a paint field. This means that characters will not be displayed, but rather the paint field character (default asterisk) will be displayed instead.

<IF PII_SCRUB>

The field has a PII_TYPE encoded into its long description or user defined text field. See <FIELD_PII_TYPE>.

<IF PKSEGMENT>

The field is a segment in the primary key.

<IF PRECISION>

The decimal field has a precision specified (i.e. it is an implied decimal field).

<IF PROMPT>

The field has a prompt specified.

<IF PROMPT_POSITION>

The field has a UI prompt position specified.

<IF RADIOBUTTONS>

The field should be viewed as a collection of radio-buttons.

<IF RANGE>

The field has a numeric range (minimum/maximum values) specified.

<IF READONLY>

The field state is specified as initially read-only.

<IF READWRITE>

The field state is specified as initially writable.

<IF RELATION>

The field is associated with the only segment of a relations FROM key.  In other words, there is a direct outbound relation from the field to another structure.

<IF REPLICATION_MORE>

There are more fields to be processed in the current field loop. This special token takes into account fields that have been excluded from processing in a SQL Replication environment by adding the text REPLICATOR_EXCLUDE to a fields long description or user defined text fields.

<IF REPLICATION_NOMORE>

There are no more fields to be processed in the current field loop. This special token takes into account fields that have been excluded from processing in a SQL Replication environment by adding the text REPLICATOR_EXCLUDE to a fields long description or user defined text fields.

<IF REPORT>

The field is available to ReportWriter.

<IF REPORT_CENTER>

The field should be printed center justified on reports.

<IF REPORT_LEFT>

The field should be printed left justified on reports.

<IF REPORT_RIGHT>

The field should be printed right justified on reports.

<IF REQUIRED>

The field is marked as required (i.e. must contain a valid value).

<IF REVERSE>

The field should be displayed in reverse video.

<IF SELECTIONS>

The field has one or more selection list values.

<IF SELWND>

The field has a selection window name specified.

<IF STRUCTFIELD>

The field is a struct field.

<IF TEXTBOX>

The field should be displayed as a text-box.

<IF TIME>

The field is a time field of type HHMM or HHMMSS.

<IF TIME_HHMM>

The field is a time field of type HHMM.

<IF TIME_HHMMSS>

The field is a time field of type HHMMSS.

<IF TIMEOUT>

The field has an input timeout specified.

<IF TIMENOW>

The time field should default to the current time.

<IF TOOLKIT>

The field is available to UI Toolkit.

<IF UNDERLINE>

The field content should be displayed underlined.

<IF UNMAPPING_FUNCTION>

The field has an unmapping function defined.

<IF UPPERCASE>

The field value should always be converted to uppercase.

<IF USED_IN_RELATION>

The field is associated with a key segment that in turn is used in a relation.

<IF USER>

The field is a user defined field type.

<IF USER_TYPE>

The field has a user-defined type string defined.

<IF USERTEXT>

The field has user text specified.

<IF VIEW_LENGTH>

The field has a view length specified.

<IF USERTIMESTAMP>

The field is a user-defined time-stamp field. (See <FIELD_SQLTYPE> for more information).

<IF WEB>

The field is available to the web products.