|
View previous topic :: View next topic
|
| Author |
Message |
dileep.james
Warnings : 1
New User
Joined: 22 Apr 2005
Posts: 4
Location: mumbai
|
|
|
|
hi
i want to move X(03) to a DB2 hostvariable in the form of
10 PROD-ID.
49 PROD-ID-LEN PIC S9(04) usage comp.
49 PROD-ID-TEXT PIC X(20).
hOW TO MOVE X(03) VARABLE TO THAT HOST VARIBLE
WHEN I MOVED X(03) VARABLE TO PROD-ID-TEXT PIC X(20).
IT WILL RUN SUCESSFULLY
BUTT DATA DIDN'T ENTER INTHE TABLE
WHEN I MOVE X(03) VARABLE TO PROD-ID DIRECTLY ,IT GIVES
ERROR WHEN COMPLE THAT PROGRAM
CAN ANY ONE HELP ME |
|
| Back to top |
|
 |
kvivek
New User
.jpg)
Joined: 09 May 2005
Posts: 51
Location: Singapore
|
|
|
|
| Quote: |
WHEN I MOVED X(03) VARABLE TO PROD-ID-TEXT PIC X(20).
IT WILL RUN SUCESSFULLY |
For varchar variables the first two bytes will identify the length of the text stored and you need to move the length in this location. Could you try
| Code: |
| MOVE LENGTH OF <X(03) VARIABLE> TO PROD-ID-LEN |
Regards,
Vivek |
|
| Back to top |
|
|
|
|
