Suppose you are adding a new field in a map, and that field
should also be added as a new column in DB2 table. How do
you implement this? what is the impact analysis u will do?
Answers were Sorted based on User's Feedback
Answer / vinay
Will have to check all the programs using tht db2 table and
include this new field in select and insert sql statements
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / unknown
Using ALTER command we can update the table with the new
column name.
| Is This Answer Correct ? | 3 Yes | 2 No |
What is an AICA abend?
What is the difference between the INTO and the SET option in the EXEC CICS RECEIVE MAP command?
What is Journal Recovery and Dynamic Transaction Backout?
Is there any entry for TSQs in CICS tables?
what is the differences between getting the system time with eibtime and asktime command?
What is the pic clause for the hhmmss type of data fields?
Name some important fields in the EIB block ?
What are the CICS commands associated with temporary storage queue processing?
Explain the function of the terminal control table?
What is the difference between a return with transid and xctl?
Can you explain enq and deq used in cics?
TSQs can be written in the Main storage or Auxiliary storage (True or False).