E-DB2 Execution of SET CURRENT PRECISION = “D31,6”
Last updated on APRIL 19, 2016
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.53 to 8.53 [Release 8.4]
Information in this document applies to any platform.
PeopleTools 8.53 Installation for DB2 for z/OS
Please refer to the PeopleTools 8.53 Installation Guide for Db2 Zos platform.
This can be found on the PeopleSoft PeopleTools 8.53 Installation Home Page (Doc ID 1523278.1)
See Task 1-8-2: Defining Decimal Arithmetic under chapter "Understanding DB2 Configuration Requirements"
PeopleSoft code executes the statement SET CURRENT PRECISION = “D31,6” for each connection into
the database, which will have the effect of running the application in a DB2 subsystem with zparm settings
of DECARTH=31 and MINDVSCL=6, overriding what the actual zparm settings may be. DECDIV3 is overridden by MINDVSCL so whether DECDIV3 is YES or NO has no impact on the PeopleSoft application.
Question: where is the setting for the PeopleSoft code to execute the statement SET CURRENT PRECISION = “D31,6” ?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms