Getting SQL -117 from ICMMLSUP job if DSNHDECP parm DECIMAL is COMMA.
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 -
INSERT INTO ?CREATOR?.ICMSTPrivSets VALUES (1,131);
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.
More support for:
Content Manager for z/OS
Software version: 8.2, 8.3, 8.4
Operating system(s): OS/390
Software edition: All Editions
Reference #: 1203412
Modified date: 09 March 2007