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
Set on command is used for closed all opened files , initialize var and release resource , return cmd is used for return to calling program but my req. Is dnt close opened files and resource must released while doing transactions , how can i do this...?
can you debug ile rpg program using isdb?
How would display prime numbers using CL program?
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
how does the rpg element work?
what is the procedure and explain about real time scenario.
how do I play {insert rpg system here}?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
How Chain operation copies the record's data to the input buffer for the program?
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?
How to declare the pull button in AS/400..
Interviewer asked me write down DDS for load all subfile .can anybody write dds
How to call one program from another program in RPG? please help me with the code
What is the purpose of record level identifier?
can I touch the array during treatments?