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.

Suppose you have 3 members in a database file. How to read records from all the members Without using CL (OVRDBF) i.e. it should be handled exclusively in an RPG program?

6 Answers   IBM,

---

what is the function of cpysplf command?

1 Answers   IBM,

---

what does vldcmdkey means?

0 Answers   IBM,

---

records can be read/update/deleted with which file?

0 Answers   IBM,

---

which are control break logic indicators?

0 Answers   IBM,

---

how can database records be read without lock ?

1 Answers   IBM,

---

What is Sub-System?

1 Answers  

---

Space & Skip Are Which Level Keywords?

0 Answers   IBM,

---

what is the purpose of the indara keyword?

1 Answers   IBM,

---

how can I control the way a remote browser uses its cache?

0 Answers   IBM,

---

how many printer files can be defined in f specs ?

1 Answers   IBM,

---

how do you turn off indicators 50 through 59 in only one operation

1 Answers  

---