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
- 5273 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 |
How are the objects stored on AS/400?
using dfu, user will be able to ___________ from physical file?
What is the use of OVRPRTF ?
what is rpg fixed logic cycle?
How to change file attributes such as size, file wait time, record wait time etc., permanently?
which are the figurative constants used in rpg?
What is the use of OVRDBF ?
what are the various types of device files?
what is overlay?
What is Group Job?
What is the use purpose of CRTCMD?
Can be OVRDBF command mentioned after OPNQRYF command in CL?
RPG400 
