Getting SQL -117 from ICMMLSUP job if DSNHDECP parm DECIMAL is COMMA.

Flash (Alert)


If you use a comma to indicate a decimal point, you will get a -117 sql error when running this job from DB2® Content Manager 8.2 on z/OS® if it comes from one of the PTFs.


As shipped, the ICMMLSUP job does inserts into tables in the DB2 Content Manager library server. This is only a problem if you use a comma for a decimal indicator like in Europe. For those that use a period, there is no issue. The definitions for those inserts do not include a space after the comma. An example from the jobs is -
The (1,131) should have been (1, 131). The workaround for this problem is to insert a space after the comma and that will avoid the failure.

Document information

More support for:

Content Manager for z/OS
Library Server

Software version:

8.2, 8.3, 8.4

Operating system(s):


Software edition:

All Editions

Reference #:


Modified date:


Translate my page

Content navigation