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 is kids-rpg?

679


what are the key words you must use when using a subfile?

698


is this a rpg channel?

691


thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400

1905


what happens when sflsiz = sflpag? What are the advantages and disadvantages?

720






what is the rpg system?

676


Q:Hi all,i want accurate answer with code using in built functions.please sent me code as soon as posible. I have program nmed PGM1 which '' RETRIEVE Current production date''should correctly default the production date for the user who is issuing raw materials to the manufacturing.The production date can be different from the celendra date. However, the program does not make the correct adjustment for all manufacturing plants. there is a parameter which determines the production start time e.g. 07:00 if the system time precedes this,the program subtracts one from the celendra day.This work fine when the celendar day starts after production day as it does in England,the system should be adding one to the celendar day during the overlap. unfortunately the program was desined to assumed the celendar day always starts before the production day. Change required in the program: Change the PROGRAM PGM1 to use the new parrameter to decide whether to add or subtract 1 from the celendar day when determining the production date.

1767


can you debug ile rpg program using isdb?

748


How to write record if no field or the field are different in physical file in rpgle ?

498


How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...

1324


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?

519


how do I declare a minor?

724


do you use message subfiles? What are the necessary keywords required coding a message subfile?

698


How Chain operation copies the record's data to the input buffer for the program?

1094


what is an online rpg?

741