Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 5313 Views
- I also Faced
- E-Mail Answers
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
in conjunction with what other keyword must ovrdta and ovrata be used?
what are the different commands used in rlu ?
what are the two record formats a subfile contain ?
what is message file?
What is compiler directive in as400? Give example of compiler directive.?
What are the record format field mapping options in cpyf?
what are indicators?
give three main purposes of file specification ?
what are the uses of factor1, factor2 and result field for the rpg operation code parm?
how to toggle between single line and multi - line display of a particular record in a subfile?
what is the maximum number of subroutines allowed in rpg?
what opcode could be used to test an alphanumeric field for all numeric values?
what is logical file?
how does the runqry show the output?
at what level s,o are defined and what they will do?
