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 is s000 u4087 error? please give the all error codes in cobol,jcl.
Explain how to differentiate call by context by comparing it to other calls?
Explain how will you differentiate between an internal and an external sort, the pros and cons, internal sort syntax etc
how do you reference the ksds vsam file formats from cobol programs
What are the rules of the move verb?
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...)
if we have " ibm mainframe ",in that how to remove first and last leading space eg:"ibm mainframe" like that the answer we need
How to change size of Initial number of records to *NOMAX for ALL PF files from perticular library, how can I do that
What is cobol?
What is the default value(s) for an initialize and what keyword allows for an override of the default?
What is amode(24), amode(31), rmode(24) and rmode(any) (applicable to only mvsesa enterprise server) ?
i need a small 3d program using inline and outline.
Why do we code s9 (4) comp. Inspite of knowing comp-3 will occupy less space?
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.
input= ,,,, mainframe training ,,, hyderabad .... location.... output1=$ mainframe training in hyderabad location$ output2=**** mainframe training in hyderabad location ****. In this pgn when we give input considering the spaces the output is displayed in this format.Like in the place of ,,,, $ should be displayed likewise.So please helpmeout.