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
- 9638 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 are the values of NUM1 and NUM2 after executing the following code? CLONO1NO2NO3 Factorl÷÷+OpcdeFactor2+÷+ResultLenDHHiLoEq C MOVE *LOVAL NUM1 50 C MOVE *J-fIVAL NtJM2 52
do you use message subfiles? What are the necessary keywords required coding a message subfile?
Suppose we add one field in physical file and this physical file is used by several programs.how do we know which program is using that file? What are the impact analysis.
How I can reread the physical file in CL program once the end of file reached in same CL program.
1.I have a Physical file with 100 records, No duplicates exists, all are Unique,But while i am running Runqry utility i am getting only 80 records..What could be the reason?
I need to generate outfile for object of all the user lib. in the sysmte using cmd DSPOBJD. But this cmd is correcpted in my server,Any body tell me is there any alternative...?
what do you mean by SESSION/DEVOCE ERROR?
Interviewer asked me write down DDS for load all subfile .can anybody write dds
What does Implicit Open means with respect to a file ? What about the Explicit Open?..what are the major differences between these two?
WHAT IS MEANT BY SIGNATURE VAILOTION ERROR
What is the syntax of passing parameters to a procedure by value?
In ProgramB there is a SBMJOB, which is a call to program C .There is also a CALL to program D from B. How would you check the program C has been executed in D?
RPG400 
