Technote (troubleshooting)

Problem(Abstract)

Pad character outputs as space instead of "0" for empty numeric fields in Export maps

Cause

Originally the translator only used the field settings, when a field existed. If a numeric field does not exist, it does not use the pad character from the field settings

Resolving the problem

A fix was added to check the condition in export, during translation to look for "PadFillEmptyNum" value in the registry.

If it does not exist, we create it and set it to "FALSE". If it exists and is false, we pad empty numeric map segments using the default setting which is spaces. Otherwise, if it's true, we pad with the pad character the customer has specified. This registry key cannot be changed through the UI and must be manually changed in the registry. This key is located in: 32 bit OS: HKLM \ SOFTWARE \ Sterling Commerce \ Gentran \ <Version Num Folder> 64 bit OS: HKLM \ SOFTWARE \ Wow6432Node \ Sterling Commerce \ Gentran \ <Version Num Folder>