Why there is invention of RPG if we can do insert update delete in CL through SQL.Why the rise of RPG?



Why there is invention of RPG if we can do insert update delete in CL through SQL.Why the rise of RP..

Answer / nkumar

Well CL is not meant for the database programing. In previous version of AS400 update,insert was not possible through CL. From V5R4 we have the API available or we can use the QMQRY objects and run them through CL. RPG provides the easiest way of playing with the data base with so many OPcodes available.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More RPG400 Interview Questions

wat is the difference between dataarea and data queue?

5 Answers   Airtel, Four soft, Shahi Exports,


What is the purpose of Panel Groups?

4 Answers  


Hi friends, I am using a load all subfile , and currently i am in in the third page of the subfile , from third page i have selected a record and called some other program .on returning, subfile is being loaded from the frist page. so can any one kindly suggest me in retaining my third page after returning. i.e loading from third page.

7 Answers  


How to declare the dynamic(run time) array in rpgle? can you please give example

2 Answers   Polaris,


when will come session device error?

4 Answers   TCS,






2. Which of the following statement(s) explains the difference(s) between the /INCLUDE and ICOPY directives? a.) No difference, they function the same b.) ACOPY cannot be used as a conditional directive c.) IINCLUDE files cannot contain embedded SQL d.) Nesting /TNCLUDE directives is not allowed

2 Answers   IBM,


we are sending data of physical file to screen design and it is showing no record why?

1 Answers   NTT Data,


what is importance of 'MAPFLD' IN OPNQRYF FILE ?

2 Answers  


What is significance of a file designated as a Primary file in Rpg400 program....also what's use of secoundry file

1 Answers  


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 will happen if we r using seton lr after return or vice versa.

5 Answers  


Hi, I am getting the error in RPG (All Record Formats for externally-described file ABCD ignored or dropped due to error; file ignored.) Please suggest any

2 Answers   Satyam,


Categories