|AS400 Interview Questions and Answers part 35
Q1:What keyword is used when screen is re-display?
Answer: RSTDSP is a parameter to be specified at compile time for DSPF.
Q2:How to validate input values in dspf?
Answer: using the validity checker keywords such as VALUE, RANGE, COMP.
Q3:Write an SQL select statement for selecting records from two files using single statement and nested select statement?
Q4:Different types of cursor?
Answer: SQL supports 2 types of cursor.
Q5:how to call/invoke the stored procedure?
Answer: Using CALL command.
Q6:What are the 2 important parameters to consider while creating SQLRPGLE program?
Q7:Can we update database file with the help of SQL cursor?
Answer: if we specify FOR READ while declaring the cursor then we cannot update but if we spcify nothing or FOR UPDATE(default is FOR UPDATE) then we can update the database file.
Q8:Does opening of cursor locks record?
Answer: Yes, records selected into cursor gets locked when the cursor is open.
Q9:How QTEMP is different fom other libraries?
Answer: QTEMP is associated to each job and is unique to each job which means each job has its own qtemp and other jobs cannot access others qtemp. Qtemp is created when the job is started and deleted when the job is closed.
Q10:What is the difference between module and program?
Answer: Module is a non-runnable object where as program is runnable.