I have one column say 'X' defined as VARCHAR
Can anyone tell me What are the different ways to update
this column thru COBOL-DB2 program?

Answer Posted / 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

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are decleratives in cobol?

1831


How to find out the closest prime number of an input number? I believe it has something to do with SEARCH and COBOL Linear Array.

3724


1.Is it possible to move the data from 99.99 to 99v99? 2.What is the CICS-vsam Compilation process? 3.In My GDG 5 generation will be there GDG3 got an abend what will happen? 4.In my GDG first generation is +1 And I want to add the new generation what will happen previous generation? 5.How can you give the PIC clause below conditions A). s9 (reddy), B). s9 (5) occurs 5 times? 6.How override the proc from a particular step? and what is symbolic and override Procs?

5379


What are the access modes of START statement?

719


How did the release of cobol/370 version 1.3 improve the performance of release 1.1?

645






Explain sorting techniques in cobol program? Provide the sort file definition, the sort statement, its syntax and meaning

686


What type of SDLC u followed? Why?

1522


What is the difference between external and global variables in COBOL?

815


how do you reference the printer file formats from cobol programs

669


How do you reference the following file formats from cobol programs?

699


What are declaratives and what are their uses in cobol?

714


Why do we code s9 (4) comp. Inspite of knowing comp-3 will occupy less space?

720


write a cobol logic. i have file that has 10 records .1 record go to first output file and second record goes to 2 output and etc

714


System Testing for Mainframe Developers What is System Testing? integration testing ? what's the procedure ..

1592


What are the pertinent COBOL commands?

2628