Answer Posted / budgobbel

In CICS programs, data is passed in the Communications Area (CA) via the Linkage Section.

If your cursor is predicated (WHERE clause) on a field in the CA, you could code your cursor early in the Procedure Division prior to any open cursor logic. This will avoid using additional variables, and MOVE statements.

If you keep your cursor in the Working Storage area, you cannot use fields in the Linkage section as host variables, because the DB2 pre-compiler will see the cursor first, and NOT have a resolution for the host variable (it hasn't seen the Linkage Section, yet).

It mostly is up to you, unless your shop is a stickler on variables and locations, etc.

Also, over the years I have seen shops become more code-it-and-load-it in philosophy. Very sad.

What is the role of union all and union

1070

---

What is the role of data manager in the db2 database?

1053

---

What is host variable in db2 cobol?

1032

---

can all users have the privilage to use the sql statement select * (dml)?

1106

---

What does sqlcabc has?

996

---

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.

1660

---

What is the difference between nvl and coalesce?

1009

---

Explain in detail about buffer manager and its functionalities?

996

---

How and when does the db2 enforces the unique key?

1032

---

Can one database have multiple instances?

1007

---

What is package in db2 mainframe?

923

---

What is host variable?

1016

---

What types of tables are there in the db2 database?

1008

---

What are types of indexes?

1001

---

What is db2 and what is the use of db2 optimizer?

996

---