if we want to add new column in the db2 table.How can add in the copybook?

Question Posted / mf.narasimhulu

2 Answers
7286 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

if we want to add new column in the db2 table.How can add in the copybook?..

Answer / rajasekhar reddy

we caanot insert a new column in between of the other
columns.But we can insert the column after last column of
the table.Then alter the table for DCLGEN

Is This Answer Correct ?

12 Yes

0 No

if we want to add new column in the db2 table.How can add in the copybook?..

Answer / tej

After altering the table by adding the new column regenerate
the DCLGEN of the table.

Question posted in wrong section.Should be in DB2.

Is This Answer Correct ?

9 Yes

0 No

Post New Answer

More CICS Interview Questions

I just want to ask why does the variable I passed in a dclgen of sql that has a data type of varchar which has a maximum length is 250 is truncated,, Here is the code.. DCLGEN of rsauud01 table 01 dataarea 43 data-area-len pic s9(4). 43 data-area-text pic x(250). MYVARIABLE. 01 DATAAREA1 pic x(250). move 250 to data-area-len of dataarea of rsauud01 MOVE DATA-AREA1 TO data-area-text of dataarea of rsauud01 --- but it is always trucated everytime I insert it in the table by the way it is a cobol-cics program

2 Answers

What is non-conventional programs?

0 Answers

Sync points cannot be requested by the application programs (True or False).

1 Answers IBM,

Can you explain common systems area?

0 Answers

What will happen if some program tries to process a queue on which an ENQ command has been issued by some other program?

0 Answers Accenture,

How to prevent user to access a screen directly from cics Native screen by using Trans Id?

2 Answers IBM,

What is DFHAID? what is its use?