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

Answers were Sorted based on User's Feedback



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

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

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

Answer / chandu

Use RUNSQLSTM to update data in CL.

Is This Answer Correct ?    8 Yes 1 No

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

Answer / ali

we can updateby executing SQL update statements in CL

Is This Answer Correct ?    6 Yes 0 No

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

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

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

Answer / chitta

we cannot update data through cl

Is This Answer Correct ?    4 Yes 2 No

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

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

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

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

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

Answer / suri

UPDATE IS NOT POSSIBLE IN CL.

Is This Answer Correct ?    3 Yes 4 No

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

Answer / jhansi sundar

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

Is This Answer Correct ?    5 Yes 8 No

Post New Answer

More RPG400 Interview Questions

Hi friends, Can you give the solution for the below mention simple code.and explain.what is output D CHR1 S 4A INZ('PEN') D CHR2 S 10A INZ('MYGET') D CHR3 S 8A INZ('GOOD') D CHR4 S 22A INZ C MOVEL CHR1 CHR4 C MOVE CHR2 CHR4 C EVAL CHR4=CHR3 C MOVE CHR1 CHR4

4 Answers  


When PGMA calls PGMB for the first time PGMB executes the *INZSR. PGMB uses the RETRN operation to return to PGMA. When PGMA call PGMB the second time is the *INZSR executed?

5 Answers   Mphasis,


I have to change a program. This program is calling a subroutine mor than 100times within it. so will it have any performance issue? if yes than what changes i can make. Thanx for ur valuable answer.

2 Answers  


Need a sql query: retrive all duplicate records in table

3 Answers  


what is file information data structure?

1 Answers   IBM,






Suppose I have 3 jobs a b and c. I want to submit b after successful completion of a and want to submit c after successful completion of b. Without using job scheduler or job queue, how can I do that through cl program?

1 Answers  


how we create binder member for updating service program and where we type this code on command line or in program ? strpgmexp pgmlvl(*current) export symbol (xyz0 endpgmexp. plz explain me this step by step .

2 Answers  


What is I90(Insure 90)?

1 Answers  


how do u find whether a record is locked or not??

4 Answers   CTS,


wat is meant by hidden field , why it is used?

4 Answers   Four soft,


What is use of IMPORT and EXPORT in RPGLE ? What is activation Group ? What is Service Program ???? How to call another program in RPGLE ?

1 Answers  


Why we cannot call a service program? If I add a PEP can i call the service program?

1 Answers   DELL,


Categories