Lot of updates have been done on a table due to which
indexes have gone haywire. What do you do?
- 2 Answers
- 4425 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
What do you need to do before you do EXPLAIN ?
Can we use select * statement in cobol program without giving field names ???
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
Name some fields from SQLCA.
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
What is copy pending status in db2?
can you use symbolic parameters in JOB?
Mention the location where the output received from explain statement is stored.
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
What are the four lockable units for DB2?
What is the meaning concurrency in the db2 database?
How do you prepare a COBOL + DB2 program from coading till execution ?
COBOL 
