INSERTING VARCHAR INTO DB2 TABLE

siddhartha biswas · New User Joined: 04 May 2008 Posts: 13 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

Craq Giegerich · Posted: Mon Oct 20, 2008 6:14 pm Post subject:

Did you happen to notice that ABC has two subfields, ABC-LEN and ABC-TEXT? You need to populate both of them.

guptae · Posted: Mon Oct 20, 2008 6:16 pm Post subject:

Hi Siddartha,

Can you please populate ABC-LEN with the length of your text.

siddhartha biswas · New User Joined: 04 May 2008 Posts: 13 Location: india

THE STRIND TO BE INSERTED HAS GAPS/ SPACES IN BETWEEN SO CANT FIND THE LENGTH I GUESS...

guptae · Posted: Mon Oct 20, 2008 6:26 pm Post subject:

Hi Siddartha,

Please do not use caps lock

siddhartha biswas · New User Joined: 04 May 2008 Posts: 13 Location: india

It worked !! thanks a lot