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
How can we override a file during runtime in rpg?
can you debug ile rpg program using isdb?
what is program status data structure?
Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg
We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?
How would display prime numbers using CL program?
What is ment by record level identifier?
How many program bind in one module....
what is the use of sflnxtchg?
How to call one program from another program in RPG? please help me with the code
what is the necessary keyword needed to scroll subfile records?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
Set on command is used for closed all opened files , initialize var and release resource , return cmd is used for return to calling program but my req. Is dnt close opened files and resource must released while doing transactions , how can i do this...?
what is data area and how it is used in rpg program ?
How to write record if no field or the field are different in physical file in rpgle ?