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
- 2917 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
What is amode(31)
In COBOL programming, what is PERFORM? What is VARYING?
EXPLAIN MAIN FRAME TESTING PROCESS...HOW TO FIX THE MAINFRAME BUGS?
What is rmode(any) ?
What is the difference between binary search and sequential search?
What is the difference between PIC 9.99 and 9v99 in COBOL?
I have File 1 occurs 5 times with Employee-ID,Employee-Name,Employee-Dept (EEE and MECH). I have File 2 occurs 10 times with Employee-ID,Employee-Name,Employee-Dept (EEE,CIVIL,CHEMICAL and MECH). In FIle 1 and FIle 2 , for matching Employee-DEPT (Only MECH) , we need to move entire records from file1 to file 2. We should not use 2D array. Your help is needed here.
What is the difference between comp and comp-3?
What is the utilization of copybook in cobol?
What is a SSRANGE and NOSSRANGE?
How to read the 2nd last record of a VSAM file? (The file size is huge and we don't know the key)
If you are current on the owner of a set, what is the difference between obtain next and obtain first?
How many sections are there in data division in COBOL?
What is amode(24), amode(31), rmode(24) and rmode(any) (applicable to only mvsesa enterprise server) ?
How to fetch 1000 error records from VSAM file(Eg: 1000000 records present) while getting SOC7 abend ?
