Can not able to declare character field with the length of 6000 in SQLRPGLE program.

695 pts.
Tags:
AS/400
RPG ILE
SQLRPGLE
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)

ASKED: March 23, 2012  9:30 PM
UPDATED: March 26, 2012  4:10 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    ...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
    125,585 pointsBadges:
    report
  • Mohan K
    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)
    695 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following