Why cursor is used in db2?
No Answer is Posted For this Question
Be the First to Post Answer
List out the buffer pools in db2
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
How can you count the number of rows from a table tab?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
how 2 resolve the -311 sqlcode
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures
What kind of database is db2?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
How can you find out the # of rows updated after an update statement?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
What is bufferpool in db2?
what is sql abend code -801,-802?