Can anybody tell me in which scenario we have to use
SQLRPG .(Embeded SQL)....?
- 2 Answers
- 8484 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 |
what is *place and *auto keyword in prtf ?plz explain
Can anybody tell me the setps to create .csv file in IFS folder on AS/400. I also need to know how I can send this .csv file to PC in xls sheet.....?
How do you call procedures in ILE?
How to read data from Nth member of a physical file containing some X number of members in it? "Provided member names are unknown"
what are the array operations?
how do I do concatenation in rpg iv, like I do in cl?
How can we access Interactive job LDA in Batch Job?. and How we can access a file in interactive QTEMP lib in Batch job?.
how to display all the members records in a physical file without using ovrdbf?
What are the types of identifiers?
If record-format name in an externally-described file has already been defined as a file-name.how to solve this?
1. I have2 records in a PF. READ PF DO DSPLY EMPNO RETRN DSPLY EMPNO ENDDO What was the output 2. SETON LR vs RETURN 3. Primary File 4. How to delete a deleted spaces 5. How to read a PF in reverse order in CL 6. I have a object in Lib A, B and C. But it shows in D Lib..Why? 7.
A particular job executing on the iS is not behaving as expected and is operating in an environment in which it can be debugged. What commands would you use to debug and observe the program?
RPG400 
