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

why we are using picture clause in the cobol programs?

2 Answers  


what is difference between cobol and cobol/400

1 Answers   HCL,


Can the OCCURS clause be at the 01 level?

2 Answers  


What is the use of intialize verb?

0 Answers  


01 ws-p pic 9(2). 01 ws-q pic 9(2) value 01. 01 ws-r pic 9(2) value 99. p.d. compute p = q + r what will be result of p ans(00) but my question is that how i got 10 on the place of 00. (truncation will ocuure on right side not left). please tell me ?

6 Answers   L&T,






how can we apply for HSBC exam(Mainframe) in India??? i went to their site and was told to submit my CV ,. etc..( totally confusing...)

0 Answers   HSBC, Quest,


i want all ERRORS codes in COBOL ,JCL,VSAM ,DB2,CICS

4 Answers   Infosys,


A table has two indexes defined. Which one will be used by the SEARCH?

0 Answers  


How to declare if emp-name = AAAAA""BBB in working-storage section. After display emp-name should print like AAAAA""BB

6 Answers   Polaris,


What are the cobol coding sheets?

0 Answers  


which one is better among static call and dynamic call?

3 Answers  


can anybody post me about file-aid and changemen tools pls and give me reference if any mainframe guys are there

0 Answers  


Categories