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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain difference between call and link?

753


which is the cics control program that provides communication services between user written application programs and terminals?

746


Code the related portions of cics/cobol-i programs to gain addressability to twa area assigned to a particular task. Assme that the size of twa area is 300bytes. What are the advantages if cobol-ii is used in the place of cobol?

879


Name some translator and compile options and explain their meaning?

2592


Explain the purpose of the program list table?

757


What is meant by MDT? Furthermore, comment on FRSET and FSET ?

819


Define temporary storage?

778


what are the differences between temporary storage queue (tsq) and transient data quene (tdq)?

924


Kindly specify the pic clause for the any bll cell type of data fields?

912


Highlight the points of differences between XCTL and START?

828


What is the difference between SEND MAP DATAONLY and SEND MAP MAPONLY ?

942


what is the difference between a return with transid and xctl? For example program. A is issuing return with transid to program b. Program a. Is isssuing xctl to program b?

913


Explain how and where is the twa size set?

725


What are the types of the dfhmdf present in the cics?

756


What is journal recovery?

754