AS400 Interview Questions (DB2) - Part 2

DB2 AS400 Interview questions and Answers

DB2 AS400 Interview Questions and Answers  - part 2, Interview questions, AS400 Interview questions, DB2 Interview question, IBM i Interview question, AS400 Interview questions and Answers,as400 interview questions and answers for experienced,as400 interview question and answer,as400 db2 interview questions and answers,as400 interview questions,as400 cl interview questions,as400 interview questions and answers,as400 rpg interview questions,interview questions on as400 rpg,as400 interview questions hsbc,ibmi interview questions,rpgle interview questions,rpg developer interview questions,ibmi Interview Questions and Answers,AS400 DB2 Interview Questions and Answers
AS400 Interview Question (DB2) - Part 2

Q1: What is the purpose of creating a multi-record format file in real-time?

Answer:

Multi record format LF in AS400:

  • Combine more than one PF record format.
  • Only one file definition is required in the program.
  • Make the RPG program simpler.
  • Can access data from multiple PF's in one read operation.

Q2: Why do we use DYNSLT (Dynamic Select) keyword in LF?

Answer:

DYNSLT is a file-level keyword and can only be used in LF.

  • SELECT and OMIT(Filter data) in LF are done at Run Time.
  • Program read file(At that time all records are tested for SELECT and OMIT criteria).
  • Used with LF with no key and wants to use SELECT and OMIT criteria.
  • If you don't want to maintain the access path. 

Q3: What is the purpose of using the ALWNULL keyword?

Answer:

ALWNULL is a field-level keyword.

  • Used with a field in DDS PF to allow NULL values.
  • SQL Table default is NULL.
  • DDS PF default is NOT NULL.

Q4: What is the use of multi-member PF in real-time?

Answer:

maintaining monthly or yearly data in a multi-member PF in separate members etc.

  • CRTPF command used to create PF and by default one member with the same name.
  • We can change the member names at PF creation time.
  • No member means we cannot store data in PF.
  • Multimember PF has more than one member.
  • ADDPFM command is used to add members to PF.
  • Set MAXMBRD parameter as more than 1 (In Create command).

Q5: How to get updated rows to count after executing UPDATE statement?

Answer:

SQLCA field SQLERRD gives you the updated rows count.

Related Post

AS400 Interview Questions - Part 1
AS400 Interview Questions - Part 2
AS400 Interview Questions - Part 3
AS400 Interview Questions - Part 4
AS400 Interview Questions - Part 5
AS400 Interview Questions - Part 6
AS400 Interview Questions - Part 7
AS400 Interview Questions - Part 8
AS400 Interview Questions - Part 9
AS400 Interview Questions - Part 10
AS400 Interview Questions - Part 11
AS400 Interview Questions - Part 12
As400 Interview Questions - Part 13
AS400 Interview Questions (DB2) - Part 1

Post a Comment

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