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
- 5293 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
what is the maximum number of records you can specify in a display file?
What is the difference between non-join logical files and join logical files?
WHAT IS AS/400 SYNORIO?
what is the function of rlu ?
what are indicators?
what is the length of a variable in rpg?
what are various techniques to pass parameters from one program to another?
how do you read changed records backward in subfile?
What Does 'sr' In Columns 7-8 Of C Specs Mean?
how can I predict the performance of my cgis?
I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.
how do handle file exception/error?
what if my system I runs with system value qccsid 65535?
when do you use f-spec. Continuation line ?
Apart from opening of a file do we have any other use of USROPN?
