Answer / s

Drops the plan.

Answer / sv kumar

it will delete that existing plan

can we drop column from a table

7 Answers   INDUS,

---

i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.

0 Answers  

---

Can we install 2 different versions of Db2 on same mainframe?

3 Answers  

---

How do you retrieve the data from a nullable column?

2 Answers  

---

Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,

---

Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 Answers  

---

What is cursor stability?

1 Answers  

---

What is the maximum length of sqlca?

0 Answers  

---

What is referential integrity?

5 Answers  

---

What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

1 Answers   CTS,

---

Can you access the DB2 Directory table using SQL?

3 Answers  

---

Discuss about db2 bind?

0 Answers  

---