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


Please Help Members By Posting Answers For Below Questions

explain sflclr, sflend, sfldlt, and sflcsrrrn?

880


what is the procedure and explain about real time scenario.

1471


How can we know running job is batch or interactive?

645


is this a rpg channel?

669


what happens when sflsiz = sflpag? What are the advantages and disadvantages?

706






How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?

1553


How to call one program from another program in RPG? please help me with the code

1250


what was the robotech rpg?

678


What is the purpose of record level identifier?

722


What is difference between bind by copy and bind by reference?

1718


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?

1443


what is the rpg system?

660


How Chain operation copies the record's data to the input buffer for the program?

1072


what are the key words you must use when using a subfile?

684


What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?

2513