Interview Questions.

Q1. What Are The Different Types Of Data Areas?

The exclusive styles of Data Areas are standard statistics area, nearby information vicinity, group data location, pip (software initialization parameter information vicinity) records region.

*General Data Area - It may be created by using user implicitely or explicitly

It can be referred by using every other jobs.

It can be associated with a library.

It can be created, deleted by using the person.

* Local Data Area - It cannot be referred by way of some other activity.

It is automatically created and deleted with the aid of the machine.

It isn't associated with any library.

*Group Data Area - It is mechanically created and deleted by way of the gadget We can get entry to the organization facts region cost via clp.

It is supposed for group jobs.

*Pip Data Area - It is supposed for pre start jobs.

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

By using key-word SFLRCDNBR.

Q3. What Is The Function Of Crtdupobj Command?

To create the duplicate from the authentic item.

Q4. What Is A Keyed Physical File?

Defining a field as a key in physical document. Hence we are able to access records through the key discipline.

Q5. What Is A Physical File?

Physical record not anything but a desk consists of a only one file format wherein we will describe the field definitions and outlines.

Q6. What Is The Clp Command To Access A Query/four hundred?

WRKQRY

Q7. What Is The Command Used To Invoke Rlu ?

STRRLU.

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

Using COMIT operation. Makes all changes to the files which have been laid out in output operation for the reason that preceding COMIT or the begining of operations underneath dedication manage(if there has been no preceding COMIT or ROLBK operation).

Q9. Difference Between Ca & Cf?

CA: - It does not retains the value into the buffer reminiscence. CF: - It keeps the value into the buffer memory.

Q10. What Is The Syntax For Plist?

*ENTRY PLIST PARM

Q11. What Is Multi-layout Logical File?

Logical which uses fields from two or more bodily files.

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

PLIST, CALL, TFRCTL

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

Using Single declaration.

SELECT * FROM FILE1, FILE2

WHERE FILE1.FLD1 = FILE2.FLD1

Q14. How Do You Pass Parameters In Cl?

Using PARM key-word.

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

Everything on the AS/four hundred System that can be stored and retrieved is contained inside the object.

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

12

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

The result is same as in case you had distinctive ND.

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

V4R2 (Version @zero Release @0)

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

50

Q20. Can Fields Be Concatenated Ina Logical File Level?

Yes. Through the usage of CONCAT keyword

Q21. How To Validate Input Values In Display File ?

With the assist of Validity test key phrases VALUE, RANGE, COMP

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

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

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

With the help of 'IN' opcode, we will get entry to the records region document in to the program.

Q24. An Access Path May Be In Which Sequence?

It can be in Arrival & Keyed sequence.

Q25. What Is A Non-be a part of Logical File?

It handiest offers logical view based on the physical record. This is likewise called as ordinary logical record.

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

1

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

Data vicinity is a storage vicinity to shop restricted data.

Example: a new and unique consumer number is generated each time a new consumer is brought to patron grasp record. Data area keeps song of closing document delivered and upload 1 to it. Through program we will get entry to new customer variety.

Q28. What Is Ddm ?

Distribution Data Management is a feature of the OS/four hundred that lets in an software software or consumer on one machine to use database documents saved on remote system.

Q29. What Is Qcmdexc?

It is used to execute a unmarried CL command inside the RPG software.

Q30. What Keyword Must Be Used With Protect Keyword?

OVERLAY

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

Sets on the modified Data Tag of the field. The Data Tag detect whether or not the field has been changed because of person input.

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

OVRDBF

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

If you specify the letter ' U ' at column seventy three-74, you need to be open and near files explicitly in a RPG software.

Q34. To Add A File To The 'file Selection' Option Of A Query, The Function Key To Be Pressed Is?

F9

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

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

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

It is the most suitable method in building a actual time programs. We can use at all the times.

Q37. How Many Types Of Display Are Available On As/four hundred For User Interaction?

4 Types they may be Entry, Menu, Information & List Display.

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

Not possible.

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

To outline & call the cursor & specify rows to be fetched.

Q40. What Are The Three Line Types In Rlu ?

Report line, Filler line & Sample line.

Q41. What Are Control Level Indicators?

L1 to L9 used to identify certain fields on manipulate fields and then used to condition which operations are to be processed at element or overall calculation or output time.

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

CHAR, NUMERIC and LOGICAL

Q43. 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 flippantly.

Q44. How To Read Database Records Without Locking Them?

Put 'N' in role fifty three of C specifications.

Q45. What Does Exfmt Does?

Write & Read.

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

DSPDBR (Display Database Relationship)

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

Total forty (15 machine and 25 utility)

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

DSPDBR

Q49. What Is The Purpose Of Overrides?

The primary cause of Overrides is to briefly trade the attributes of a file. So you don't need to create everlasting files for each combination of attributes your utility may need. Overrides offers you the power to use existing version files and dynamically exchange their attributes.

Q50. Define Subsystem?

Subsystem is nothing but it presents specialised environment to complete the execution of jobs.