Answer / sujata

The DB2 UDB for AS/400 commitment control support provides
a means to process a group of database changes (updates,
inserts, DDL operations, or deletes) as a single unit of
work (transaction). A commit operation guarantees that the
group of operations is completed. A rollback operation
guarantees that the group of operations is backed out. A
commit operation can be issued through several different
interfaces.

Can anybody tell me that why we use option(*nodebugio)in H- Spec?

3 Answers  

---

what is program status data structure?

1 Answers   IBM,

---

The PGMA calls PGMB.PGMB generates a report.The report should contain the called program name(PGMA).How do i get the called program name in PGMB to print it on the spool file?(calling program name should NOT be hard coded or passed as parameter to called program?

6 Answers  

---

Can more than one subfile record be displayed on one line?

7 Answers   IBM,

---

Assume my file has 100 records and I want to see only first 10 records. Is this possible through lf?

1 Answers  

---

---

how can i retrieve the field name from display file at run time? Devendra Singh Tomar

3 Answers  

---

I am reading a file in CL program. and MONMSG CPF0864 has arrived means EOF has arrived. Now i want to read this file again. How i can do this?

5 Answers   CitiGroup, Symphony,

---

can anyone say,what is the use of operation extended H/N/P?

2 Answers  

---

i hav 2 logical files(L1,L2) both r derived from one physical file(P1). how can i use both the logical files in one RPG program? if yes what i have to d.

5 Answers   TCS,

---

what is the equivalent keyword for CHAIN opcode ??

7 Answers   TCS,

---

Thanks gagan for your answer,i'm new to as400,i don't know embedded sql in rpg.can you send me the coding for the below mentioned question in embedded sql rpg. 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.

2 Answers   iGate,

---

RPG/400 number of Records present in a physical file using file information data structure FPF001 IP E DISK F KINFDS INFDS1 IINFDS1 DS I *RECORD RECORD Is this coding correct sir,i have given I P E that is I- input,P-primary file,E-externally described. Primary to use RPG logic cycle,is this the correct method because we have to find number of records present using file information data structure in RPG/400 without doing any input/output operations on the file and also without using DSPFD,SQL. If the above coding is correct means,when i compile the program it gets compiled,but if i call the program it does not return anything,i need number of records,please complete the coding sir.

1 Answers   IBM,

---