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:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.