Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Can anybody please tell me what is difference between SQL
(STRSQL ) and WRKQRY .....?

Answers were Sorted based on User's Feedback



Can anybody please tell me what is difference between SQL (STRSQL ) and WRKQRY .....?..

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).

Is This Answer Correct ?    12 Yes 0 No

Can anybody please tell me what is difference between SQL (STRSQL ) and WRKQRY .....?..

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.

Is This Answer Correct ?    6 Yes 0 No

Can anybody please tell me what is difference between SQL (STRSQL ) and WRKQRY .....?..

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.

Is This Answer Correct ?    8 Yes 6 No

Post New Answer

More IBM AS400 AllOther Interview Questions

In Which Specs Arrays, Tables & Constants Are Defined?

0 Answers   IBM,


how many types of display are available on as/400 for user interaction?

0 Answers   IBM,


what is match field indicator?

1 Answers   IBM,


What is diff between EVAL & MOVE?

0 Answers  


how do you detect unused spool storage?

2 Answers  


how would you design the process for a nightly, high volume check producing process that needs to select only records that are flagged to be processed?

1 Answers   IBM,


How do I release jobs in queue and change a job destination to a different printer. I know wrkjobq but I have not worked with As/400 for a while,so_can someone help me?

2 Answers  


which are the figurative constants used in rpg?

0 Answers   IBM,


Difference Between Skip Before & Space Before?

0 Answers   IBM,


under given circumstances, my cgi should link to another site. How to implement this?

0 Answers   IBM,


Define each of the following operation codes a, b, c, d, e

1 Answers  


how many printer files can be defined in f specs ?

1 Answers   IBM,


Categories