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
- 4243 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 to reverse a string using RPG?
I/o error detected,Record Out of sequence,Permanent I/o error occured....I mean give one eg for these errors...i understand only,update/delete operation without prior read oprn..give details of remaining
how can we view the entire objects and its types in a pgm?
i have recently moved to hyd. i would like to know which is the best institue to learn AS400. are there any in ameerpet? thanks.
What is LDA?
Difference Between Interactive & Batch Job?
how to handle job errors in as400 what is the command and where can we find out whether the job has any errors
Q1. How to use signature in service program and ILE.? Q2.what is use of signature and binder language and what is the relation between them?
how can a message from a message file appear as a constant on the screen?
CAN WE INSERT FIELD IN PHYSICAL FILE BY USING OPNQRYF?
what is sflinz and sflrna?
define the purpose of the *cat function?
RPG400 
