Answer / anoop

As far as my knowledge if there is a VARCHAR in table then
its host variable should have the length field and data
field. I feel you have to populate bothe the fields in order
to update the VARCHAR field. please get it confirmed also.

Answer / priyanka

If a variable is defined as varchar, the filed will have a
length variable also. Before updating the value 'X', you
need to move the length of the new value to length filed
of 'X'.
Eg: If you want to update 'TEST' in 'X'.

MOVE LENGTH OF 'TEST' TO X-LENGTH
exec sql
UPDATE table
SET X = 'TEST'
Where clause
end-exec

Answer / shree

Use update query in the COBOL program inside the DB2 code
block
EXEC SQL
UPDATE <TABLE NAME> SET <COLUMN NAME> = 'X'
WHERE CLAUSE
END-EXEC

Answer / kk

hi,
if declare varchar format must declare length and text in
level no 49.

Answer / ravi

1.Use Update ....
2.Using Cursor ..for update only.

what is the use of comp2 ? where can we use it with example ?

3 Answers   Covansys,

What is the Purpose of Pointer in the string?

0 Answers  

)If there are 10 steps in GDG, if I want to refer the step2 after step5 . what should I do?

0 Answers   IBM,

COMP-3 field occupy ?

8 Answers  

What COBOL construct is the COBOL II EVALUATE meant to replace?

1 Answers  

I want to remove a duplicates form a given input field using cobol program. please Any one help me out to solve this ... Thanks in Advance.

3 Answers   IBM,

What type of SDLC u followed? Why?

0 Answers   IBM,

What does the initialize statement do ?

2 Answers  

hi is there any means of deletin a record from a ps usin cobol not using jcl?eg if i am reading a record and if some condition is matched tat particular record must be deletd fom the ps

5 Answers   iNautix,

how will you define vsam file in select clause?

3 Answers   Patni,

how many bytes does a s9(12)COMP-4 field occupy?? a.2 b.4 c.8 d.1 ans with reason please

2 Answers  

What does the IS NUMERIC clause establish ?

2 Answers