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

can a single screen format occupy a screen area above and below a subfile format ?

1 Answers   IBM,


In Which Specs Arrays, Tables & Constants Are Defined?

0 Answers   IBM,


How can we find from which source the program has been compiled for a given RPGLE program object?

5 Answers  


not all command typed on command line are cl command? true r false

3 Answers  


what are all the contents of subfile?

1 Answers   IBM,


what are the types of errors available in rpg IV or 400.Like decimal data error,sessional error or device error etc...means important error occurings,ie to find out suddenly???pls give answ if u know?

2 Answers   CTS,


what is qcmdexc?

1 Answers   IBM,


How do you check object lock

0 Answers  


what are the limitations of cl (compare to rpg) ?

1 Answers   IBM,


define the purpose of the %sst function?

1 Answers   IBM,


Can we use OVRDBF command without using of OPNQRYF ? Or can we use OPNQRYF command without using of OVRDBF command ?

4 Answers   HCL, iGate,


what is rpg ?

1 Answers   IBM,


Categories