Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Can anybody tell me in which scenario we have to use
SQLRPG .(Embeded SQL)....?

Answers were Sorted based on User's Feedback



Can anybody tell me in which scenario we have to use SQLRPG .(Embeded SQL)....?..

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

Can anybody tell me in which scenario we have to use SQLRPG .(Embeded SQL)....?..

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

Post New Answer

More RPG400 Interview Questions

difference betwen keywords and opcodes

3 Answers  


A particular job executing on the iS is not behaving as expected and is operating in an environment in which it can be debugged. What commands would you use to debug and observe the program?

2 Answers   IBM,


What is the name of default out queue when user logs inn to syatem with valid profile?

3 Answers   IBM,


What is the purpose of PUTOVR keyword?

2 Answers  


How Commitment and Roll back control is used in as400, explain with real time senario ???

2 Answers   Acolite, HSBC,


1.How you will find the program is batch or online in cl pgm? 2.How you will end the batch pgm when the job runs? write an logic? 3.In wich command the option *drop is used?

2 Answers   TCS,


3. Given the DOS Specification below and the following information: • Indicator 50 is off • No records have been written to the subfile What will be the result if the EXFMT operation code is performed on the record format CTLR? A R SUBFL A DESCRIP 101 6 1ODSPATR(UL) A DFT(’NOT FOUND’) A R CTLR SFLCTL(SUBFL) A N50 SFLDSP A SFLDSPCTL A SFLINZ A 67 SFIJEND A SFLSIZ(13) A SFLPAG(12) A ACCOUNTNO 100 S 10 a.) Only AccountNo will display b.) SUBFL will be initialized with 13 blank records c.) An I/O exception error will occur d.) The screen will display 12 records with ‘NOT FOUND’

4 Answers   IBM,


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

0 Answers   IBM,


What is significance of a file designated as a Primary file in Rpg400 program....also what's use of secoundry file

1 Answers  


Can anybody tell me that why we use option(*nodebugio)in H- Spec?

3 Answers  


Can someone tell me tell me what is meant by message wait...?

1 Answers  


What is the Record Address file. How can we use it in RPG program?

4 Answers  


Categories