suppose if we want to update the data in cl what we will do?
- 9 Answers
- 13076 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ali
we can updateby executing SQL update statements in CL
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / afnas
Suppose want to update data in cl pgm perform SQL or call
RPG program , update the data using RPgG pgm then return
the value
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / shashank jain
We all know that in CL we can execute command line commands
so simply
write
''UPDDTA filename ""
in cl program and you can update your pf.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / surya siram
Normally we cannot update the data in physical file by using CL program, But by using RUNSQLSTM or RUNSQL commands we can run the sequel to update the data in physical files.
But we can update the data in display file using SNDRCV command
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / jhansi sundar
We can update the records in cl by using upddata.........
| Is This Answer Correct ? | 5 Yes | 8 No |
A pgm subroutine calling child subroutine, that child subroutine again calling parent subroutine, u have 1000 lines of code, with out debugging , how can u find that error??? Is there any command to find errors in pgm???
what is difference between DSPFD and DSPFFD?please give me real senario with good example?
Suppose my file has 10 fields and I want to make the 2nd field zeros in all records. And assume I have millions of records and I dont want to read each record and update the desired field with 0. Any other way to do this in one step operation?
I want my simple Green screen should refersh every 1 min ,How can I do it..? Please share the logic
Suppose you have 3 members in a database file. How to read records from all the members without using CL (OVRDBF) i.e. Entire process should be handled exclusively in a RPG program?
How do you know if a record exists without doing a READ and CHAIN?
How do you find whether a record is locked or not?
Hi, Can any body tell me ur experience on this questions? Questions: 1.what is the use of SFLRCDNBR other than subfile page display? 2.Which of the following operation cannot be used in conjuction with a file coded as device type disk?
How to read alternative records in a pf by using rpg?
what is file information data structure?
How to search particular records from the database file in rpg?
1. If there are two programs using same file and 2 users are using the file at the same time and what can be done to allow them both to access? 2. How can remove lock from the file for accessing it by both users?
RPG400 
