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 we create binder member for updating service program and where we type this code on command line or in program ? strpgmexp pgmlvl(*current) export symbol (xyz0 endpgmexp. plz explain me this step by step .

2 Answers  

How to write record if no field or the field are different in physical file in rpgle ?

0 Answers  

what do you mean by SESSION/DEVOCE ERROR?

1 Answers   IBM,

What is the name of default out queue when user logs inn to syatem with valid profile?

3 Answers   IBM,

How do I read records from Subfile? what is the purpose of READC explain with example?

4 Answers   IBM,

thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400

0 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,

What are the types of identifiers?

0 Answers  

3 members in databasefile .how to read records from all the members??

6 Answers   CTS,

1. If my rpg program has a date field, What extra care I have to take while compiling that RPG program? 2. If the file is keyed and I have declared the file as well as Key list properly in my program. Still am getting an error message like "Chain/reade operation is not allowed" What may be the case?

6 Answers   Virtusa,

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

4 Answers  

1.Can any body share me about thease opcodes with example please.Im new for AS/400.Could u please tell me in real senario? 1.TESTN, 2.EVAL 3.EVALR, TIME, 4.MONITOR 5. ENDMON 6.ON-ERROR 7.COMMIT ROLLBACK?

1 Answers   CSC,