Answer / swetha p rao

1. TO find the field name in list of programs of a source
physical file then we give 25 option and Shift + F1 which
selects all the program sources and there we can specifiy
the name of the field.

2. we take an option 54 and give the other program name for
comparision.

3. Subfile hidden is not visible on the subfile but can be
used in the cases like storing the RRN number for that
particular record.we can update the value evrytime with RRn
value.so that it can be used in program.

4. If the subfile doesnt have any records we set on the
Control Format indicator and set off the Display indicator

Answer / vaiv20

1. Is it source physical file u are referring to or
Physical file?
2. Using option 54 against one version in wrkmbrpdm and
mentioning the other version when prompted for the member
to be compared with.
3. Hidden field on a subfile or display file can be defined
aa a variable that wont be displayed on the screen. In
subfile u can define hidden fields at the control record
format as well as at each subfile record level.

Answer / swetha p rao

we can display a subfile without records. but we have to
handle it in program,

If RRN >0
set on display and control indicators
else
Seton control and set off display indicator
Endif

Exfmt Screen

Answer / sourabh

1. Through READE opcode
4. With the help of SFLINZ keyword. Use this keyword in
display file with indicator (suppose 33).
After the Do loop where the data has been sent to buffer but
not written on the subfile, use the following code


IF RRN = 0 (OR 1 DEPEND FOR WHICH VALUE U HAD INITIALIZED IT)
MOVE *ON TO CONTROLLER INDICATOR
MOVE *IN33 *ON
MOVE *OFF TO CONTROLLER INDICATOR

Answer / ugandhar

3. Sub file hidden is not visible on the subfile but can be
used in the case like storing the RRN number for that
perticular record. This is as per one of our friend answer
and also we can use this hidden variables in subfile in
different senarios like if have more than one subfile
screen in single subfile and all screens are related to a
single file or firm. If you want to read the values from
all the screens at a time this subfile hidden variables are
very helpfull. Only thing is you need to declare the
variables as hidden which are available in second or
third..and not available in first with same name and
attributes. If you perform readc on single sflfrmt you can
get all values from all screens.

Answer / indraneel

1. In wrkmbrpdm screen enter option=25, then shift + F1.
Enter the test that you want to search. Results will be
shown. If the search string needs to be searched in
particular source hit F16.

2. Enither one can use CMPPFM command or option 54.

3. Hidden field is just like any other field in subfile.
Only difference you will not be able to specifiy position
location for the field. That is why it is called hidden
field.

4. Use SFLINZ keyword. Before doing the EXFMT to control
record set on the SFLINZ controlling indicator.

Answer / k.s.prathapa reddy

1.By using FNDSTRPDM command.

2.By using CMPPFM command.

3.RRN

4. By setting on SFLINZ keyword.
Write an empty record to the subfile and then display
the subfile-contorl record.

Answer / ram

4.ANS. We Cannot display a subfile without records.

It gives MCH1202(decimal data Error).

1. If my rpg program has a date field, What extra care I have to take while compiling that RPG program? 2. If the file is keyed and I have declared the file as well as Key list properly in my program. Still am getting an error message like "Chain/reade operation is not allowed" What may be the case?

6 Answers   Virtusa,

how can we find setll setgt chain read reade readp operations are successfull or not,give example.explain in detail.

4 Answers   iSoft, Wipro,

Can a indexed file be accessed in arrival sequence in RPG?

1 Answers  

wat is the difference between dataarea and data queue?

5 Answers   Airtel, Four soft, Shahi Exports,

Q1.How to read the Array? Q2.How to copy the content of one Array to another Array?

4 Answers   IBM,

What is the difference between inner join @ outer join

4 Answers  

what is the difference between the cpyf command crtdupobj command?

9 Answers   IBM,

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,

1..Write an sql query to find the employee name who is having 2 phone numebr? 2.Write an sql query to the the second highest salary of the employee?

4 Answers  

How to search particular records from the database file in rpg?

2 Answers  

Given the following code, what is the value of RESULT? DName+++++++++++ETDsFrom+++To/L+++IDc.Keywords+++++++++++++ D RESULT S 5 0 C EVAL RESULT = (2 + 3 * 2) ** 2 / 2

2 Answers  

What is the Record Address file. How can we use it in RPG program?

4 Answers