Sign Up Login


  1. Categories >> Software >> MainFrame >> IBM AS400 >> RPG400
  2. Suggest New Category

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

Question Posted / syam

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

How to print Superscript / Subscript from RPG400

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,

3. Given the DOS Specification below and the following information: • Indicator 50 is off • No records have been written to the subfile What will be the result if the EXFMT operation code is performed on the record format CTLR? A R SUBFL A DESCRIP 101 6 1ODSPATR(UL) A DFT(’NOT FOUND’) A R CTLR SFLCTL(SUBFL) A N50 SFLDSP A SFLDSPCTL A SFLINZ A 67 SFIJEND A SFLSIZ(13) A SFLPAG(12) A ACCOUNTNO 100 S 10 a.) Only AccountNo will display b.) SUBFL will be initialized with 13 blank records c.) An I/O exception error will occur d.) The screen will display 12 records with ‘NOT FOUND’

4 Answers   IBM,

Delete FileName at first statement in RPG.

1 Answers  

Hello, I want to extend a length of field in my Display file(Subfile). Please suggest the possible steps. Thanks

3 Answers  

can anybody help me to solve this problem. the program that i m checking display error message saying "Record format for file AJDSPFFD does not match model file and decimal error. how to solve this problem. The AJDSPFFD is snapshot the AJTLOG that is the audit trail list.

0 Answers  

What is the RPG cycle?

3 Answers   CSC,

what is ment by "MDT"

2 Answers   TCS,

What are the commands that can be executed in CLP but not in RPG? Why?

1 Answers   CSC,

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  

1)how to do date validation in rpg? 2)how to delete dUPLICATE RECORDS?

12 Answers   IBM, Opus,

what is batch debug in as400?

3 Answers  

For more RPG400 Interview Questions Click Here
Categories