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 are the objects stored on AS/400?

1 Answers  

---

WHICH REPLY CODE IS USED BT sftp ? ... (e.g.226 is used by FTP IF FILE IS TRANSFERED)

0 Answers  

---

How do you use DEBUG utility?

1 Answers  

---

Distinguish between logical file and physical file?

1 Answers  

---

what is multijoin logical file? what are the keywords available in joinlogical file? what are the mandatary keywords for joinlogical file? explai the keywords?

2 Answers   HCL,

---

what are necessary keywords to code message subfile?

1 Answers   IBM,

---

CAN WE INSERT FIELD IN PHYSICAL FILE BY USING OPNQRYF?

4 Answers  

---

What is the draw back of Procedures? why we are going to Modules?

0 Answers  

---

How can u create a temporary file in CLP @ how to access that temporary file in RPG program?

4 Answers  

---

(1)In Cl Program,Are PGM and ENDPGM mandatery Keywords or not .If yes, please tell me why these keywords is necessary. (2)If we will not define these two keywords (PGMand ENDPGM) then any error will be come or not.

5 Answers   FIS, IBM, Virtusa,

---

list some of the commonly used commands for debugging?

1 Answers   IBM,

---

how many key fields does cl required

1 Answers  

---