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

Categories >> Software >> MainFrame >> IBM AS400 >> RPG400
Suggest New Category

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

Question Posted / syam

7 Answers
23652 Views
I also Faced
E-Mail Answers

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 identify the object has compiled with the debug view as *source without using STRDBG?

6 Answers

What is use of IMPORT and EXPORT in RPGLE ? What is activation Group ? What is Service Program ???? How to call another program in RPGLE ?

1 Answers

Please help me, I have created window subfile,I have created Footer with same lengh and postion of window SFL. When I call the pgm, first is shows only Footer and then it shows subfile records.This time Footer is not showsing ..plz hel me how can i do it...? Sameple DDS and RPG: A R WIN1 SFL A*%%TS SD 20090130 165346 MUNSHIJ REL-V4R2M0 5769- PW1 A FLD001 1Y 0B 4 3EDTCDE (Z) A ATFILE R O 4 7REFFLD (QWHFDBAS/ATFILE LIB/LIBF- A ILE) A R WINCTL SFLCTL (WIN1) A*%%TS SD 20090202 123459 MUNSHIJ REL-V4R2M0 5769- PW1 A ALTNAME ('y') A SFLSIZ (0004) A SFLPAG (0004) A WINDOW (FOOTER) A ROLLUP (27) A ROLLDOWN (28) A CF12 (12 'Cancel') A 50 SFLDSP A N51 SFLDSPCTL A 51 SFLCLR A 1 2'Select Option,Press enter' A 2 3'1= Select' A R FOOTER A* A WINDOW(8 31 9 43) A 8 4'F12 = Cancel' A R DUMMY ASSUME A 24 10' ' in RPG: Dow *IN12 = *Off Write Footer Fxfmt WInCTL

2 Answers

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

1 Answers

1.How to read a subfile in out put mode? 2.what are the keywords used to share same file? 3.using composite key which rpg code used?

3 Answers HSBC,

How to change the name of physical members Dynamically?

1 Answers

I know chain keyword retreive records randomly but how chain keyword exactly works internally????

4 Answers

i have a file with the values 10, 20, 30, 40, if am setll with the value 25 then readp, so what it will return?

6 Answers Mind Tree,

Can any body give the code for this quesition? Using the following details write C-Spec code to set Name to"AMMU LABS SYSTEM" D NAME1 S 10 INZ('AMMU') D NAME2 S 10 INZ('LABS') D NAME3 S 10 INZ('SYSTEM') D NAME S 20

5 Answers

can we use cl programming to update or delete physical files

12 Answers

Are all these RPG/400 Interviewed Questions being asked recently? are current?

1 Answers

what is mean by *MAP and *DROP?what commands use these two keywords?why are they used?

4 Answers

For more RPG400 Interview Questions Click Here