Answer Posted / kaushik datta

1.Code the program with all DB2 statements inside EXEC
SQL/END-EXEC statements
2.Compile the program with suitable compile JCL/ENDEVOR.In
endevor give proper processor group
3.Package Bind the program. M.5.1.5.4
4.Create proper JCL to run that.You can you IKJEFT01

5. Run the JCL.Your program loadb should be in the library
mentioned in the STEPLIB of run JCL

How to compare data between two tables in db2?

1088

---

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1186

---

How to take backup of table in db2?

1079

---

What is innodb buffer pool?

1061

---

What's The Error Code For Unique Index Voilation?

1240

---

what are bind concepts in db2 cobol?

1096

---

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1074

---

How to resolve deadlock issue

20137

---

How is deadlock resolved?

1149

---

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.

1737

---

Why do chiropractors use drop table?

1110

---

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 ?...

4317

---

What is null in db2?

1027

---

What is check constraint in db2?

1091

---

What language is db2 written in?

1049

---