MVSFORUMS.com

vani · Beginner Joined: 28 May 2003 Posts: 51 Topics: 30

I need to know if it is possible to change a numeric result within a select statement into a character format.

INSERT INTO SESSION.ATABTXT (asatzart, asaih, atext)
SELECT '0005',
MWSTID,
MWSTBEZ
FROM VMWST;
SqlError(SQLCODE,540);
/*???ASAIH IS CHAR(4) AND MWSTID IS SMALL INT*/

Can we change the format of MWSTID from NUMERIC to CHARACTER within the select statement ?
(I understand that it is possible in oracle by using tochar function)

kolusu · Posted: Mon Nov 24, 2003 6:15 am Post subject:

vani,

Use the scalar function DIGITS which will return a character string representation numeric data type of SMALLINT, INTEGER, or DECIMAL.

Check this link for a detailed explanation of DIGITS

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQH11/3.2.27?SHELF=&DT=20010718164132&CASE=

Hope this helps...

cheers

kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

nivedita · Beginner Joined: 04 Nov 2003 Posts: 22 Topics: 15

Thanks It worked!!!!!