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 tell me how to read the records from a file with load an array of size with error conditions(The logic answer for this question is ARR is array of 99 elements Z-ADD 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN99 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO).So,Please give me the complete of this code.
How to write record if no field or the field are different in physical file in rpgle ?
What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?
What is a record lock error?
how do I play {insert rpg system here}?
What is ment by record level identifier?
how can I tell when to replace the array?
what is file information data structure?
Hi Viewers can any body explain me how to update and ahange the already existed data in physical file using subfile ? please explain me with the code if possible?
explain sflclr, sflend, sfldlt, and sflcsrrrn?
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...
Explain mdt?
what is kids-rpg?
1. What is bound-by-call and bound-by-reference? 2. Where and why is *Nomain used? 3. What are the difficulties faced by programmers when using service programs? 4. Explain the different ways of parsing and compiling XML in iSeries.
What is the purpose of record level identifier?