How does the F0101.DC Compressed Description get compressed?

[KevinCourtney]

Hello,

We have both a JDE 8 installation and a recently installed JDE 9 installation. In JDE 9 the F0101.DC Compressed Description is not compressed where it is in 8.0.

UDC H95/SC looks to be the same between the two.

Is there some other setup in JDE to tell it to compress this description?

Thanks,

 

[KevinCourtney]

I figured it out...

To identify the space as one of the characters that should be stripped from a “DC” description to compress it, the space must be in the H95/SC UDC but the key in 9.0 is that it must be between two of the characters, not at either end…example…

~ \!#^*={}[]|`"'<>.&()
_^ put space after the ~

In 9.0, JDE/Oracle changed the function B0100009 CompressCharacterString so that it trim’s off the spaces at the beginning and at the end of the H95/SC string. In 8.0 it does not do this trimming so a space can be at the end of the string and it will be used as one of the characters to strip out.

 

[BOster]

Yup, that one got us during our 9.0 conversion. Basically there was a bug in prior releases of the function. It didn't trim the trailing spaces from the end of the UDC description field so it removed spaces whether you wanted it to or not.

One very important thing to remember, once you set this UDC do NOT change it. Things will start to NOT work and you will have a hell of a time trying to fix new data once you figure this out. If you are converting old data as part of an upgrade project, you MUST put a space between two of the chars like the OP describes.

 

[amolchandane]

Hi Kevin it also helped us while doing code current for 8.12 as well