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
- 5292 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / prabhu
Yes, After adding the key field try CHGPF.
I believe adding key fields and CHGPF will not change the record identifier so here no need to recompile your programs.
| Is This Answer Correct ? | 1 Yes | 5 No |
What is RETURN CURSER LOCATION in subfile?
what are the different types of arrays?
Can we debug the MSGW JOBS?
how many triggers can be associated with a file?
what are the different types of variables available in cl?
Specify different indicators used in RPG?
what are the different types of arrays available in rpg ?
what is the syntax for plist?
how many files can be defined in f specs?
what are all the contents of subfile?
describe the difference between the dowxx and douxx operations?
what is the purpose of overrides?
RPG400 
