Shrink a dataset file to smaller column length

[leo6]

Hi ,

Can a dataset file be shrinked by removing data between specific column locations using REXX in Mainframes?
For eg.,consider a dataset having 4 records as ,

abc defghijklmnopqrs
abc defghijklmnopqrs
abc defghijklmnopqrs
abc defghijklmnopqrs

I want the output file to be ,

abcdefghijklmnopqrs
abcdefghijklmnopqrs
abcdefghijklmnopqrs
abcdefghijklmnopqrs

which is after removing the space characters in column 3 and 4 for all records of the file..
Is it possible using overlay() function ?
Kindly advice.

 

[JamesLean]

Has this got anything to do with SQL Server?

--James

 

[dbomrrsm]

if it has !!!

Update yourtable
set yourcolumn = replace(yourcolumn,' ','')

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]