View previous topic :: View next topic
|
Author |
Message |
siddhartha biswas Currently Banned New User
Joined: 04 May 2008 Posts: 15 Location: india
|
|
|
|
A FIELD IN DB2 TADLE IS DECLARED AS VARCHAR 100. I NEED TO INSERT A STRING IN THIS FIELD. I HAVE A COPYBOOK WHICH IS DECLARED AS
10 ABC.
49 ABC-LEN PIC S9(4) USAGE COMP.
49 ABC-TEXT PIC X(100).
IF I MOVE THE STRING INTO 'ABC-TEXT' THEN AFTER INSERT ROUTINE THE FIELD IN THE TABLE IS BLANK.
IF I MOVE THE STRING INTO 'ABC' THEN AFTER INSERT ROUTINE I AM GETTING SQL ERROR -311.
PLEASE TELL ME A SOLUTION |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
Did you happen to notice that ABC has two subfields, ABC-LEN and ABC-TEXT? You need to populate both of them. |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hi Siddartha,
Can you please populate ABC-LEN with the length of your text. |
|
Back to top |
|
|
siddhartha biswas Currently Banned New User
Joined: 04 May 2008 Posts: 15 Location: india
|
|
|
|
THE STRIND TO BE INSERTED HAS GAPS/ SPACES IN BETWEEN SO CANT FIND THE LENGTH I GUESS... |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hi Siddartha,
Please do not use caps lock
Quote: |
THE STRIND TO BE INSERTED HAS GAPS/ SPACES IN BETWEEN SO CANT FIND THE LENGTH I GUESS... |
You just need to calculate the length of string which you want to insert in that column
Eg: If you want to enter " insert varchar in to db2 table" then populate
ABC-LEN with 30
Hope it will helpful |
|
Back to top |
|
|
siddhartha biswas Currently Banned New User
Joined: 04 May 2008 Posts: 15 Location: india
|
|
|
|
It worked !! thanks a lot |
|
Back to top |
|
|
|