can we use cl programming to update or delete physical files
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 was the robotech rpg?
What is ment by record level identifier?
how do you use commitment control in rpg?
what is file information data structure?
how do I play {insert rpg system here}?
How Chain operation copies the record's data to the input buffer for the program?
if there is a module object , how to find the program object for this module object.Assume the module object name and program object name is not same.
How would display prime numbers using CL program?
What is the difference between iter and do?
Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg
do you use message subfiles? What are the necessary keywords required coding a message subfile?
When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?
What are the types of identifiers?
How to declare the pull button in AS/400..
If my rpg program has a date field, what extra care I have to take while compiling that rpg program? If the file is keyed and I have declared the file as well as key list properly in my program. Still am getting an error message like "chain/reade operation is not allowed" what may be the case?