IBM AS400 Interview Questions And Answers
Download IBM AS400 Interview Questions and Answers PDF
Refine your IBM AS400 interview skills with our 25 critical questions. Our questions cover a wide range of topics in IBM AS400 to ensure you're well-prepared. Whether you're new to the field or have years of experience, these questions are designed to help you succeed. Download the free PDF now to get all 25 questions and ensure you're well-prepared for your IBM AS400 interview. This resource is perfect for in-depth preparation and boosting your confidence.
25 IBM AS400 Questions and Answers:
IBM AS400 Job Interview Questions Table of Contents:
1 :: 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
Read MoreKEY1(NAME FIELD) SETLL FILENAME
KEY1(NAME FILED) READE FILENAME
2 :: 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.
Read Moresame 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.
3 :: 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.
Read Moreis 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.
4 :: 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.
Read Moreexecuted at RPG.
5 :: 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.
Read Moreonce 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.
6 :: 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..
Read Morephysical file..
7 :: What is difference between rename and prefix?
The RENAME keyword allows you to rename record formats in
an externally described file. The external name of the
record format that is to be renamed is entered as the
Ext_format parameter. The Int_format parameter is the name
of the record as it is used in the program. The external
name is replaced by this name in the program.
To rename all fields by adding a prefix, use the PREFIX
keyword.
Read Morean externally described file. The external name of the
record format that is to be renamed is entered as the
Ext_format parameter. The Int_format parameter is the name
of the record as it is used in the program. The external
name is replaced by this name in the program.
To rename all fields by adding a prefix, use the PREFIX
keyword.
8 :: Suppose 4 persons a, b , c , d have to go to concert which will held in 17 minutes. there is a bridge which only 2 persons at a time can cross. its night and they have only one flashlight with them. Flashlight cannot be thrown. one person should return with the flashlight
all 4 person have different speed.
a = crosses bridge in 1 min.
b = crosses bridge in 2 min.
c = crosses bridge in 5 min.
d = crosses bridge in 10 min
how can they all reach in time?
Ex- suppose a and d crosses bridge which will take 10 mins and then d returns back with a flashlight which will make 20 mins and mission is failed.?
A and B will cross the bridge. --> 2 mins
A will come back with the flashlight. --> 1 min
C and D will cross the bridge --> 10 mins
B will come back with the flashlight. --> 2 mins
A and B will cross the bridge. --> 2 mins
Total is 17 mins.
Read MoreA will come back with the flashlight. --> 1 min
C and D will cross the bridge --> 10 mins
B will come back with the flashlight. --> 2 mins
A and B will cross the bridge. --> 2 mins
Total is 17 mins.
9 :: HOW TO DEBUG A BATCH JOB WHEN IT IS IN MESSAGEWAIT(MSWG) STATUS. I KNOW THE STEPS FOR BATCH EBUGGING, BUT IM CONFUSING WITH WHEN WE SUBMIT ANY JOB FOR BATCH DEBUG WE PUT IN HELD STATE. SO HERE ALSO DO SAME THING OR ANY OTHER WAY?
it is also normal process like as batch job steps...
when we found job in MSGW using WRKSBMJOB,simply we can enter into job log using 5 option.
after we start at command line.
step1-> STRSRVJOB jobnum/jobname/user
step2-> STRDBG pgmname
when we press enter,the control will directly goto
the error occurred line,here we can change any values directly using EVAL then after press F3,it will sho wjob log screen,then again press f3 to come to MSGW screen.here press 7(display message screen) to continue the execution of batch job we press G(continue).then it will execute remaing steps without abnormal ending the job.
Read Morewhen we found job in MSGW using WRKSBMJOB,simply we can enter into job log using 5 option.
after we start at command line.
step1-> STRSRVJOB jobnum/jobname/user
step2-> STRDBG pgmname
when we press enter,the control will directly goto
the error occurred line,here we can change any values directly using EVAL then after press F3,it will sho wjob log screen,then again press f3 to come to MSGW screen.here press 7(display message screen) to continue the execution of batch job we press G(continue).then it will execute remaing steps without abnormal ending the job.
10 :: How to retrieve RRN value in RPGLE program?
We can retrieve RRN value in RPGLE program by using INFDS
Read More11 :: What is difference between procedure and function?
Be the First to Post Your Answer Now
12 :: 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.
Read More13 :: 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.
Read MoreEX : 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.
14 :: 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
Read More16 :: Which sql keyword is use to see data from physical file member?
Be the First to Post Your Answer Now
17 :: 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
Read More18 :: How you read last record from subfile?
Be the First to Post Your Answer Now
20 :: 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.
Read More21 :: In 3 pages subfile 2nd page have error how you will display the subfile and do page up and page down this subfile?
Be the First to Post Your Answer Now
22 :: What is device error in as400?
Be the First to Post Your Answer Now
23 :: What is difference between packed decimal and zoned decimal?
Be the First to Post Your Answer Now
24 :: Calling program in rpg or rpgle a to b to c explain the scenario?
Be the First to Post Your Answer Now
25 :: What is difference between array and multi dimensional data structure?
Array is collection of similar data type where as multi occurrence ds can be
combined like number as well as char.
Read Morecombined like number as well as char.