can we use cl programming to update or delete physical files

Answer Posted / anish

Although there are no keywords to update or insert or
delete records in a CL program, we can do the same with the
help of a 'RUNSQLSTM' statement. With this command we can
runa query directly from the CL program and do an
insert/update/delete without calling an RPG program.

Plzz let me know if my understanding is corerct.

Is This Answer Correct ?    32 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Interviewer asked me write down DDS for load all subfile .can anybody write dds

1020


write an RPG program to calculate the marks of 5 students (A,B, C, D, E)in 3 different subjects (eng, math, sci) an display on the screen

831


thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400

1895


How can we know running job is batch or interactive?

657


how do I preserve and clean the array?

676






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

1313


are there any useful c runtime apis that I can call from rpg iv?

700


what is *place and *auto keyword in prtf ?plz explain

2726


What is the purpose of record level identifier?

729


Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?

1455


What are the types of identifiers?

572


How many program bind in one module....

2122


how do I declare a table or array in rpg iv?

738


how does the rpg element work?

717


how do you use commitment control in rpg?

758