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

Flash (Alert)


Abstract

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.

Content

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.

Rate this page:

(0 users)Average rating

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:

2007-03-09

Translate my page

Machine Translation

Content navigation