Answer Posted / anurudh dwivedi

this can be done wid 2 methods
1.Interactive SQL
2.Embedded Sql
1. In interactive Sql
Strsql(Command line)
update pf001
set sal=sal+30
where id=1
2. same in embedded sql but save your object of type SQLRPGLE
c/exec sql
c+ update LIB1/pf001 set sal = sal + 30 where id=1
c/end-exec
save and compile(when u will compile,,,, u would be shock!!! update will not work)
but after following steps:
journaling it will work.

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

3215

---

We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?

1301

---

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?

1973

---

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?

5237

---

do you use message subfiles? What are the necessary keywords required coding a message subfile?

1182

---

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

1356

---

When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?

1006

---

what is an online rpg?

1324

---

Explain mdt?

1204

---

what do you mean by an input subfile, what are the keywords required?

1305

---

how do I preserve and clean the array?

1208

---

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

1228

---

How to handle duplicate error handling in RPG?

2353

---

What is file identifier where we can use?

1179

---

what are the key words you must use when using a subfile?

1239

---