The new V10 version of DB2 treats CHAR(decimal column) in a different way
than V9 treated.
Now in DB2 V10 we have this below for CHAR(decimal column).
In Version 10, when the input data is in decimal format, the CHAR, VARCHAR,
CAST(decimal-expression AS CHAR), and CAST(decimal-expression AS VARCHAR)
functions no longer return:
- Leading zeros.
- The trailing decimal point character.
- Leading blanks for positive decimal values. This change applies to the
CHAR built-in function only.
So I was thinking if could have some BUILTIN FUNCTION in PL/I to receive
those data and treats as expected, i.e., as in V9
2013/5/16 Lizette Koehler stars...@mindspring.com
Could you provide an example of what you used before, the PL/I code, and
what the data looks like now?
Also, have you asked this question on the DB2 Newsgroup? They may already
have an answer over there. If you would like to join the DB2 Newsgroup, go
to www.idug.org
Lizette
-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On
Behalf Of Paulo Roberto Leonardo Pereira
Sent: Thursday, May 16, 2013 9:16 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: DB2 for z/OS version 10
DB2 for z/OS version 10 changed the string format of decimals. we are using
Enterprise PL/I. Does a built-in function exist which can help us with the
new format decimal number strings? Is there a recommendation for a
technique which handles such numbers?
Thanks
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
--
Obrigado,
Paulo Pereira
(21) 2526-3586
(21) 9806-0825
--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
