Interested to Buy Any Domain ? << Click Here >> for more details...
What is role in db2?
- 0 Answers
- 1083 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How to connect to db2 database from windows command line?
what is the role of the cursor in db2?
What is the reason behind not using select * in embedded sql programs?
What is the function of buffer manager?
What is nvl in db2?
Can SQL statements/queries be included in a copybook?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
What is meant by repeatable read?
what happend with out using Commit,when closing cursor and program?
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
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
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
COBOL 
