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

Categories >> Software >> MainFrame >> IBM AS400 >> RPG400
Suggest New Category

Question Posted / sony

9 Answers
12961 Views
I also Faced
E-Mail Answers

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