topic Initializing a Character Variable in ODS and Base Reporting

Initializing a Character Variable

OS2Rules — Wed, 24 Mar 2010 14:16:53 GMT

Hi All:

This may be a rather basic question, but how do I initialize a large character variable with data?

My variable is 4000 bytes and I am writing specific values in parts of the record using the SUBSTR function. I want to pack bytes 3001 to 4000 with '0' (zeros) or some other character.

If it was a PUT statement I could use 1000*'0' and it would write 1000 zeros, but I can't use:

substr(text,3001,1000) = 1000*'0';

because that returns a missing value.

I would rather not do it manually and a DO loop sounds like a lot of processing for what I'm trying to do.

Re: Initializing a Character Variable

deleted_user — Wed, 24 Mar 2010 14:41:14 GMT

Have you tried the REPEAT function? e.g.

substr(text,3001,1000)=repeat(‘0’,999);

This repeats the character ‘0’ 999 times making 1+999=1,000 characters altogether.

Re: Initializing a Character Variable

OS2Rules — Wed, 24 Mar 2010 15:24:56 GMT

Thanks - that seems to have done it.

Must have missed that one ....