300+ [MOSK ASKED] Ibm-ile Interview Questions and Answers

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

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

2. What Is The Difference Between Packed Decimal And Zoned Decimal?

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

3. What Is Sflpag And Sflsiz?

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.

4. What Is The Purpose Of Level Check Parameter In A Physical File?

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

5. What Is The Use Of L Specs In Rpg?

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

6. What Is The Use Of Header Specification In Rpg/400?

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

7. What Is The Select And Omit Criteria In Logical File?

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

8. Difference Between Ca & Cf?

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

9. Specify Different Indicators Used In Rpg?

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

10. Which Are The Member Types Which Seu Supports?

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

11. Command Attention Key And Command Function Key?

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.

12. Define The Purpose Of The *bcat Function?

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

13. What Are The Basic Features Of Seu?

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

14. What Does The Opcode Free Do?

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.

15. What Is Overlay?

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

16. What Do We Can Do With The Embedded Sql Statements?

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

17. Describe About Query/400?

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.

18. How Are The Objects Stored On As/400?

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 trlated in to a physical address whether it is an auxiliary storage or main memory.

19. What Is *iso Date Format?

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

20. Which Are The Db2 Tools To Protect Integrity Of The Database?

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

21. Describe The Difference Between The Dowxx And Douxx Operations?

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.

22. What Are Control Level Indicators?

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.

23. What Are The Important Factors In Error Message Sub File ?

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

24. In Which Specs Arrays, Tables & Constants Are Defined?

In I Specs.

25. What Is Difference Between Cat, Tcat, Bcat?

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.

26. What Is A Spool File?

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

27. How To Get The Cursor Position?

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.

28. Define A Output Queue?

Output queues are queues of jobs waiting to be printed.

29. Why Rpg/400 Is Famous?

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

30. Define The Rcvf Command?

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

31. What Is The Use Of E Specification In Rpg?

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

32. What Are The Different Methods To Access Seu?

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