Can anybody tell me in which scenario we have to use
SQLRPG .(Embeded SQL)....?
- 2 Answers
- 8533 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 |
Why did we give STRSRVJOB while debugging batch program
Please tell me how to read the records from a file with load an array of size with error conditions(The logic answer for this question is ARR is array of 99 elements Z-ADD 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN99 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO).So,Please give me the complete of this code.
i would like to know under what circumstance the object will get locked on AS400.
how we create binder member for updating service program and where we type this code on command line or in program ? strpgmexp pgmlvl(*current) export symbol (xyz0 endpgmexp. plz explain me this step by step .
1.CA(command Atention key)& CF(command Function key) difference with example?Please can any body tell me in real time exp? 2.Can any body tell me some mandatery function keys using while creating any screen with use of SDA-FUNCTION kEYS?
As400 Command to find the Name of the Program to which a Particular Module is Bound..? Ex: IC210AMR (*MODULE) is bound with Other Modules which Forms Program Object as IC210ABP(*PGM) . As400 Command to find the IC210ABP Using IC210AMR..? Thanks
what is importance of 'MAPFLD' IN OPNQRYF FILE ?
what do you mean by an input subfile, what are the keywords required?
parameters cannot be passed in which one???
what is the equivalent keyword for CHAIN opcode ??
suppose there are 100 records and i want to read records between 60-70 how we can read this 10 records in rpg
How to get only unique records from a file which contains duplicate data using CPYF command ? Example : FILEA has duplicate records and FILEB is a UNIQUE defined.... and I want to get the data from FILEA to FILEB by eliminating all the duplicate records...
RPG400 
