Interested to Buy Any Domain ? << Click Here >> for more details...
What does DSNDB07 database do?
- 2 Answers
- 12078 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
DSNDB07 database is a work file database and is used by SQL
statements that require working storage like sorts.
| Is This Answer Correct ? | 25 Yes | 1 No |
Answer / kums
DSNDB07 may be used to perform sorting(order by clause).
| Is This Answer Correct ? | 13 Yes | 2 No |
i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 Answers Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
How do you simulate the explain of an embedded sql statement in spufi/qmf?
why we create view.
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
What is ibm db2 used for?
What is a recovery log?
What is the function of the Data Manager?
What do you mean by commit and rollback?
How to resolve -502 sql code in DB2?
What is dbrm? What it contains? When it will be created?
what are extents?
COBOL 
