How can you delete records form a file in rpg without
using "Delete" OPCODE?

Answers were Sorted based on User's Feedback



How can you delete records form a file in rpg without using "Delete" OPCODE?..

Answer / swaminathan.r

By using EXCPT opcode we can delete the records in Rpg..
That is on O spec we have E-DEL/ADD

Is This Answer Correct ?    27 Yes 1 No

How can you delete records form a file in rpg without using "Delete" OPCODE?..

Answer / surendra y mudliar

If you want to delete all the records then you can do by
using API QCMDEXC and pass the parameter as CLRPFM.

Is This Answer Correct ?    5 Yes 2 No

How can you delete records form a file in rpg without using "Delete" OPCODE?..

Answer / s.kumar

Hi Syam,
According to me, if you don't want Delete opcode
so use Embedded Sql in Rpg....Right?

Is This Answer Correct ?    1 Yes 0 No

How can you delete records form a file in rpg without using "Delete" OPCODE?..

Answer / ismail

through o-spec

Is This Answer Correct ?    1 Yes 0 No

How can you delete records form a file in rpg without using "Delete" OPCODE?..

Answer / syam

Surendra....Not all records or Not cl command!

Is This Answer Correct ?    0 Yes 0 No

How can you delete records form a file in rpg without using "Delete" OPCODE?..

Answer / syam

Hi Kumar...Not SQL.....directly from RPG program

Is This Answer Correct ?    0 Yes 0 No

How can you delete records form a file in rpg without using "Delete" OPCODE?..

Answer / vivek

E-DEL/ADD Only in Report not file.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More RPG400 Interview Questions

in which journalling which attributes are necessary??/

1 Answers   CTS,


HI, 1: WHAT IS THE FUNCTION OF %KDS?WITH PROGRAMMING CODES EXAMPLE 2: WHAT IS THE FUNCTION OF Z-ADD AND Z-SUB ? WITH PROGRAMMING CODES EXAMPLE

1 Answers   IBM,


Can anybody tell me, does CL/400 handle LEVEL check while running the CL program....? plz share your experience...

4 Answers  


can we use cl programming to update or delete physical files

12 Answers  


two attributes which govern the excecution of a job>>>>??

2 Answers   CTS,






Hi,Please give me complete code with this logic. The question is how to read the records from a file with load an array of size with error condition? (The logic is Z-Add 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN9 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO)please give me complete code with explanation?

1 Answers  


what r drawbacks of OPM? Why do we go for ILE RPG?

1 Answers  


How to find d key field of a pf that doesn’t have source physical file?

2 Answers  


What will be your approach in going either for OPNQRYF or Logical files. Which one to go for?

2 Answers  


Q:Hi all,i want accurate answer with code using in built functions.please sent me code as soon as posible. I have program nmed PGM1 which '' RETRIEVE Current production date''should correctly default the production date for the user who is issuing raw materials to the manufacturing.The production date can be different from the celendra date. However, the program does not make the correct adjustment for all manufacturing plants. there is a parameter which determines the production start time e.g. 07:00 if the system time precedes this,the program subtracts one from the celendra day.This work fine when the celendar day starts after production day as it does in England,the system should be adding one to the celendar day during the overlap. unfortunately the program was desined to assumed the celendar day always starts before the production day. Change required in the program: Change the PROGRAM PGM1 to use the new parrameter to decide whether to add or subtract 1 from the celendar day when determining the production date.

0 Answers   TCS,


If I have a file with 5 record and that file has 2 Key field and I want to read the unique record of the file then how can we achieve it?

1 Answers  


what is ment by "MDT"

2 Answers   TCS,


Categories