1⟩ In RPG program one file using as a PRIMARY file while running program some of the records reading twice any body know why its happening?
This will happen if there is any duplicate records in
physical file..
IBM AS400
Home Mainframes IBM AS400
“IBM AS400 frequently Asked Questions in various IBM AS400 job Interviews by interviewer. Get preparation of IBM AS400 job interview”
25 IBM AS400 Questions And Answers
2⟩ What are the commands that can be executed in CLP but not in RPG? Why?
All RTV* commands can be executed at CLP but cannot be
executed at RPG.
3⟩ Why we sometimes use same file name in FILE and TOFILE in OVRDBF and sometimes different?
In RPGLE if you want to declare the same file in more then
once mode(read/write/update)in this case you can override
the file with different name and declare the same file with
the overriden name.
for example:
In RPGLE if you want to open a file A in two different mode
one is Read and other is Update then you can override the
same file with two different name may be AA and AB and then
declare in your RPGLE program.
4⟩ What is the difference between ITER and DO? We know both are used to execute set of statements repeatedly, but what is the main difference?
There is no comparison between DO and ITER as DO statement
is an looping statement and ITER is an branching statement
like LEAVE.
When I use ITER with some condition inside a DO-ENDDO loop,
when that condition occouerd, ITER transferred the control
to ENDDO not out of the loop like LEAVE ie it just skip the
execution of statements between ITER and ENDDO.
In one statement we can say that ITER in RPGLE is same as
CONTINUE in C.
5⟩ Explain this error "All Record Formats for externally-described file ABCD ignored or dropped due to error; file ignored."?
Actually the file ABCD may have the record format name is
same as that of the file name. That is the reason why u r
getting this error.
RPGLE wont allow to declare a file with same name as record
format name.
So, to solve the problam u can change the record format
name other than the file name.
OR
U can use the RENAME keyword in the file specification to
change the record format name.
6⟩ How to search particular records from the database file in RPG?Suppose, there are 100 records in the file.i need to retrieve all the records matching/equal to the particular NAME field. How can we do the above using SEARCH criteria other than using the IF cond?
This can be done using the Key Field.
KEY1(NAME FIELD) SETLL FILENAME
KEY1(NAME FILED) READE FILENAME
7⟩ What is difference between array and multi dimensional data structure?
8⟩ Calling program in rpg or rpgle a to b to c explain the scenario?
9⟩ What is device error in as400?
10⟩ What is difference between packed decimal and zoned decimal?
11⟩ In 3 pages subfile 2nd page have error how you will display the subfile and do page up and page down this subfile?
12⟩ What is difference between read c and sflnxtchg?
READC is used to read the changed records in the subfile. But the catch is, it cannot read the same records twice. To overcome this situation, use SFLNXTCHG.
13⟩ How you read last record from subfile?
14⟩ How to see data from flat file?
dsppfm & runqry
15⟩ How to display blank subfile in ibm as400?
While loading the sub file we can simply increase the value of rrn or we can do this by using SFLINZ
16⟩ Which cl command work in rpg program?
17⟩ Which sql keyword is use to see data from physical file member?
18⟩ How to display blank subfile?
we suppose to select SFLDSPCTL with N option in SFL.
EX : goto strsda - select sflctl take opt 8 and then enter - select all general keywords with perameter Y and then next window will open there we can see the SFLDSPCTL, Here we can follow above steps.
19⟩ What is testn opcode will do?
Testn opcode will the check data type in result field like if we have result field is character then only character data type will move to this otherwise it will through the error
20⟩ What is difference between command attention & command function?
Command attention will not return any data from the screen to the program. Command function returns date from the screen to the program.
