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.

how do you know that records are locked?

1 Answers   IBM,

---

is it possible to create a join logical file using two join logical files ? give exact reason for your answer

4 Answers   Ocwen,

---

what is scan and xlate?

1 Answers   IBM,

---

What is Group Job?

1 Answers  

---

How to debug a batch job when it is in messagewait(mswg) status. I know the steps for batch ebugging, but im confusing with when we submit any job for batch debug we put in held state. So here also do same thing or any other way?

0 Answers  

---

why is the declare cursor statement is used for?

0 Answers   IBM,

---

What is %CHECK?

0 Answers  

---

what is the syntax for plist?

0 Answers   IBM,

---

What is field reference file?

1 Answers  

---

What Does 'sr' In Columns 7-8 Of C Specs Mean?

1 Answers   IBM,

---

What is the difference between production library and test library ?

1 Answers  

---

all i need to know about cmpseqdat parameter in cmppfm, how it works and can we retrieve line sequence and date from the output?

0 Answers  

---