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 5754what 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 8959how 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 5592if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
3 7364In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
CTS,
5 20165can any one give the list of some important sql abend codes which r frequently asked in interviews?
2 8646I 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.
3202what 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 12421OUTER 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 6757
What do you mean by storage group (stogroup)?
What happens in bind step in a db2 program?
When do you specify the isolation level?
What is drop table?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is plan in cobol db2?
What are the prerogatives?
What is a db2 schema?
Define predicate?
What is the maximum No of rows per page?
What is db2 command?
What is the purpose of rollback and commit?
What is the syntax for creating a table in the db2 database?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
How can you quickly find out the # of rows updated after an update statement?
