Question { Bank Of America, 24813 }

How do you find out whether a record is present in the
physical file without reading the file?
for Example Employee No: 100 in an Employee master.How do
we find out whther 100 is present in Employee master
without reading the file?

Answer

*loval setll file
read recor 70

in indicator on norecords in file ,else records in file

Question { 19910 }

what is the difference between SETON RT & RETURN?

Answer

SETON RT returns the program and closes the all the open
sources and terminate he program but retun doesn't do that
just end the program and all the open files are not close

Question { 16764 }

Anybody can explain the difference between SFLCLR & SFLINZ?

Answer

SFLCLR is clear the toal subfile and inactive the all
therecord and you can wrie the recors to subfile thoseare
only active

SFLINZ is just gives the deful values to the fields of all
the records of subfile and all are active this will useful
only when u showing total subfile withou data
you cant write the data to subfile once you intilize the
data untill clear the subfile

Question { IBM, 17657 }

How do you know if a record exists without doing a READ and
CHAIN?

Answer

PGM PARM(&NBRRCD)
DCL &NBRRCD TYPE(*DEC) LEN(10 0)

RTVMBRD FILE(STR) MBR(*FIRST) +
NBRCURRCD(&NBRRCD)
ENDPGM

Question { HSBC, 15975 }

What hapens when we use CPYF command to copy a LF? On which
PF will it be dependent???

Answer

even we use LF copy to copy the file only PF will be created
and but not the LF so it will not dependent on the any other PF

Question { Virtusa, 9440 }

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?

Answer

2A:May be you have define you file as output mode

Question { HCL, 8790 }

1. I have2 records in a PF.
READ PF
DO
DSPLY EMPNO
RETRN
DSPLY EMPNO
ENDDO
What was the output
2. SETON LR vs RETURN
3. Primary File
4. How to delete a deleted spaces
5. How to read a PF in reverse order in CL
6. I have a object in Lib A, B and C. But it shows in D
Lib..Why?
7.

Answer

1A: system will display the first record data and will exit
the program and when ever you recall that program 2nd time
from the same session then system will display the second
record data and subsequent calls from the same screen will
display the second record data only.

2A: SETONLR will close the files and then close the program
and exit the program but RETURN will remain open the opened
file and exit the program with out closing the files.

3A: Once if you define the file as primary file then system
will seuqnetial read the all the recods in that program and
then only it will exit the program, if you use the primary
file alone ina program you need to use the SETONLR because
system it self will close the file once it reaches the EOF.

4A: deleting the deleted space in the sense we are trying
reuse the space of deleted records for that we can it using
the command called "Reorganize Physical File Mbr (RGZPFM)".

5A: we can use the OVRDBF & POSDBF commands in CL

Question { HCL, 8790 }

1. I have2 records in a PF.
READ PF
DO
DSPLY EMPNO
RETRN
DSPLY EMPNO
ENDDO
What was the output
2. SETON LR vs RETURN
3. Primary File
4. How to delete a deleted spaces
5. How to read a PF in reverse order in CL
6. I have a object in Lib A, B and C. But it shows in D
Lib..Why?
7.

Answer

Once RETURN excute then system exit the program, second
DSPLY will never excute, in first DSPLY EMPNO system will
show the first record value.

Question { Cap Gemini, 6297 }

Why we need to give File and To file Names While we are using
OVRDBF. What is your understanding related to this?

Answer

OVRDBF is to override the your database data to other file for some temporary time, other file may be the same file or different file. if you want to override your data to some temp place then you should mention that which file data you want to override(file) and where you want to keep your data(to file).