AS400 Interview Questions and Answers part 30

AS400 Interview Questions and Answers part 30
AS400 Interview Questions and Answers part 30, FNDSTRPDM, PDM, READ, CHAIN, WRITE, UPDATE, DELETE, SETLL, SETGT, READE, READP, READPE, OPEN, CLOSE, FORCE, NEXT, UNLOCK, rpg opcode for database access, self join in as400, multi-dimensional array in rpg, check opcode in rpg, TESTZ opcode, testn opcode, MONMSG, error in CL, Select and omit and all keyword in lf
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.

Q2:How to trap errors in CL?

Answer: By using MONMSG(Monitor message) command.

Q3:What is the maximum length of a variable in CL?

Answer: Max 11 characters (including &).

Q4:What opcode could be used to test an alphanumeric field for all numeric values?

Answer: TESTN.

Q5:What opcode could be used to test the zone of a character field?

Answer: TESTZ.

Q6:What does CHECK opcode is used?

Answer: The check opcode verifies that each character in the factor 2(base string) is among the character mentioned in the factor 1(comparator string).

Q7:Can we define multi-dimensional array in RPG?

Answer: No.

Q8:Is it possible to join the same file itself?

Answer: Yes.

Q9:What are the different opcodes available in RPG for database access?

Answer: READ, CHAIN, WRITE, UPDATE, DELETE, SETLL, SETGT, READE, READP, READPE, OPEN, CLOSE, FORCE, NEXT, UNLOCK.

Q10:How will you find a string using PDM?

Answer: FNDSTRPDM.

Post a Comment

© AS400 and SQL Tricks. All rights reserved. Developed by Jago Desain