Answer Posted / sxion045
CREATE VIEW RR(A,B,X) AS
SELECT R.*, ROW_NUMBER()
FROM R;
DELETE FROM RR
WHERE X=20000000;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is ibm db2 database?
How can we retrieve the total number of records in RPG & CLLE?
What is buffer pool and list some of them?
What are catalog tables in db2?
Is db2 a database?
What is database alias db2?
Are view updateable?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Can there be more than one cursor open for any program?
What is a db2 schema?
How do I start db2 in windows?
What is dbrm? What it contains? When it will be created?
What are the full forms of spufi and dclgen and why are they used?
What is runstats utility in db2?
What is reorg and runstats in db2?