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

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  


How Chain operation copies the record's data to the input buffer for the program?

0 Answers   IBM,


what is the difference between the cpyf command crtdupobj command?

9 Answers   IBM,


How can a screen field that has changed since the last output operation be detected?

4 Answers   IBM,


How can we make use of SETLL operation in CL?

11 Answers  






1.what are the ARITHMETIC EXPRESSIONS IN CL PGM? 2.How to PASSING PARAMETER TO CL PGM?

1 Answers   NetCracker,


i 'm new to as/400.in an interview i was asked this question.give a practical example for passing information or data through local data area. I know only that data area is an object used to store tiny bits of data or it can store one value at a time and it is used to store frequently changing values or datas.thats all i know about data area can any one tell me how local data area and user defined data area are used to pass data between jobs with a example or coding.thanks in advance.

2 Answers   CTS,


what are the key words you must use when using a subfile?

0 Answers   IBM,


What is the syntax of passing parameters to a procedure by value?

1 Answers  


how to convert date format from one format to another i think in CL/400 its CVTDAT,Please tell in RPG/400 sir not in RPGILE

3 Answers   iGate,


What is ment by record level identifier?

0 Answers  


I know whole thing ab't Arrays related to declaration..can anyone tell me what exactly use of array or anyone faced a situation where he found use of array must....

1 Answers  


Categories