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
- 5317 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
If I want to execute Sftp commands(LS & GET) stored in Physical file from CL program automatically...Can u Plz tell me how can I do this?...How the script will look?? THANX FOR NY HELP...
what is a composite key?
what are the different types of arrays available in rpg ?
what does the opcode free do?
which indicator is used for read?
what is the disadvantage of using global variable?
What Is The Error If We Don't Get Login Screen?
what is a query can be run in which mode?
how can I automatically refresh a web page?
what is the syntax for plist?
when should I use method get, and when should I use method post in my cgis?
when would you prefer logical file than opnqryf?
what is the use of jdftval in join logical file?
give three main purposes of file specification ?
how do you pass parameters in cl?
