Is it possible to add an keyfield or field to an Physical file without changing its file identifier.
Example : - Say I have an existing physical file which is being used in 5 programs. Now I want to add an additional Keyfield or an field to it and I don't want to recompile the programs.
Answer Posted / vivek dwivedi
You can add field in file using sql. Alter table as below..
ALTER TABLE File_Name ADD COLUMN Field_Name SMALLINT NOT NULL DEFAULT 0
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how may a cgi control duplicate inputs?
define subsystem?
how you will find an error which is not in the first page of the subfile without using rolldown key?
what are different types of substems?
what is the purpose of data structure?
What is program status data structure(psds) in as400?
what is *inzsr used for?
how can I give more performance to some selected pages?
what is a physical file?
difference between view and index ?
define what a data area is along with a brief example of what it may be used for?
how do you specify the number of records to roll in a subfile ?
which are control break logic indicators?
how does the runqry show the output?
what opcode could be used to test an alphanumeric field for all numeric values?