Answer / jyoti

STRSQL is interactive user session where one can use the
SQL commands to query over the file/files. STRSQL even can
perform the file updates and deletions.
This is quick interactive session and does not lock the
file while file updations are performed.

WRKQRY is the mainly used when one needs to save the query
definition for reuse. The queries created using WRKQRY can
even be used in CL programs by RUNQRY (query name).

Answer / sathya

Inserting a record into physical file is not possible using
wrkqry.
Unique and distinct records cannot be derived from wrkqry.

Where strsql can gives access to do both.

Answer / syam

In STRQRY you will get main 2 menus (Query for AS/400 and
Query Management). WRKQRY is one of the Option in STRQRY
(Query for AS/400). Only you want query some records from
database use WRKQRY.

1.what operation cannot be used in conjunction with file coded as divice type disk? 2.Difference between INCLUDE AND COPY?

1 Answers  

---

if dspatr(pc) and csrloc were specified for a format, which keyword would have priority?

1 Answers   IBM,

---

what is difference between accespath and datapath? what is the difference between accespath and open datapath?

2 Answers  

---

What is the purpose of the following? FORDHDR1 IF E K DISK ORDHDRF KRENAMEORDHDRF1

1 Answers  

---

how can I give more performance to some selected pages?

0 Answers   IBM,

---

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

0 Answers  

---

how many levels are there in a physical file?

1 Answers   IBM,

---

What are the types of data areas?

1 Answers  

---

what opcode could be used to test an alphanumeric field for all numeric values?

1 Answers   IBM,

---

what would be the effect on the field where reverse image, underline and highlight display attributes were active?

1 Answers   IBM,

---

what is the use of CPYFRMQRYF?

4 Answers  

---

WHAT IS FERERENTIAL INTRIGRITY ?

0 Answers  

---