Interested to Buy Any Domain ? << Click Here >> for more details...
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
2 5772what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
IBM,
4 8997how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example
CTS,
1 5607if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
3 7382In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
CTS,
5 20193can any one give the list of some important sql abend codes which r frequently asked in interviews?
2 8663I 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.
3218what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
2 12453OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
1 6766
How can we read records for specific member in CL? AND rpg?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
Define data page.
What is innodb buffer pool?
What are the full forms of spufi and dclgen and why are they used?
What is clone table?
List out the three types of page locks that can be held.
Are view updateable?
What is node in db2?
What is cobol db2?
What is dbrm? What it contains?
How does db2 sample database connect?
What r the comman abends in db2, jcl and cobol???????
What is role in db2?
Explain about open switch business continuity software?
