What is the reason behind not using select * in embedded sql programs?
No Answer is Posted For this Question
Be the First to Post Answer
What is precompiler in db2?
What are the isolation levels possible ?
Explain the contents that are a part of dclgen.
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
When is the results table for the query in a DECLARE CURSOR statement created?
Can I use LOCK TABLE on a view?
Which are the db2 tools to protect integrity of the database?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
How and when does the db2 enforces the unique key?
What is db2? Explain.
How to view db2 table structure?
What is the physical storage length of time data type?