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 <[email protected]> > 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:[email protected]] On > Behalf Of Paulo Roberto Leonardo Pereira > Sent: Thursday, May 16, 2013 9:16 AM > To: [email protected] > 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 [email protected] 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 [email protected] with the message: INFO IBM-MAIN
