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
which are the string manipulation opcodes?
how many files, printer files you can describe in a rpg?
what is the length of a variable in rpg?
what is procedure prototype and procedure interface.
which indicator is used for read?
what opcode will be used to test the zone of a character field?
how can we run a batch job?
define the purpose/use for sflrna?
list some of the commonly used commands for debugging?
Hi,Please give me the the answer for these quesitons? 1.what is IFS and ICF and RAPE amd DISKET fils? explain with example please? 2.What is the difference between POST AND SPACE OPCODES? 3.Can anybody tell me default printerfile command and object type?
how many printer files maximum can be used in single rpg program?
records can be read/update/deleted with which file?
What is the maximum number of subfiles that can be specified in a display file?
what does defn do?
what are the different types of arrays available in rpg ?