IBM-ILE Interview Questions & Answers

  1. Question 1. How Are The Objects Stored On As/400?

    Answer :

    All objects are stored on AS/400 in a single level storage.
    In this method all objects are referenced by one virtual address which is translated in to a physical address whether it is an auxiliary storage or main memory.

  2. Question 2. What Is A Spool File?

    Answer :

    Printed output items placed in an output queue are known as spooled files.

  3. IBM – RPG Interview Questions

  4. Question 3. In Which Specs Arrays, Tables & Constants Are Defined?

    Answer :

    In I Specs.

  5. Question 4. Which Are The Member Types Which Seu Supports?

    Answer :

    RPG, CL, PF, LF, PRTF & DSPF.

  6. IBM – RPG Tutorial

  7. Question 5. What Are The Different Methods To Access Seu?

    Answer :

    Use the Start Source Entry Utility command (STRSEU) Option 8 from STRPGMMNU Through Program Development Manager (PDM)

  8. IBM DB2 Interview Questions

  9. Question 6. What Are The Basic Features Of Seu?

    Answer :

    Prompt depending upon type, shows right hand side date & left hand side the line number.

  10. Question 7. How Many Types Of Display Are Available On As/400 For User Interaction?

    Answer :

    The 4 Types they are Entry, Menu, Information & List Display.

  11. IBM DB2 Tutorial
    DB2 Using SQL Interview Questions

  12. Question 8. Which Are The Db2 Tools To Protect Integrity Of The Database?

    Answer :

    Journaling & Commitment Control, Referential Integrity Embedded SQL & Object/Record Locks.

  13. Question 9. What Does The Opcode Free Do?

    Answer :

    The FREE operation removes a program from the list of activated programs, frees static storage and ensures program initialization (first cycle processing) the next time program is called. It does not close file or unlock data area.

  14. IBM Mainframe Interview Questions

  15. Question 10. Why Rpg/400 Is Famous?

    Answer :

    * Easy to code and analyze.
    * Supports externally described files.

  16. DB2 Using SQL Tutorial

  17. Question 11. Define A Output Queue?

    Answer :

    Output queues are queues of jobs waiting to be printed.

  18. IBM AIX 7 Administration Interview Questions

  19. Question 12. Difference Between Ca & Cf?

    Answer :

    CA: – It does not retains the value into the buffer memory.
    CF: – It retains the value into the buffer memory.

  20. IBM – RPG Interview Questions

  21. Question 13. What Is The Difference Between Packed Decimal And Zoned Decimal?

    Answer :

    Packed decimal : One digit occupies 1 byte.
    Zoned decimal : One digit occupies 2 bytes.

  22. IBM Mainframe Tutorial

  23. Question 14. Describe The Difference Between The Dowxx And Douxx Operations?

    Answer :

    DOWxx : If the condition becomes true, then only the group of instructions allowed executing.
    DOUxx : Irrespective of condition, it will execute at least one time.

  24. Question 15. Define The Purpose Of The *bcat Function?

    Answer :

    To concatenate the two strings by placing a single blank in a resultant.

  25. AS400 Interview Questions

  26. Question 16. Define The Rcvf Command?

    Answer :

    RCVF command used to receive the records either from the data base file or device file.

  27. Question 17. What Is Sflpag And Sflsiz?

    Answer :

    SFLPAG : it is an attribute which specifies the number of records that can be displayed in a screen.
    SFLSIZ : it is an attribute which specifies the number of records can be stored in the subfile.

  28. Automatic Storage Management (ASM) Interview Questions

  29. Question 18. Command Attention Key And Command Function Key?

    Answer :

    With the help of Command attention key we can pass only the indicator status to program not the data from screen. While command function key passes indicator status as well as a data from screen to program.

  30. IBM DB2 Interview Questions

  31. Question 19. What Is Overlay?

    Answer :

    It allows a record format to be displayed on screen retaining the previous displayed record formats.

  32. Question 20. How To Get The Cursor Position?

    Answer :

    With the help of RTNCSRLOC keyword, here we need to define a field to get row and column. Length of variable should be 5,0 fixed We can specify *FILED for filed *REC for Record on which a key is pressed.

  33. Mainframe DB2 Interview Questions

  34. Question 21. What Are The Important Factors In Error Message Sub File ?

    Answer :

    We must define error message record format (SFLMSG). And a Program Queue. (PGMQ) and Record format is associated to a line number.

  35. Question 22. What Is *iso Date Format?

    Answer :

    YYYY-MM-DD for other formats refer to IBM manual or ERIS document.

  36. Question 23. What Do We Can Do With The Embedded Sql Statements?

    Answer :

    We can Insert/Update/Delete records, fetch records, fetch values from records into variables.

  37. Rpgle Interview Questions

  38. Question 24. What Is The Use Of L Specs In Rpg?

    Answer :

    Line counter specification can be used to describe printer file to indicate the length of the form and number of lines per page.

  39. DB2 Using SQL Interview Questions

  40. Question 25. What Is The Use Of E Specification In Rpg?

    Answer :

    Extension Specs describes all record address files, arrays and tables.

  41. Question 26. What Are Control Level Indicators?

    Answer :

    L1 to L9 used to identify certain fields on control fields and then used to condition which operations are to be processed at detail or total calculation or output time.

  42. Question 27. Specify Different Indicators Used In Rpg?

    Answer :

    Overflow indicators
    Record Identifying Indicators
    Field Indicators
    Resulting Indicators
    Control Level Indicators

  43. IBM Mainframe Interview Questions

  44. Question 28. What Is The Use Of Header Specification In Rpg/400?

    Answer :

    It identifies by H in column 6, provides information about generating and running programs.

  45. Question 29. What Is Difference Between Cat, Tcat, Bcat?

    Answer :

    CAT – Concatenate two variables or constants into one continuous string.
    BCAT – Truncates all trailing blanks in the first character string, one blank is inserted, then the two character strings are concatenated.
    TCAT – Truncates all trailing blanks in the first character string, the two character strings are concatenated.

  46. Question 30. What Is The Select And Omit Criteria In Logical File?

    Answer :

    This is used to specify rules for the Selection/Omission of records from a Physical File.

  47. Question 31. Describe About Query/400?

    Answer :

    Query/400 is a licensed program that uses a query to analyze and select the information contained in the data base files and create a query report.
    A query report can be:

    * displayed on a workstation (screen)
    * printed
    * stored in another database file.

  48. Question 32. What Is The Purpose Of Level Check Parameter In A Physical File?

    Answer :

    Specifies whether the level identifiers of the record formats in the physical file are checked when the file is opened by the program.