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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how do you read changed records backward in subfile?

826


using dfu, user will be able to ___________ from physical file?

756


What Is The Error If We Don't Get Login Screen?

869


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

1343


what do we can do with the embedded sql statements?

797


can error messages as a result of a comp, range or values keyword be overridden?

1466


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

1308


What Is The Difference Between Goto & Exsr?

1386


Write a CL program which will run a batch job at 1 am every night

874


what is full form for dds?

958


how do you read data area in an rpg program?

1460


what is the maximum number of records you can specify in a display file?

1470


can anybody give the interview questions list of RLU. plz mail me: dinesh_sati07@yahoo.com

2438


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

2112


what does the opcode free do?

1544