What are delete-connected tables?
Answer / s
tables that are connected in a referential integrity
relationship. Delete of the primary keys deletes the
corresponding foreign keys.
| Is This Answer Correct ? | 2 Yes | 0 No |
What is the clustering index in the db2 database?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
What is DCLGEN ?
What is package in cobol db2?
What is the difference between Where and Having Clause
What is database reorganization?
What is the difference between db2 and oracle?
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
What are the disadvantages of using VARCHAR?
what is Static and dynamic linking