AS400 and SQL Tricks

AS400 Interview Questions and Answers part 36 Q1: What is the difference between CHAIN and SETLL? Is there a performance advantage? Answer: The…

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 a…

AS400 Interview Questions and Answers part 34 Q1:Which is the built in function to convert numeric field to alpha field? Answer: %EDITC, %EDITW…

AS400 Interview Questions and Answers part 33 Q1:The qualified name for an object TESTPF residing in a library QGPL is? Answer: QGPL/TESTPF. …

AS400 Interview Questions and Answers part 32 Q1:Which are the relational operators in RPG? Answer: GT, GE, LT, LE and EQ. Q2:Difference betw…

AS400 Interview Questions and Answers part 31 Q1:If your workstation does not show login screen what might be the problem? Answer: Problem with …

AS400 Interview Questions and Answers part 30 Q1:When would the ALL keyword be used? Answer: Used with Select and Omit to select/omit records. …

AS400 Interview Questions and Answers part 29 Q1:What is DDM? Answer: Distributed Data Management is a function of the OS/400 that allows an app…

AS400 Interview Questions and Answers part 28 Q1:What are the necessary keywords for the join logical file? Answer: JDFTVAL, JFILE, JOIN, JFLD,…

AS400 Interview Questions and Answers part 27 Q1:What is the CL command to access Query/400? Answer: WRKQRY. Q2:What is the purpose of Overr…

AS400 Interview Questions and Answers part 26 Q1:What is the use of SFLRNA keyword? Answer: Make subfile record format inactive. Q2:How can y…

AS400 Interview Questions and Answers part 25 Q1:Name the debugging commands? Answer: STRDBG and STRISDB. Q2:What is RCVF command in CL? An…

AS400 Interview Questions and Answers part 24 Q1:What is shared access path? Answer: An access path describes how records in a database file ar…

DB2 Interview questions and answers Q1: What is ALTER? Answer 1: ALTER is an SQL statement that is used to change the structure of any objects …

AS400 Interview questions and answers part23 Q1: What is the DATA AREA and why it is used? Answer 1: Data Area is an object which is used to hol…

AS400 Interview questions and answers part22 Q1: When program1 calls program2 for the first time and program2 executes INZSR and uses only the RETUR…

AS400 Interview questions and answers part21 Q1: Difference between SETON LR and RETURN? Answer 1: SETON LR is used to release the memory of wh…

AS400 Interview questions and answers part20 Q1: CL command to find Dependent file? Answer 1: The Display Database Relations (DSPDBR) command id…

AS400 Interview questions and answers part19 Q1: What is the maximum size of the data area? Answer 1: The maximum size of the data area is 9999 …

AS400 Interview questions and answers part18 Q1: Why do we use SETLL operation in RPGLE? Answer 1: SETLL is used to check whether a record exis…