Why there is invention of RPG if we can do insert update delete in CL through SQL.Why the rise of RPG?
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 |
You have a *USE authority on a Library and *All authority on a file in that Library.Can you change the data in that file?
Are all these RPG/400 Interviewed Questions being asked recently? are current?
What is the difference between copybooks and subprocedures in as400?
Some times While checking MSGW for object / member / record locks ,I have seen it's locked by itself ...? How it happen and what action we need to perform if job is updating / writing a record....?
what is file identifier wher we can use
Why we cannot call a service program? If I add a PEP can i call the service program?
there is any limit to display the members in rpg400?
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...?
I have two sessions S1 & S2 under this 3 jobs(say j1,j2,j3 under session S1) And 2 jobs(Say j4, j5 Under session S2)is running. How many QTEMP & how many LDA will create for the same.
1..Write an sql query to find the employee name who is having 2 phone numebr? 2.Write an sql query to the the second highest salary of the employee?
during execution, an rpg/400 program automatically follows a sequence of operations for each record that is processed. The built-in program cycle includes the following logical steps.
How to print output from openquery in as400 ?