Answer / swaminathan.r

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

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.

Answer / s.kumar

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

Answer / ismail

through o-spec

Answer / syam

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

Answer / syam

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

Answer / vivek

E-DEL/ADD Only in Report not file.

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

2 Answers  

If record-format name in an externally-described file has already been defined as a file-name.how to solve this?

2 Answers   CTS,

I have one cl program which calls two rpg programs named a & b. I am loading a run time array in Pgm A and the control comes back to cl pgm. i call pgmb and I want to read the runtime array in pgmb which was loaded in pgma. How it can be acheived. I should not use any intermediate file or dataarea to store the loaded values.

2 Answers  

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

1 Answers  

how to check on which PF , the LF is dependant ?

4 Answers   IBM,

IN RLU what are the record level keyword is used?

5 Answers   iGate, TCS,

One of the job in subsystem is in Running status,expected time to complete this job is 2 minutes. But from last 5 -10 minutes this job is still in running status....What are the possible reasons...and What are the actions i need to perform to check this...?

4 Answers  

how do u find whether a record is locked or not??

4 Answers   CTS,

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,

What are different ways to pass data between programs and which one is the efficient way?

5 Answers  

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,

what is the difference between the procedure and module in ILERPG?

4 Answers