This page (revision-26) was last changed on 21-Dec-2022 09:14 by Kevin Higgs

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
26 21-Dec-2022 09:14 10 KB Kevin Higgs to previous
25 26-Nov-2021 10:22 10 KB Kevin Higgs to previous | to last
24 26-Nov-2021 10:22 10 KB Kevin Higgs to previous | to last
23 26-Nov-2021 10:22 9 KB Kevin Higgs to previous | to last
22 26-Nov-2021 10:22 9 KB Kevin Higgs to previous | to last
21 26-Nov-2021 10:22 9 KB Kevin Higgs to previous | to last

Page References

Incoming links Outgoing links
IDIF

Version management

Difference between version and

At line 59 changed one line
;[Derivation Expression|DERIVATION_EXPRESSION]:This field specifies the derivation expression for the Variable name. Derivation expressions provide the ability to translate values or to retrieve information otherwise not accessible in an interface format in IDIF. Data from within the [{$applicationname}] database may need to be translated to match the requirements from a receiving third party system. Also, data within a source file may need to be translated to match the [{$applicationname}] specifications.
;[Derivation Expression|DERIVATION_EXPRESSION]:This field specifies the derivation expression for the Variable name. Derivation expressions provide the ability to translate values or to retrieve information otherwise not accessible in an interface format in IDIF. Data from within the Personality database may need to be translated to match the requirements from a receiving third party system. Also, data within a source file may need to be translated to match the Personality specifications.
At line 86 changed one line
This option specifies when an IDIF field value is NULL, how UPGLF returns the field value for the Entire GL File
This option specifies when an IDIF field value is NULL, how UPGLF returns the field value for the Entire GL File. The value options are listed in the lexicon as shown below.
At line 88 removed one line
;[Record Number|RECORD_NUMBER]:This is a user assigned record number. Each record number generates a new line in the interface file. The following are suggested record numbers. You can set up your own numbers.
At line 95 changed 4 lines
!Scenario 1
When UDF – GL NULL OPTION VALUE is set to 00 - Use IDIF Derivation Expression
__Result A:__ When no Derivation Expression is configured the system uses a space
__Result B:__ When Derivation Expression is configured using decode(~,'','NULLVALUE',~) no space is populated.
Each option has specific usages associated with them. The chart below outlines each lexicon value and their specific usage within IDIF.
At line 100 changed 3 lines
!Scenario 2
When UDF – GL NULL OPTION VALUE is set to 01 - Use NULL for all NULL values used
__Result:__ All spaces (e.g ' ') are changed to Null values (e.g '') for entire GL unless specified otherwise by using a Derivation Expression, decode(~,'','NULLSPACE',~).
|__Lexicon Value__|__Usage__
|00 - Use IDIF Derivation Expression|__A:__ When no Derivation Expression is configured the system uses a space\\__B:__ When Derivation Expression is configured using decode(~,'','NULLVALUE',~) no space is populated.
|01 - Use NULL for all NULL values|All spaces (e.g ' ') are changed to Null values (e.g '') for entire GL unless specified otherwise by using a Derivation Expression, decode(~,'','NULLSPACE',~).
|02 - Use 1 space for all null value is|All fields that have a null value are populated with 1 space. (e.g. ' ' are changed to '') unless specified otherwise by using a Derivation Expression, decode(~,'','NULLVALUE',~).
At line 104 removed 4 lines
!Scenario 3
When UDF – GL NULL OPTION VALUE is set to 02 - Use 1 space for all null value is used
__Result:__ All fields that have a null value are populated with 1 space. (e.g. ' ' are changed to '') unless specified otherwise by using a Derivation Expression, decode(~,'','NULLVALUE',~).