Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 16572 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 4 Yes | 0 No |
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
| Is This Answer Correct ? | 3 Yes | 0 No |
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
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / ravi
1.Use Update ....
2.Using Cursor ..for update only.
| Is This Answer Correct ? | 0 Yes | 1 No |
What will happen if we move SPACES to numeric field and ZEROES to alphabetic field?
how to transfer the file from pc to mainframe??
what are the working storage fields in BMS macro?
which one is better among static call and dynamic call?
how to refer the data field?
What is Static,Dynamic linking ?
Define REDEFINE clause and Is it possible to have the redefine clause anywhere in the working storage section for a data name?
what is difference bt COND, REGION & TIME parameters at JOB & EXEC. give an exp.
What is the difference between index and subscript?
In COBOL CALL-CALLING,if a program A is calling 3 sub- programs, dynamically, then it is said sub-programs will always will always in Initial Mode. My question is : Do we need to code CANCEL or (IS INITIAL) for dynamically called sub-programs or it is the property of Dynamically called pgms so every time sub-pgms are called they will be in initial mode. ***This question is only Dynamic call****, Please reply. Thank you in advance.
Write a program to concert an Indexed file into Sequential file?
I want ALL ERROR codes in VSAM
3 Answers American Express, TCS,
COBOL 
