MVSFORUMS.com

nag77 · Beginner Joined: 03 Jan 2006 Posts: 11 Topics: 8

Hi

I have one variable named as numeric-item with SIZE 10.
Some NIs are with size 5.

NI
-----
1243231231
1243231231
12432
12432

If the 6th-10th bytes are not available ,I have to insert zeros in the spaces, i mean the vales of NI should be like

NI
-----
1243231231
1243231231
1243200000
1243200000

How can i do this??

Thanks in Advance..

Regards
Nag.

kolusu · Posted: Sat Jan 28, 2006 5:55 am Post subject:

nag77,

Try this

nag77 · Beginner Joined: 03 Jan 2006 Posts: 11 Topics: 8

Hi kolusu

I have other variables also in this table
ex: Fn pic x(10).
Ln Pic x(10).
NI pic x(10).

when this case i have to give the query as

SELECT REPLACE(25,30,' ','0')
FROM TABLE
;

is it right????

thanks
NAG

kolusu · Posted: Sat Jan 28, 2006 6:09 am Post subject:

nag77,

where did you get the 25,30 from in your SELECT clause?

Your sql will be