Interested to Buy Any Domain ? << Click Here >> for more details...
Can anybody tell me in which scenario we have to use
SQLRPG .(Embeded SQL)....?
- 2 Answers
- 9735 Views
- HSBC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / syam
1. You can select some data from a big Physical File and
Fetch that data
2. You can get Grand Total from a Physical File field
beginning of the RPG program
3. You can serch a value from a PF field
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / zhang
use SQLRPG is not a good idea, cause it will make your
system slowdown.
but sometimes we have to use it, such like we need provide
a compound query to custom, they have some searching
condition(they can be input together or only input one of
them), and we don't know which condition will entered, in
this scenario we can't make a logical file for this query,
so we have to use SQL sentence to searching it. we can
compose a complex "WHERE " clause.
| Is This Answer Correct ? | 2 Yes | 1 No |
Delete FileName at first statement in RPG.
In how many ways a session/device error occurs,,, and what is the remedy for it?
please help me answer to this question what is the difference between the binding and srvpgm in ilerpg?
What is the difference between RPG/400 and RPG4
How to create a key field for a logical file inside RPG?
steps involved in debugging and types of debugging modes?
Hi guys, anybody know How RPG/400 code can be converted to RPG IV code with a single command?
difference betwen keywords and opcodes
how do u track msg in cl pgm???
The PGMA calls PGMB.PGMB generates a report.The report should contain the called program name(PGMA).How do i get the called program name in PGMB to print it on the spool file?(calling program name should NOT be hard coded or passed as parameter to called program?
Can you copy the records created by the OPNQRYF to other files and how?
1.what are the ARITHMETIC EXPRESSIONS IN CL PGM? 2.How to PASSING PARAMETER TO CL PGM?
RPG400 
