Answer Posted / s. kumar

Answer1:
More than one Database file can be joined by different ways
like..
1)Inner join or Join Logical file
2)Left outer Loin
3)Right outer Join
4)Self join
These all are join logical file.
Non Join Logical file means Simple Logical file i.e Only
one PF file.
Answer2:
PFILE is the necessary keyword for non
join logical file.

R Rec-For PFILE(PF name)

What are the different opcodes used for file operation on a subfile in a rpg pgm?

1121

---

Can you summarize the steps I have to go through in writing my first cgi?

639

---

how many levels are there in a physical file?

1019

---

why is as/400 called object oriented machine?

963

---

define the purpose of the *cat function?

1012

---

---

which are control break logic indicators?

646

---

what is the disadvantage of using global variable?

702

---

how does the runqry show the output?

898

---

Service Program : S1 Modules in S1 : M1 M1 having two procedures : ADD, SUB Current Binder Language STRPGMEXP PGMLVL(*CURRENT) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") ENDPGMEXP Doubt: I need to add one new Module to the Service Program M2 having one procedure ‘MULT’ How to add this new module to the service program S1 ? If I need to recreate the service program again, Do I need to mention the Module M1 again while recreating along with new Module M2? There is no Binding Directory. Binder language structure will be like this STRPGMEXP PGMLVL(*CURRENT) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") EXPORT SYMBOL("MULT") ENDPGMEXP STRPGMEXP PGMLVL(*PREVIOUS) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") ENDPGMEXP

1939

---

how can you detect and handle a record lock situation?

1235

---

what is the use of data structures?

655

---

can you have multiple key lists for a single file ?

1016

---

what are the different types of arrays available in rpg ?

976

---

difference between view and index ?

730

---

how can you check for a records existence without causing and i/o (chain/read)?

1310

---