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 5526what 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 8730how 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 5500if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
3 7196In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
CTS,
5 19941can any one give the list of some important sql abend codes which r frequently asked in interviews?
2 8525I 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.
3147what 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 12287OUTER 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 6667
What is the use of db2?
How to create db2 table in mainframe?
What is syscat in db2?
What is the meaning concurrency in the db2 database?
what is the responsibility of the construction superintendent
What is dbrm in db2 database?
What is check constraint in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How to execute stored procedure in db2 command editor?
What is query_cache_limit?
Explain correlated sub-queries.
What is db2 purescale?
What is a db2 schema?
Explain the function of data manager.
What is check constraint. Explain with example.
