suppose if we want to update the data in cl what we will do?

Answer Posted / shanky

We can update records in CL program but its only possible
through SQL statement in CL

In STRQMQRY command we can write SQL statement at SETVAR(
Update &FILE set FILED=' ' where &FILED='Key Value'


........There are many PDFs on google from where u can get
ready programs....................

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of identifiers?

546


How to handle duplicate error handling in RPG?

1636


How to declare the pull button in AS/400..

1853


When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?

473


what is data area and how it is used in rpg program ?

722






what is the use of sflnxtchg?

780


what is the necessary keyword needed to scroll subfile records?

673


Assume 2 users are using the same file and first user updates some record in the file. Will the 2nd user will be able to see the updated record or not?

484


how do I play {insert rpg system here}?

560


what is the procedure and explain about real time scenario.

1454


what is the difference between do while and do until?

663


What is the difference between iter and do?

643


what is a rpg?

670


how can you display specific subfile page on the screen in unequal subfile?

648


can any one help in hawkeye and turnover or any change management system plzzzzz or send the documents to my mail id :gvsp.as4@gmail.com

1937