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

  1. Categories >> Software >> MainFrame >> IBM AS400 >> IBM AS400 AllOther
  2. Suggest New Category

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

Question Posted / samul

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

writing an sql statement from selecting records from two files using single statement and nested select statement.

0 Answers   IBM,

how can I automatically refresh a web page?

0 Answers   IBM,

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

1 Answers   IBM,

what is the use of unique keyword and what level it is defined?

1 Answers   IBM,

The content of Physical file is as below: hfcftp wruquief SENDPASV 0 CDUP ASCII GET 01100901.CSV ramndk/ECP505.EC0110090 (REPLACE QUIT Thw above commands will get executed when we call STRTCPFTP from CL program.... Now if I want to use SFTP what can be the solution? plz reply in detail....Thank you for ny help... I m using RPG/ILERPG to download...

0 Answers  

what does check opcode is used?

1 Answers   IBM,

What are the record format field mapping options in cpyf?

0 Answers  

what does vldcmdkey means?

0 Answers   IBM,

What is the necessary keyword used in a physical file to refer field definitions from the field reference file?

1 Answers  

Define the purpose of the following code (If you know, how would this be written in RPG ILE) HI LO EQ C *IN66 DOUEQ *OFF C KEY1 CHAIN FILEA 90 66 C 66 CALL PGM1 PRM C ENDDO

1 Answers  

What is an ICF file?

1 Answers  

How to change file attributes such as size, file wait time, record wait time etc., permanently?

1 Answers  

For more IBM AS400 AllOther Interview Questions Click Here
Categories