IBM Support

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): OS/390

Software edition: All Editions

Reference #: 1203412

Modified date: 09 March 2007