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
- 5325 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 an authorization list?
Hi friends.. i want to be a IBM MainFrame Professional.. can any body tell me what is requirement for that... i m just BA, MA, and have simple diploma in Computers. what is pre-requisite.
Define a Job Queue?
How to retrieve data from data area?
Describe about Query/400?
is it possible, in the same cgi, to run more than one gethtml or gethtmlifs?
which are the member types which seu supports?
CAN WE INSERT FIELD IN PHYSICAL FILE BY USING OPNQRYF?
How many record formats can you have in a Physical file and in a Logical file ?
What is the purpose of OPNQRYF (Open Query File)?
In which specification Data Structures can be defined?
What is the use of Header Specification in RPG/400?
RPG400 
