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
- 4748 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 Spool file, Why is it required?
How do I release jobs in queue and change a job destination to a different printer. I know wrkjobq but I have not worked with As/400 for a while,so_can someone help me?
how will you add a field to physical file already containing data?
what is the clp command to access a query/400?
how do you detect unused spool storage?
when you are defining a flat file in your program in f specs which format will you specify?
What is the function of SEU ?
whare we can use IN AND OUT AND UNLCK opcodes?please can any body tell me in real time senario with example
how you will find an error which is not in the first page of the subfile without using rolldown key?
define the purpose of the %sst function?
which cl command is used to trap error messages during program execution?
what is multijoin logical file? what are the keywords available in joinlogical file? what are the mandatary keywords for joinlogical file? explai the keywords?
RPG400 
