Answer / keshar

Addition to above answer to read particular member in file
we can use OVRDBF command in CL. This will pointed out to
particular member and then we can do any operation.
Syntax:
OVRDBF FILE(file1) MBR(mbr1)

In RPG we can read particular member by keyword EXTMBR in F
specification.

The EXTMBR keyword specifies which member of the file is
opened. You can specify a member name, '*ALL', or '*FIRST'.
Note that '*ALL' and '*FIRST' must be specified in quotes,
since they are member "names", not RPG special words. The
value can be a literal or a variable. The default
is '*FIRST'.

The name must be in the correct case. For example, if you
specify EXTMBR(mbrname) and variable mbrname has the
value 'mbr1', the member will not be found. Instead, it
should have the value 'MBR1'

example:
Ffile1 IE K DISK EXTMBR('MBR1')

Answer / pankaj

You can specify only one record format in a join logical
file.

Answer / sarath

hi i am not able to find the extmbr in my f spec pls advice
if i am wrong.

How do you code file / field renames in ILE RPG?

4 Answers   Accenture, IBM,

---

i 'm new to as/400.in an interview i was asked this question.give a practical example for passing information or data through local data area. I know only that data area is an object used to store tiny bits of data or it can store one value at a time and it is used to store frequently changing values or datas.thats all i know about data area can any one tell me how local data area and user defined data area are used to pass data between jobs with a example or coding.thanks in advance.

2 Answers   CTS,

---

Can anybody tell me the setps to create .csv file in IFS folder on AS/400. I also need to know how I can send this .csv file to PC in xls sheet.....?

2 Answers  

---

what is the difference between SETON RT & RETURN?

5 Answers  

---

Can we create 300 logical files based on a single physical file using the CRTLF command only once?.

8 Answers  

---

A particular job executing on the iS is not behaving as expected and is operating in an environment in which it can be debugged. What commands would you use to debug and observe the program?

2 Answers   IBM,

---

how do u track msg in cl pgm???

1 Answers   CTS,

---

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

4 Answers   Four soft,

---

How can we access Interactive job LDA in Batch Job?. and How we can access a file in interactive QTEMP lib in Batch job?.

4 Answers   IBM,

---

RPG/400 faqs?

1 Answers   HSBC,

---

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

0 Answers   IBM,

---

What is journalling and commitment control?

3 Answers   IBM,

---