What is the difference between IN subselects and EXISTS
Answer / s
IN subselect will return rows that match the values in the
IN list. EXISTS will return rows if the subselect return a
|Is This Answer Correct ?||11 Yes||2 No|
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
cursor with hold explain ?
Name some fields from SQLCA.
what is different three logs in DB2?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
what is diffrence b/w file-aid tool and file-aid utility???
can we view the access paths created by dbrm ? how ? thx
How would the varchar column remarks defined?
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
What is the syntax for seeing the columns and data types of a table in the db2 database?
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?