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

What will happen if we r using seton lr after return or vice versa.

5 Answers  


give an eg of ACQ-(ACQUIRE),BIT OFF,BIT ON,DEALLOC,DUMP,FEOD,FORCE,MHHZO,MHLZO,MHLLZO,MLHZO,REL,RESET,TESTZ,TESTB,TESTN----GIVE SMALL EXAMPLE TO THE OPCODES...TO UNDERSTAND FUNCTIONING...........

0 Answers   CTS,


Anyone help me for the below question:- If problem/error occur in *PSSR subroutine,how should I handel it in RPG program.

1 Answers  


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

4 Answers  


Errors in Sql query will be in which state?

1 Answers  






we are sending data of physical file to screen design and it is showing no record why?

1 Answers   NTT Data,


can we perform CHAIN operation on Subfile record format....?

4 Answers  


Maximum how many files declare in rpgle

3 Answers   TCS,


what is the difference between SETON RT & RETURN?

5 Answers  


Need a sql query: retrieve all duplicate records in table?

1 Answers  


1.CA(command Atention key)& CF(command Function key) difference with example?Please can any body tell me in real time exp? 2.Can any body tell me some mandatery function keys using while creating any screen with use of SDA-FUNCTION kEYS?

5 Answers   HCL,


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...?

0 Answers  


Categories