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

How do you find out whether a record is present in the physical file without reading the file? for Example Employee No: 100 in an Employee master.How do we find out whther 100 is present in Employee master without reading the file?

11 Answers   Bank Of America, CSC, IBM,


list down and describe the sub systems vailable

5 Answers   IBM,


How to handle duplicate error handling in RPG?

0 Answers  


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

0 Answers  


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

1 Answers   CSC,






what do you mean by an input subfile, what are the keywords required?

0 Answers   IBM,


what are the parameters of jobd?give in detail.&what are the parameters of subsystem...????

1 Answers   CTS,


How can a screen field that has changed since the last output operation be detected?

4 Answers   IBM,


We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?

0 Answers  


Need a sql query: retrive all duplicate records in table

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  


i want to perform uniqness on db file bt my db file nt hving key by useing rpgle.

3 Answers   HSBC,


Categories