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
IDIF

Version management

Difference between version and

At line 88 added 5 lines
;[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.
|__Lexicon__ |__Lexicon Value__
|X_GL_NULLVALUE|00 - Use IDIF Derivation Expression
|X_GL_NULLVALUE|01 - Use NULL for all NULL values
|X_GL_NULLVALUE|02 - Use 1 Space for all NULL values
At line 94 added 14 lines
!!Usages
!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.
!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',~).
!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',~).
This page (revision-26) was last changed on 21-Dec-2022 09:14 by Kevin HiggsTop