Answer / s

CREATE TABLE AAA
LIKE TABLE BBB;

Answer / nag(igate)

the like will create the same table structure and it will
not copy data from existing table.

how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE

10 Answers   IBM,

---

Describe what a storage group(STOGROUP) is?

2 Answers  

---

which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers   Accenture, Wipro,

---

What does DSNDB07 database do?

2 Answers  

---

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

0 Answers  

---

What is multi row fetch in db2?

0 Answers  

---

What is the usage of open cursor command?

0 Answers  

---

What is the picture clause of null indicator variable?

0 Answers  

---

what are bind concepts in db2 cobol?

0 Answers  

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  

---

How do you insert a record with a nullable column?

2 Answers  

---