Can not able to declare character field with the length of 6000 in SQLRPGLE program.
Hi,
I am declaring a stand alone character field with the length of 6000 in my SQLRPGLE program, but when i debug the program to see the the values in this character field i could find only 1024 length is allocated for this field.
Could anyone please help me urgently to declare a character field with the length of 6000, since i want the to place a big SQL string into this character field in my program which consists of 6000 characters. Please see below the declations in my program.
D INSQLSTR S 6000A INZ(*Blanks)
Software/Hardware used:
I am declaring a stand alone character field with the length of 6000 in my SQLRPGLE program, but when i debug the program to see the the values in this character field i could find only 1024 length is allocated for this field.
Could anyone please help me urgently to declare a character field with the length of 6000, since i want the to place a big SQL string into this character field in my program which consists of 6000 characters. Please see below the declations in my program.
D INSQLSTR S 6000A INZ(*Blanks)
Software/Hardware used:
ASKED:
March 23, 2012 9:30 PM
UPDATED:
March 26, 2012 4:10 PM
...when i debug the program to see the the values in this character field i could find only 1024 length is allocated for this field.
If you don't ask for more than 1024, that's all that debug will ever show. It has nothing to do with how big the field is. The default maximum display size is 1024 bytes.
If you want more displayed, then ask for more on the EVAL statement.
Tom
Other Answers:
Latest Answer Wiki Contributors:
To see other answers submitted to the Answer Wiki: View Answer History.
Hi Tom,
Thanks for your help, I could able to view the value of 6000 length character field by using your below suggestion.
Syntax:
EVAL FieldName :C Number of bytes (Ex: EVAL SQLSTRING :C 6000)