Hi Guys, I have faced one interview question if I have requirement to add 5 new columns to existing table what are prerequisite do i need to take.



Hi Guys, I have faced one interview question if I have requirement to add 5 new columns to existing..

Answer / manhem

Unload the data, Drop the table, recreate the table by adding 5 new columns.
or
Alter table will work, but it will add new columns at the last.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More COBOL Interview Questions

01 MOVE 10 TO N 05 PERFOM PARA1 TIMES STOP RUN WAT WILL HAPPEN?? WILL IT RUN INFINITELY OR AN ERROR WIL BE THER BECAUSE NO OF TIMES IS NOT GIVEN??

1 Answers  


When we code these comp,comp1,comp-2,comp-3 and comp4 values. I know the differnece.I mean when we will prefer if it is new program.Explain in detail with memory examples. Thanks in advance.

1 Answers   CTS,


i WANT ALL ERROR codes IN CICS and DB2

2 Answers  


which generation language is cobol

4 Answers   Kanbay,


I want ALL jcl ERROR cods

1 Answers  






What are VS COBOL 11 special features?

1 Answers  


COMP?

2 Answers  


what will happen if i give program name and member name as different? program runs successful or w'll abend?

5 Answers   CTS,


what is sync clause?

2 Answers   DELL,


What is CALL statement in COBOL?

4 Answers  


Can we call a CICS program from a batch program or viceversa?If so, how?

3 Answers  


What is the LINKAGE SECTION used for?

4 Answers  


Categories