Hi Team,
Please tell me, If i don't declare the cursor in the program
and i have given open and fetch and close, then what error
will get.
Answer Posted / mr 10
Sql code : 501 i guess
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is the information associated with sysibm.syslinks table?
What is load replace in db2?
How to check last update on table in 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 ?...
What does runstats do in db2?
How is a typical db2 batch pgm executed?
What is the maximum length of sqlca?
What is a cursor in programming?
What is runstats db2?
What is explain plan in db2?
Before you give the explain statement, what are the prerogatives?
What is dbrm library?
How can you count the number of rows from a table tab?
Is db2 a mainframe?