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.

In Which Specs Arrays, Tables & Constants Are Defined?

0 Answers   IBM,

---

give three main purposes of file specification ?

1 Answers   IBM,

---

what is join logical file?

1 Answers   IBM,

---

what is the necessary keyword for non-join logical file?

1 Answers   IBM,

---

how many printer files can be defined in f specs ?

1 Answers   IBM,

---

what is sflinz and sflrna?

0 Answers   IBM,

---

what is the purpose of indicators in rpg?

1 Answers   IBM,

---

the maximum number of subfiles that can be active for a single file is ____ .

1 Answers   IBM,

---

Hi,Please give me the the answer for these quesitons? 1.what is IFS and ICF and RAPE amd DISKET fils? explain with example please? 2.What is the difference between POST AND SPACE OPCODES? 3.Can anybody tell me default printerfile command and object type?

0 Answers  

---

Why we sometimes use same file name in file and tofile in ovrdbf and sometimes different?

0 Answers  

---

what is the difference between *like and *namvar ?

1 Answers   IBM,

---

Space & Skip Are Which Level Keywords?

0 Answers   IBM,

---