What is the purpose of rollback and commit?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
What is the reason behind not using select * in embedded sql programs?
What will the COMMIT accomplish?
What is cascading rollback?
How can the duplicate values be eliminated from db2 select?
Compare a subselect to a join?
What is the usage of open cursor command?
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 ?...
What do you do to keep the cursor from closing after a commit?
what are stage one indexable predicates?
Can SQL statements/queries be included in a copybook?
What are common abends