How many databases are there?
No Answer is Posted For this Question
Be the First to Post Answer
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
List out the three types of page locks that can be held.
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
What are leaf pages?
What is clone table?
what is the responsibility of the construction superintendent
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
How to retrieve rows from a db2 table in embedded sql?
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
Where would you find information about the type of database authority held by the user?
What is check constraint in db2?