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.
Answer Posted / 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 View All Answers
What the difference is between continue and next sentence?
Program A (Normal COBBAT) calling a B Program (DB2COBOL, COBBATDB which is using a VSAM file. its a dynamic call. How we will handle VSAM file decleration in our from JCL from where we are running A PGM. And should we have PLAN for A pGM also. if possible can some one post a sample JCL. Thanks for help in advance.
If you are current on the owner of a set, what is the difference between an obtain next and obtain first? Actually in which topic will we use dis???Plz explain it clearly
How do define dynamic array in cobol.
write a cobol logic. i have file that has 10 records .1 record go to first output file and second record goes to 2 output and etc
)If there are 10 steps in GDG, if I want to refer the step2 after step5 . what should I do?
I have to write to a outfile where the number of records in that file should be the header of that file using IMS.. can anyone help me in this issue
What is the difference between comp and comp-3 usage?
What is redefines clause in COBOL?
How can we find that module can be called – whether DYNAMICALLY or STATICALLY?
Name the sections present in data division.
Is it possible that the redefines clause has different picture clauses compared to the one it redefined?
how do you reference the printer file formats from cobol programs
What are 77 levels used for?
What is an in line perform? When would you use it? Anything else you wish to say about it.