A change was made to the SQL DATE and DAYS functions in Enterprise Developer 2.2 Hotfix 3, that affects all later releases. If programs using these functions, that pre-compiled successfully in earlier releases, fails to pre-compile, you probably need to apply the following fix.
If the HCOSS directive DIALECT=MAINFRAME is used, and compilation of COBOL or PL/I code that uses the scalar functions DATE or DAYS is required, the script InstallDigitsFunction.sql must be executed manually against your SQL Server database(s).
For default installations, this product script is located in the C:\\ProgramData\\Micro Focus\\Enterprise Developer\\hcoss directory.
To execute this T-SQL script, go into SQL Server Management Studio. Use File -> Open -> Fileā¦ to find and open the script. Then pick the appropriate SQL Server database from the Available Databases drop-down menu, and execute the script.
#MFDS
#EnterpriseDeveloper
