Can anybody tell me in which scenario we have to use
SQLRPG .(Embeded SQL)....?
Answer Posted / 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 |
Post New Answer View All Answers
explain sflclr, sflend, sfldlt, and sflcsrrrn?
what is the procedure and explain about real time scenario.
How can we know running job is batch or interactive?
is this a rpg channel?
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
How to call one program from another program in RPG? please help me with the code
what was the robotech rpg?
What is the purpose of record level identifier?
What is difference between bind by copy and bind by reference?
Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?
what is the rpg system?
How Chain operation copies the record's data to the input buffer for the program?
what are the key words you must use when using a subfile?
What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?