Interested to Buy Any Domain ? << Click Here >> for more details...
can we use cl programming to update or delete physical files
- 12 Answers
- 49405 Views
- I also Faced
- E-Mail Answers
Answer Posted / saravan
We can clear file using CLRPFM command.
If we want delete PF we can use DLTF command.
But before delete any PF first of all we need to
delete all the LFs related in that PF.(DSPDBR=Display Data
Base Relations,we can get all LFs relating to that PF)You
must give the correct Library name for all the commands
above.
For UPDATE, DELETE & INSERT, use RUNSQL command.
Ex: RUNSQL (UPDATE LIBR/FILE SET FLD = 'XXX'
WHERE CONDITION)
Note: RMVM is to delete/remove a member from a file. But
not to delet a file completely.
| Is This Answer Correct ? | 18 Yes | 2 No |
Post New Answer View All Answers
What is the purpose of record level identifier?
what is the rpg system?
How to handle duplicate error handling in RPG?
How can we override a file during runtime in rpg?
what was the robotech rpg?
What is the difference between copybooks and subprocedures in as400?
Assume 2 users are using the same file and first user updates some record in the file. Will the 2nd user will be able to see the updated record or not?
What is ment by record level identifier?
What is a record lock error?
Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
what are the key words you must use when using a subfile?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
what do you mean by an input subfile, what are the keywords required?
what is kids-rpg?
