I just want to ask why does the variable I passed in a dclgen of sql that has

I just want to ask why does the variable I passed in a
dclgen of sql that has a data type of varchar which has a
maximum length is 250 is truncated,,

Here is the code..

DCLGEN of rsauud01 table
01 dataarea
43 data-area-len pic s9(4).
43 data-area-text pic x(250).
MYVARIABLE.
01 DATAAREA1 pic x(250).

move 250 to data-area-len of dataarea of rsauud01
MOVE DATA-AREA1 TO data-area-text of dataarea of rsauud01

---
but it is always trucated everytime I insert it in the table
by the way it is a cobol-cics program

Question Posted / angeldust03

2 Answers
4650 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I just want to ask why does the variable I passed in a dclgen of sql that has a data type of varch..

Answer / anna

the variable shoud be under level 49 and pic comp.
01 dataarea.

49 data-area-len pic s9(4) comp.
49 data-area-text pic x(250).

Is This Answer Correct ?

3 Yes

0 No

I just want to ask why does the variable I passed in a dclgen of sql that has a data type of varch..

Answer / virender

I think Anna level number 49 does not matter here. I think
the problem is because of using "of dataarea of rsauud01"
with the move statement.

Just use
move 250 to data-area-len
MOVE DATA-AREA1 TO data-area-text

Please let me know if it worked.

Is This Answer Correct ?

3 Yes

1 No

Post New Answer