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

Answer / chandu

Use RUNSQLSTM to update data in CL.

Answer / ali

we can updateby executing SQL update statements in CL

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

Answer / chitta

we cannot update data through cl

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

Answer / suri

UPDATE IS NOT POSSIBLE IN CL.

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.

Answer / jhansi sundar

We can update the records in cl by using upddata.........

1. I have2 records in a PF. READ PF DO DSPLY EMPNO RETRN DSPLY EMPNO ENDDO What was the output 2. SETON LR vs RETURN 3. Primary File 4. How to delete a deleted spaces 5. How to read a PF in reverse order in CL 6. I have a object in Lib A, B and C. But it shows in D Lib..Why? 7.

4 Answers   HCL,

this is rpg3 code W0RTN IFEQ @CN,002 what is the means @CN,002

1 Answers  

How can you delete a record from a file in RPG without using DELETE oppcode?

2 Answers   UST,

IN RLU what are the record level keyword is used?

5 Answers   iGate, TCS,

WHAT IS MENT BY RECORD LEVEL IDENTIFIER ? WHAT IS THE PURPOSE OF THIS?

1 Answers  

how to retrieve particular field records from a physical file,say i have a physical file called 'employee' in it i have to retrieve the records of a field 'admin' present in pf 'employee' using rpg,but i should not use logical file or openquery file.

3 Answers   iGate, Wipro,

How to identify the object has compiled with the debug view as *source without using STRDBG?

6 Answers  

what is commitment control?explain about it?

1 Answers   HSBC,

which MONMSG will give higher priority in CL program? I know MONMSG are of two types. Program Level Monmsg and Command Monmsg?

1 Answers  

check existence of one record without using chain or read?

1 Answers   IBM,

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.

2 Answers  

Write the subfile logic program for the given concept. Load the data to the subfile depends upon the designation where designation is not a key field?

2 Answers   TCS,