Why there is invention of RPG if we can do insert update delete in CL through SQL.Why the rise of RPG?
- 1 Answers
- 3567 Views
- Infogain, I also Faced
- E-Mail Answers
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 |
What is significance of a file designated as a Primary file in Rpg400 program....also what's use of secoundry file
Why we cannot call a service program? If I add a PEP can i call the service program?
1)how to do date validation in rpg? 2)how to delete dUPLICATE RECORDS?
How can we search particular records from the database file in RPG. For example, there are 100 records in the file.i need to retrieve all the records matching/equal to the particular 'NAME' field. How can we do the above using SEARCH criteria other than using the IF cond?
How to print output from openquery in as400 ?
how to find whether a date format is valid or not in RPG400 not in RPGILE.Can you please write the coding for this sir,i'm new to AS400.Please help.
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?
How to update only a field of a PF in an RPG program. I don't want to update the record, only one field.
i want code and what are used key words are ...like wrkmbrpdm screen (q) i have a file with 3 fields empno,empname,empaddr... here you give the empno it displays from that number to remaining empno's how? sub file screen: employee details pos to:empno then enter empno empname empaddr so file have 100 records from 1 to 100 so the above pos you give the 55 empno...it displays the from 55 to remaining... ...... please share this answel
Why we need to give File and To file Names While we are using OVRDBF. What is your understanding related to this?
1.How you will find the program is batch or online in cl pgm? 2.How you will end the batch pgm when the job runs? write an logic? 3.In wich command the option *drop is used?
1.find most occurrences of a character. for exm: input:aaabbbbdddddyyy output: d 5 times how can i get that?
RPG400 
