how to u check the query is executing or not ?where will u check for sqlcode ?
Answer Posted / lu
OH man...everytime, you execute a sql statement, u have to
check you SQLCODE = 0 or not = 0....this a basic using DB2,
Oracle....
| Is This Answer Correct ? | 6 Yes | 2 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.
is it compulsory commitment control in journal?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How is deadlock resolved?
Why select is not preferred in embedded sql programs?
What is db2 look?
What is db2 purescale?
Which isolation level provides maximum concurrency?
What type 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 ?...
What is db2 stogroup?
What r the comman abends in db2, jcl and cobol???????
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is explain in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?