Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 2910 Views
- I also Faced
- E-Mail Answers
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
can anybody post me about file-aid and changemen tools pls and give me reference if any mainframe guys are there
What is the Purpose of POINTER Phrase in STRING command in COBOL?
how to convert the recors form vsam file to db2 table tru file aid
what is search and searchall?what is the diffrence between them?give an best example?
What is the difference between binary search and sequential search?
How do define dynamic array in cobol. how do you define single dimensional array and multidimensional array in your cobol?
Have you used the sort in your project?for this type of questions any working on real time project give the eg. with real time scenario.
)If there are 10 steps in GDG, if I want to refer the step2 after step5 . what should I do?
How to remove the spaces at the end of each record in the output file of variable length, via cobol program?
How do you define a variable of comp-1 and comp-2?
What are declaratives and what are their uses in cobol?
Define static linking and dynamic linking.
here is my requirement A1 is alphanumeric with value 'A1B2C3D4' as defined below 05 A1 PIC X(8) VALUE IS 'A1B2C3D4' but i need to have A2,A3 as ABCD & 1234 repectively...... A2 = ABCD A3 = 1234 Can you please explain me what are the different ways to do it?
1.give the details about WHEN OTHER. 2. how many form are available in evaluate.
How can we find that module can be called – whether DYNAMICALLY or STATICALLY?
