View previous topic :: View next topic
|
Author |
Message |
sandhyaimmadi
New User
Joined: 18 Aug 2008 Posts: 50 Location: Bangalore
|
|
|
|
I have one field in the table which is varchar.
So I have it in working storage as
10 WS-EDIT-MSG-TX.
49 WS-EDIT-MSG-TX-LEN PIC S9(4) USAGE COMP.
49 WS-EDIT-MSG-TX-TEXT PIC X(254).
I am reading that varchar column value of the existing record into WS-EDIT-MSG-TX.
and moving length of WS-EDIT-MSG-TX-TEXT to WS-EDIT-MSG-TX-LEN
and I am inserting the new record with the same value.
so In the exisiting rec the value is abcde fgh
After I ran my pgm.the value in the new rec is showing as <abcde gfh
I am not getting why '<' is appended before the value.
Could anyone suggest me on this.
Thanks,
Sandhya. |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
Is the column in the new table you are trying to insert defined as VARCHAR? Show us the code you are using! |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
if you have 'selected' (you don't read in db2) the varCHAR field, why are you moving the length of WS-EDIT-MSG-TX-TEXT to WS-EDIT-MSG-TX-LEN?
what value are you moving? why are you moving anything? |
|
Back to top |
|
|
|