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
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 |
|
|
|