Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose we have a query for update
update table1
set col1 = 'val1'
where col2=(select .... from ...)
suppose the subquery does not return any record, what will
happen to update?
- 1 Answers
- 6118 Views
- IBM, I also Faced
- E-Mail Answers
Answer / santosh kumar d
If the col2 field having any null value then that value to
be updated.
If col2 doesn't have any null value then record remains same
nothing will be updated.
| Is This Answer Correct ? | 4 Yes | 6 No |
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
wht steps we need will coding cobol and db2 pgm ?
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
what's the error code for Unique Index Violation?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What does the sqlcode of -818 pertain to?
What is sqlcode -922 ?
Can we install 2 different versions of Db2 on same mainframe?
Why do we use cursor?
Explain the function done by data manager?
COBOL 
