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
How do u design a physical file, when you have 2 Unique fields like for eg in A student file student ID and student examination no both are unique
are there any useful c runtime apis that I can call from rpg iv?
how do I play {insert rpg system here}?
how do I declare a minor?
what is the difference between do while and do until?
1. What is bound-by-call and bound-by-reference? 2. Where and why is *Nomain used? 3. What are the difficulties faced by programmers when using service programs? 4. Explain the different ways of parsing and compiling XML in iSeries.
write an RPG program to calculate the marks of 5 students (A,B, C, D, E)in 3 different subjects (eng, math, sci) an display on the screen
How to call one program from another program in RPG? please help me with the code
What are the types of identifiers?
thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400
what is a rpg?
how can I tell when to replace the array?
what is an online rpg?
how does the rpg element work?
What is the difference between copybooks and subprocedures in as400?