300+ [MOSK ASKED] Ibm – As/400 Interview Questions and Answers

1. What Are The Different Types Of Data Areas?

The different types of Data Areas are general data area, local data area, group data area, pip (program initialization parameter data area) data area.

*General Data Area – It can be created by user implicitely or explicitly
It can be referred by any other jobs.
It can be associated with a library.
It can be created, deleted by the user.

* Local Data Area – It can not be referred by any other job.
It is automatically created and deleted by the system.
It is not associated with any library.

*Group Data Area – It is automatically created and deleted by the system We can access the group data area value through clp.
It is meant for group jobs.

*Pip Data Area – It is meant for pre start jobs.

2. How You Will Find An Error Which Is Not In The First Page Of The Subfile Without Using Rolldown Key?

By using keyword SFLRCDNBR.

3. What Is The Function Of Crtdupobj Command?

To create the replica from the original object.

4. What Is A Keyed Physical File?

Defining a field as a key in physical file. Hence we can access records through the key field.

5. What Is A Physical File?

Physical file nothing but a table contains a only one record format in which we can describe the field definitions and descriptions.

6. What Is The Clp Command To Access A Query/400?

WRKQRY

7. What Is The Command Used To Invoke Rlu ?

STRRLU.

8. How Do You Use Commitment Control In Rpg Program ?

Using COMIT operation. Makes all changes to the files that have been specified in output operation since the previous COMIT or the begining of operations under commitment control(if there has been no previous COMIT or ROLBK operation).

9. Difference Between Ca & Cf?

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

10. What Is The Syntax For Plist?

*ENTRY PLIST PARM

11. What Is Multi-format Logical File?

Logical which uses fields from two or more physical files.

12. What Are Various Techniques To Pass Parameters From One Program To Another?

PLIST, CALL, TFRCTL

13. Writing An Sql Statement From Selecting Records From Two Files Using Single Statement And Nested Select Statement.

Using Single statement.
SELECT * FROM FILE1, FILE2
WHERE FILE1.FLD1 = FILE2.FLD1

14. How Do You Pass Parameters In Cl?

Using PARM keyword.

15. Why Is As/400 Called Object Oriented Machine?

Everything on the AS/400 System that can be stored and retrieved is contained in the object.

16. Maximum Number Of Subfiles That Can Be Active For A Single File Is?

17. What Would Be The Effect On The Field Where Reverse Image, Underline And Highlight Display Attributes Were Active?

The result is same as if you had specified ND.

18. What Is The Version Of Os/400 That We Have?

V4R2 (Version @0 Release @0)

19. How Many Files Can Be Defined In F Specs?

20. Can Fields Be Concatenated Ina Logical File Level?

Yes. by using CONCAT keyword

21. How To Validate Input Values In Display File ?

With the help of Validity check key words VALUE, RANGE, COMP

22. How Many Specs Are There In Rpg & Which Are They?

There are 7 Specs in RPG they are H, F, E, L, I, C & O.

23. How Do You Read Data Area In An Rpg Program?

With the help of ‘IN’ opcode, we can access the data area record in to the program.

24. An Access Path May Be In Which Sequence?

It can be in Arrival & Keyed sequence.

25. What Is A Non-join Logical File?

It only provides logical view based on the physical file. This is also called as regular logical file.

26. A Join Logical File Has How Many Record Formats?

27. Define What A Data Area Is Along With A Brief Example Of What It May Be Used For?

Data area is a storage area to store limited information.
Example: a new and unique customer number is generated whenever a new customer is added to customer master file. Data area keeps track of last record added and add 1 to it. Through program we can access new customer number.

28. What Is Ddm ?

Distribution Data Management is a function of the OS/400 that allows an application program or user on one system to use database files stored on remote system.

29. What Is Qcmdexc?

It is used to execute a single CL command within the RPG program.

30. What Keyword Must Be Used With Protect Keyword?

OVERLAY

31. What Is The Use Of Dspatr(mdt) Keyword?

Sets on the modified Data Tag of the field. The Data Tag detect whether the field has been changed as a result of user input.

32. Which Cl Command Can Be Used At Program Execution To Redirect The File Named In An Rpg Program?

OVRDBF

33. When Do You Explicitly Open Files And Close Files In An Rpg Program?

If you specify the letter ‘ U ‘ at column 73-74, you need to be open and close files explicitly in a RPG program.

34. To Add A File To The ‘file Selection’ Option Of A Query, The Function Key To Be Pressed Is?

35. How Do You Specify Page Overflow Indicator For Printer Files In Rpg?

Specify an indicator in position 33-34 of F specification.

36. When Would You Use Or Not Use This Approach?

It is the most desirable method in building a real time applications. We can use at all the times.

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

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

38. Can A Single Screen Format Occupy A Screen Area Above And Below A Subfile Format ?

Not possible.

39. Why Is The Declare Cursor Statement Is Used For?

To define & name the cursor & specify rows to be fetched.

40. What Are The Three Line Types In Rlu ?

Report line, Filler line & Sample line.

41. 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.

42. What Are The Valid User Defined Data Area Types?

CHAR, NUMERIC and LOGICAL

43. What Are The Different Commands Used In Rlu ?

DR – Define Record, CLC – Change Line for Continuation, CLR – Change Line for Record, SD – Create Sample Data, VF – View Fields, NP – New Page, DC – Define Constants, DF – Define Fields, CF – Centre Fields & SP – Space Fields evenly.

44. How To Read Database Records Without Locking Them?

Put ‘N’ in position 53 of C specs.

45. What Does Exfmt Does?

Write & Read.

46. What Is The Command To Know How Many Lf Are Related To A Pf?

DSPDBR (Display Database Relationship)

47. How Many Libraries Can Be There In Library List ?

Total 40 (15 system and 25 application)

48. Which Of The Cl Command Can Be Used To Determine Which Logical Files Are Dependent On A Specific File?

DSPDBR

49. What Is The Purpose Of Overrides?

The basic purpose of Overrides is to temporarily change the attributes of a file. So you don’t have to create permanent files for every combination of attributes your application might need. Overrides gives you the flexibility to use existing model files and dynamically change their attributes.

50. Define Subsystem?

Subsystem is nothing but it provides specialized environment to complete the execution of jobs.