Answer / siva

let us consider we have a database with no of tables and one table name is ComputerScienceAndEngineering_Departement
if any one want to access this table they should use full name
ex: select * from ComputerScienceAndEngineering_Departement ;
it may be difficult to someone and sometimes to us also .
so if we creating alias like csedept then it will become simple to access it.
An alias is simply an alternate name for a table or view. Like tables and views, an alias can be created, dropped, and have comments associated with it.

What is the function of buffer manager?

1 Answers  

---

What are the levels of isolation available with DB2V4

2 Answers   IBM,

---

What is ibm db2 used for?

0 Answers  

---

is there any restrictions for unions ?

4 Answers   Patni,

---

Which is faster delete or truncate?

0 Answers  

---

What is the format (internal layout) of ?TIMESTAMP??

1 Answers  

---

How to test SQL -911 error while developing COB-DB2 program

1 Answers   Satyam,

---

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  

---

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  

---

How can we define a table? How can we apply SEARCH ALL on it ?

1 Answers  

---

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

---

what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

1 Answers  

---