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
- 2501 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 the default value(s) for an initialize? What keyword will allow for an override of the default?
What guidelines should be followed to write a structured cobol prgm?
How do you reference the fixed block file formats from cobol programs
What is an in line perform? When would you use it? Anything else you wish to say about it.
If you are current on the owner of a set, what is the difference between obtain next and obtain first?
)If there are 10 steps in GDG, if I want to refer the step2 after step5 . what should I do?
) how do u code after getting data?
how do you reference the variable block file formats from cobol programs
Hi pls anybody tell me about " ANALYSIS DOCUMENT PREPARATION AND ESTIMATION OF TASK " (in real time project)."I want to update a sequential file in my project" for that purpose i need both structures i mean analysis document and estimation of task.
I have one ps file in which there are 3 fileds emp_no,emp_name and leave_app.this ps file information give the detail of employee which is going to apply for leave.suppose emp_no=113430,emp_name=ajay,leave_app=1 that means he is going to apply for 1 day leave.and accordingling the table in db2 will be updated means if he has that no of leave in his account then he will get dat leave and updated acc. in table(leave_balance=previous leave present in table-leave_app).Now i want to check whther the updated result is correct or not by comparing the two ps file using IEBCOMPARE or icetool so what is going to be the two ps file and how its is going to be compare.
How to read the 2nd last record of a VSAM file? (The file size is huge and we don't know the key)
1.give the details about WHEN OTHER. 2. how many form are available in evaluate.
What is the usage of comp fields in cobol?
Which Search verb is equivalent to PERFORM…VARYING?
What type of SDLC u followed? Why?
