Re: Cannot append to a field

On 5/1/2014 1:20 PM, Colson, Edmund B wrote:

OK, guys. I have a program variable in an SQLRPGLE program I am debugging in RDi 9.0.1 defined as 2000 characters. I am loading this variable with an SQL statement to which I am appending " or CPINSD = XXX" where "XXX" is an alphanumeric number coming from a record in a file. The variable gets to a length of 1024 and I can't append the closing parenthesis to close the statement. I have proven that the length can't exceed 1024 characters by removing the last "or CPINSD = XXX" from the variable so the length is less than 1024 bytes, and the closing parenthesis is properly added to the variable. When I dump the program, the dump shows that the variable has 2000 characters allotted to it.
Is there some limitation that says that a variable in a program cannot exceed 1024 characters?

No, there is no 1024 limit, but the default Monitor setting is to only
show the first 1024. An example of using your own size:

dcl-s testit char(2048);
%subst(testit: 1025: 4) = 'Buck';

In the Monitors view, I add an expression: testit:c 1032 (I only want to
see 1032 characters.) Double click the monitored expression and out
there near the end is 'Buck'. You can, of course, go all the way out to
the declared size of the variable.
--buckn