Top 100+ Ibm - As/400 Interview Questions And Answers
Question 1. How Do You Pass Parameters In Cl?
Answer :
Using PARM key-word.
Question 2. What Are The Valid User Defined Data Area Types?
Answer :
CHAR, NUMERIC and LOGICAL
IBM - RPG Interview Questions
Question 3. What Is Multi-format Logical File?
Answer :
Logical which uses fields from two or more physical files.
Question 4. What Is The Select And Omit Criteria In Logical File?
Answer :
This is used to specify rules for the Selection/Omission of information from a Physical File.
IBM - RPG Tutorial
Question five. Can Fields Be Concatenated Ina Logical File Level?
Answer :
Yes. Through the usage of CONCAT key-word
IBM - VSAM Interview Questions
Question 6. When Would The All Keyword Be Used?
Answer :
Use with Select or Omit, to pick out/miss data.
Question 7. What Are The Different Types Of Keywords In Display Files?
Answer :
File level, Record layout degree, Field degree
IBM Cognos Tutorial IBM Cognos Interview Questions
Question eight. What Is Difference Between Cat, Tcat, Bcat?
Answer :
CAT - Concatenate variables or constants into one continuous string.
BCAT - Truncates all trailing blanks in the first person string, one clean is inserted, then the two person strings are concatenated.
TCAT - Truncates all trailing blanks within the first man or woman string, the 2 man or woman strings are concatenated.
Question nine. What Are The Different Types Of Messages In Cl?
Answer :
Immediate message, Break message, Program message, User message.
IBM DB2 Interview Questions
Question 10. How To Trap Errors In Cl?
Answer :
By the use of Monitor Message Command (MONMSG)
IBM DB2 Tutorial
Question 11. What Is The Maximum Length Of A Variable Name In Cl?
Answer :
Maximum 11 characters (which include '&')
System Administration Interview Questions
Question 12. What Are The Limitations Of Cl (examine To Rpg) ?
Answer :
You can't use CL program to ADD or UPDATE facts in database files.
Use Printer or ICF documents.
Use Program defined files.
Use the idea of subfile (to display more than one file), but a single output message subfile is a unique type of subfile this is supported well in CL.
Use subroutines.
You cannot declare more than one object (document) in a CL programme.
IBM - RPG Interview Questions
Question 13. What Is The Use Of Header Specification In Rpg/400?
Answer :
It identifies by way of H in column 6, presents informaion approximately generating and jogging packages.
Question 14. When Will Dump And Debug Opcodes Be Ignored?
Answer :
If clean is specified in function 15 of H specs.
Question 15. Specify Different Indicators Used In Rpg?
Answer :
Overflow signs
Record Identifying Indicators
Field Indicators
Resulting Indicators
Control Level Indicators
IBM AIX Interview Questions
Question 16. What Are Control Level Indicators?
Answer :
L1 to L9 used to become aware of certain fields on control fields after which used to circumstance which operations are to be processed at element or overall calculation or output time.
Question 17. What Is The Use Of E Specification In Rpg?
Answer :
Extension Specs describes all document cope with files, arrays and tables.
SQL Interview Questions
Question 18. What Is The Use Of L Specs In Rpg?
Answer :
Line counter specification may be used to explain printer file to indicate the period of the form and quantity of traces consistent with page.
IBM - VSAM Interview Questions
Question 19. In Which Specification The Report Layout Can Be Defined?
Answer :
O Specification.
Question 20. How Many Files Can Be Defined In F Specs?
Answer :
50
AS400 Interview Questions
Question 21. How Many Printer Files Can Be Defined In F Specs ?
Answer :
eight
Question 22. A Program Variable Coded In An Embedded Sql Statement Is Referred To As?
Answer :
Host Variable
Question 23. Which Of The Cl Command Can Be Used To Determine Which Logical Files Are Dependent On A Specific File?
Answer :
DSPDBR
IBM BPM Interview Questions
Question 24. What Does Dfu Program You To Do On A Record?
Answer :
Insert, Update Delete & File Enquiry.
IBM Cognos Interview Questions
Question 25. When Are The Unique Constraints Executed?
Answer :
During Insert.
Question 26. When Are The Referential Constraints Executed?
Answer :
Insert, Update & Delete.
Synopsys Interview Questions
Question 27. How Many Triggers Can Be Associated With A File?
Answer :
6(Maximum)
IBM DB2 Interview Questions
Question 28. Why Is The Declare Cursor Statement Is Used For?
Answer :
To define & name the cursor & specify rows to be fetched.
Question 29. What Do We Can Do With The Embedded Sql Statements?
Answer :
We can Insert/Update/Delete statistics, fetch statistics, fetch values from statistics into variables.
Rpgle Interview Questions
Question 30. Which Cl Command Is Used To Trap Error Messages During Program Execution?
Answer :
MONMSG
Question 31. Which Cl Command Can Be Used At Program Execution To Redirect The File Named In An Rpg Program?
Answer :
OVRDBF
Question 32. How To Write *pssr ?
Answer :
It simply just like every other subroutine.
*PSSR BEGSR
………………
………………
…………….
ENDSR
Question 33. What Is Procedure ?
Answer :
A manner is the set of self contained excessive degree language statements that could perform a selected challenge and then returns to a caller.
System Administration Interview Questions
Question 34. What Is Procedure Prototype And Procedure Interface.
Answer :
Procedure Prototype
In this section we specify the name of the manner along side PR.
D PROC1 PR
Procedure Interface
It is segment where we define all the parameter which might be receiving or returning some values.
D PROC1 PI 5 0
D PARMA 5 0
D PARMB five zero
Question 35. How To Define Global Parameter In Ile ?
Answer :
Declare a variable with key word EXPORT and at the same time as the usage of this variable in anther program declare with IMPORT keyword.
Question 36. What Is The Disadvantage Of Using Global Variable?
Answer :
We cannot hint out at which point the price of variable is changed.
IBM AIX Interview Questions
Question 37. What Is Service Program?
Answer :
A Service Program is a group of runnable approaches and to be had statistics items without difficulty reachable via other ILE packages. In many respects it's miles just like a subroutine library and manner library.
A carrier program differs from a program in methods:
It does not incorporate a program entry system. This way that you can't call a carrier application using the CALL operation.
A carrier program is certain right into a program or other provider packages the use of binding through reference.
Question 38. What Is *iso Date Format?
Answer :
YYYY-MM-DD for different codecs seek advice from IBM guide or ERIS report.
Question 39. If We Tried To Move Year Part Of *iso Date Into A Field Of Length three, What Will Happen ?
Answer :
Program crashes, as in case of *ISO layout it required fields of 4,2,2.
Question 40. How To Avoid Using Indicators In Ile ?
Answer :
By the use of the usual Built In Expressions like %FOUND,%EOF, NOT %EOF, %BOF, NOT %BOF…and so forth.
Display / Printer File
SQL Interview Questions
Question 41. Explain The Keywords Edtcde & Edtwrd?
Answer :
EDTCDE & EDTWRD are key phrases used for formatting reason. EDTCDE cannot be applied to Character filed. And EDTCDE has a few Codes pre-described as an instance,
EDTCDE(Z) – for suppressing the leading zero Y – for date discipline.
EDTWRD may be used to define user described formatting for a fields.
Question forty two. What Are The Important Factors In Error Message Subfile ?
Answer :
We ought to outline errors message document format (SFLMSG). And a Program Queue. (PGMQ) and Record layout is related to a line wide variety.
AS400 Interview Questions
Question 43. How To Define To Define A Hidden Filed In Dspf ?
Answer :
Define a filed in a DSPF of use HIDDEN.(H)
Question forty four. How To Get The Cursor Position?
Answer :
With the assist of RTNCSRLOC keyword, right here we need to define a discipline to get row and column. Length of variable should be five,zero fixed We can specify *FILED for filed *REC for Record on which a key's pressed.
Question forty five. What Is Overlay?
Answer :
It allows a file format to be displayed on display screen maintaining the previous displayed document formats.
Question 46. What Key Word Is Used When Screen Is Re-show?
Answer :
RSTDSP is a parameter to be particular at compile time for display file.
Question 47. Command Attention Key And Command Function Key ?
Answer :
With the assist of Command attention key we will bypass most effective the indicator popularity to application no longer the data from screen. While command feature key passes indicator repute in addition to a data from screen to software.
Question 48. How To Validate Input Values In Display File ?
Answer :
With the help of Validity check key phrases VALUE, RANGE, COMP
Question forty nine. Different Type Of Cursor?
Answer :
Two styles of Cursor
Simple / Serial Cursor
A serial cursor is one defined with out SCROLL key word
For serial cursor every row is fetched only once in step with OPEN When it is opened it's miles placed before the primary row in the desk.
To use serial cursor we ought to re-issue OPEN
Scrollable Cursor which is defined with SCROLL key phrase.
Cursor defined with SCROLL key phrase
Rows of cursor can be fetched typically
When it is opened it's miles placed before the primary row in the table.
When the FETCH is issued , the cursor is placed to the row of the table that is targeted by the POSITION alternative. (FIRST, LAST, PREV, NEXT, RELATIVE)
Question 50. Writing An Sql Statement From Selecting Records From Two Files Using Single Statement And Nested Select Statement.
Answer :
Using Single statement.
SELECT * FROM FILE1, FILE2
WHERE FILE1.FLD1 = FILE2.FLD1
Question 51. Difference Between View And Index ?
Answer :
View will not any information.. It only indicates a records from desk while Index has a Indexing Data for a series on which Index is created. View is much like Logical record without having Key and Index is similar to Logical File having Key (as keyed logical record has get right of entry to path facts) Table is just like PF.
Question 52. What Is The Sequence When Using Cursor?
Answer :
Define Cursor ,Declare Cursor ,Open Cursor ,Fetch file ,Processing ,Close Cursor
Question fifty three. What Are The Three Types Of Keywords Associated With Printer File ?
Answer :
File level, Record level & Field stage.
Question fifty four. Difference Between Sflrcdnbr And Sflnxtchg?
Answer :
SFLRCDNBR will provide the RRN of the First file displayed on the display at a given time. Whenever a document is changed on show document. An MDT is ready ON. If a trademark is related to SLFNXTCHG and it's far SETON then READC will study only the modified file. And if the indicator isn't associated and it's far seton it READC reads all of the facts from sub-document.
Question 55. How Can See Logical File Based On Which Physical File And Vice Versa
Answer :
DSPDBR
Question fifty six. How Can U Check No Of Records In A File?
Answer :
DSPFD
Question fifty seven. How Do U Compile Rpgle Program?
Answer :
Either via 15 or crtrpgmod
Question 58. Is Module Executable?
Answer :
No You need to create an RPG prog to run the module.
Question fifty nine. What Are The Different Commands Used In Rlu ?
Answer :
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 frivolously.
Question 60. What Is The Command Used To Invoke Rlu ?
Answer :
STRRLU.
Question sixty one. What Are Different Record Spacing Keywords In Rlu ?
Answer :
SKIPA, SKIPB, SPACEA & SPACEB.
Question sixty two. Mandatory Keywords Of Sub File?
Answer :
SFL, SFLCTL, SFLDSP, SFLSIZ, SFLPAG are the necessary key phrases
Question sixty three. What Is Procedure?
Answer :
A method is the set of self-contained high degree language statements that may carry out a specific challenge and then returns to a caller.
Question sixty four. What Is Lokup Opcode?
Answer :
Look’s for a particular detail of an array
Question 65. How Many Files, Printer Files You Can Describe In A Rpg?
Answer :
50 files and 8 printers
Question sixty six. How Do Handle File Exception/errors?
Answer :
*INFDS ,*PSSR defining it in F spec
Question 67. Distinguish Between Terminating A Program Through Seton Lr And Return?
Answer :
LR closes all the files used within the software and RETURN is used to return the manipulate to the determine application.
Question sixty eight. How Will You Add A Field To Physical File Already Containing Data?
Answer :
With CPYF command and *NOCHK & *DROP
Question sixty nine. What Are The Uses Of Factor1, Factor2 And Result Field For The Rpg Operation Code Parm?
Answer :
It is add cost of FACTOR1 to FACTOR2 or examine the value of FACTOR 2 with FACTOR1.
Question 70. How Will You Find A String Using Pdm?
Answer :
By the usage of FNDSTRPDM.
Question 71. How Will You Search An Array?
Answer :
LOKUP
Question seventy two. What Are The Different Types Of Arrays?
Answer :
Preruntime receives populated at the time enter. Runtime receives populated at the time execution.Compile time receives populated at the time of compilation.
Question seventy three. What Is Message File?
Answer :
It is document which include messages created by using the person via which a person can show own message while validating.
Question seventy four. What Does Defn Do?
Answer :
It is used to define a subject based totally on the value laid out in FACTOR 1.
Question seventy five. What Are Two Types Of Record Are Used In Subfile?
Answer :
SUBFILE RECORD FORMAT and SUBFILE CONTROL RECORD FORMAT.
Question 76. What Are Dds Required For Subfile?
Answer :
SUBFILE DISPLAY (SFLDSP) SUBFILE DISPLAY CONTROL (SFLDSPCTL) SUBFILE CLEAR (SFLCLR) SUBFILE SIZE (SFLSIZE) SUBFILE PAGE (SFLPAGE).
Question 77. What Is Elastic And Non Elastic Subrile?
Answer :
When subfile size is more then subfile web page size it's far referred to as elastic subfile and while subfile length is same to subfile web page length it's miles known as non-elastic subfile.
Question seventy eight. What Is Sflinz And Sflrna?
Answer :
SFLINZ stands for subfile initialize. It initialized all of the person discipline as blanks and numeric fields as zeros. SFLRNA stands for subfile report now not energetic (It means information are there within the subfile however active).
Question seventy nine. Can You Display A Empty Subfile?
Answer :
Yes via the usage of the key-word SFLINZ and SFLRNA.
Question eighty. Why Do We Use Readc? What Is Sflnxtchg?
Answer :
READC is to examine those records which have changed inside the subfile. If you validate a record in subfile on some condition all the invalid facts can display in reverse picture. The first that have changed and made legitimate and launched still showing in opposite image. The data have study even it has no longer been changed because of SFLNXTCHG.
Question 81. How Do You Read Changed Records Backward In Subfile?
Answer :
NOT POSSIBLE.
Question 82. How You Will Find An Error Which Is Not In The First Page Of The Subfile Without Using Rolldown Key?
Answer :
By the use of keyword SFLRCDNBR.
Question 83. What Is Sflrolval?
Answer :
By the usage of this keyword you may inform system to roll on of statistics whilst the user presses ROLLDOWN key (For this you define a hidden of four byte).
Question 84. How You Will Know Whether You Are In Sfldrop Or Sflfold Mode?
Answer :
By the use of the keyword SFLMODE.
Question 85. How You Get The Relative Record In A Subfile In Which Cursor Is Located?
Answer :
By using the key-word SFLCUSRRN (Subfile cursor relative record wide variety).
Question 86. What Is Qcmdexc?
Answer :
It is used to execute a single CL command inside the RPG application.
Question 87. What Are The Different Opcodes Available In Rpg For Database Access ?
Answer :
READ, CHAIN, WRITE, UPDAT, DELET, SETLL, SETGT, READE, READP, REDPE, OPEN, CLOSE, FORCE, NEXT, UNLCK.
Question 88. How Can Database Records Be Read Without Lock ?
Answer :
Put 'N' in position 53 of C specifications.
Question 89. What Does Check Opcode Do ?
Answer :
The check operation verifies that every individual inside the base string (factor 2) is among the ` man or woman indicated in the comparator string(aspect 1).
Question ninety. In Conjunction With Which Statements Can Orxx And Andxx Conditions Be Used ?
Answer :
DOUxx, DOWxx, IFxx, and WHxx.
Question 91. What Does Opcode Post Do ?
Answer :
Puts records in INFDS.
Question ninety two. Can You Have Multiple Key Lists For A Single File ?
Answer :
Yes.
Question ninety three. What Are The Different Types Of Arrays Available In Rpg ?
Answer :
Pre-execution time array.
Compile time array.
Execution time array.
Question 94. Can We Define Multi-dimensional Arrays In Rpg ?
Answer :
No.
Question 95. What Is Xfoot Opcode ?
Answer :
Adds all the factors in a numeric array, and locations the sum in the result area.
Question 96. During Input Operation Which Indicator Position Is Seton If There Is A Record Lock?
Answer :
LO indicator role is seton.
Question 97. What Is The Difference Between *like And *namvar ?
Answer :
*LIKE defines the variables as in database.
*NAMVAR is used to outline variables as statistics area.
Question ninety eight. What Would Be The Effect On The Field Where Reverse Image, Underline And Highlight Display Attributes Are Active ?
Answer :
The result is equal as in case you had specific ND.
Question ninety nine. What Is The Purpose Of Ovrdta And Ovrata Keywords ?
Answer :
OVRDTA keyword (discipline or file degree) may be used to override the prevailing statistics contents of a field or report already on the display.
OVRATA key-word (area or file level) can be used to override the existing display attributes of a field or record already at the display.
Question a hundred. What Keyword Must Be Used With Protect Keyword ?
Answer :
OVERLAY
Question 101. What Is Rpg ?
Answer :
Report Program Generator.
Question 102. Where Will Control Be Passed After The Execution Of The *pssr Subroutine If The Factor2 Of The Endsr Is Blank ?
Answer :
Control will return to the next sequential instruction.
Question 103. What Is The Maximum Number Of Subfiles That Can Specified In A Display File ?
Answer :
512
Question 104. The Maximum Number Of Subfiles That Can Defined In A Rpg Program For One Display File Is ___ .
Answer :
24
Question 105. The Maximum Number Of Subfiles That Can Be Active For A Single File Is ____ .
Answer :
12
Question 106. What Are The Different Opcodes Used For File Operation On A Subfile In A Rpg Pgm?
Answer :
READ, READC, CHAIN,UPDAT and WRITE
Question 107. How Will You Display A Particular Page In Subfile ?
Answer :
Move a valid relative file number(RRN) within the area distinct the use of SFLRCDNBR key-word in DDS.
Question 108. Can A Single Screen Format Occupy A Screen Area Above And Below A Subfile Format ?
Answer :
Not feasible.
Question 109. What Is Sflpag And Sflsiz ?
Answer :
SFLPAG : it is an attribute which specifies the quantity of facts that can be displayed in a display screen.
SFLSIZ : it's miles an characteristic which specifies the variety of data may be saved inside the subfile.
Question one hundred ten. How To Pick Up The Changed Records Every Time In A Subfile After The First Change Made ?
Answer :
Seton SFLNXTCHG keyword indicator and replace the subfile record.
Question 111. How Do You Specify The Number Of Records To Roll In A Subfile ?
Answer :
Use SFLROLVAL keyword in DDS at the side of the variety, which specifies the wide variety of records to scroll at a time.
Question 112. What Are The Three Line Types In Rlu ?
Answer :
Report line, Filler line & Sample line.
Question 113. What Is The Function Of Rlu ?
Answer :
To layout & prototype a file.
Question 114. Define What A Data Area Is Along With A Brief Example Of What It May Be Used For?
Answer :
Data location is a storage vicinity to save limited facts.
Example: a new and particular purchaser variety is generated each time a brand new purchaser is delivered to client master record. Data place maintains song of closing file delivered and add 1 to it. Through software we can get entry to new customer quantity.
Question a hundred and fifteen. Define What A Data Queue Is Along With A Brief Example Of What It May Be Used For?
Answer :
Data queues affords verbal exchange between packages by calling API's QSNDDTAQ and QRCVDTAQ in conjunction with parameters like records queue call, library in which statistics queue exists, variable to save the quantity of characters to be despatched, variable to save the facts to be despatched. We can send the equal facts queue to the numerous applications.
Question 116. What Is The Difference Between Udate And The System Date?
Answer :
UDATE supports two-digit yr. The format is *MDY (MMDDYY).
*DATE (machine date) supports four digit yr. The layout is *MDYY (MMDDYYYY).
Question 117. List Some Of The Commonly Used Commands For Debugging?
Answer :
STRDBG(for batch jobs), STRISDB.
Question 118. Define The Rcvf Command?
Answer :
RCVF command used to receive the facts either from the information base record or tool file.
Question 119. Define The Purpose Of The %sst Function?
Answer :
To extract the information from the required string.
Question one hundred twenty. Define The Purpose Of The *cat Function?
Answer :
To concatenate the 2 strings right into a one string.
Question 121. Define The Purpose Of The *bcat Function?
Answer :
To concatenate the two strings by using putting a single blank in a resultant.
Question 122. Describe The Difference Between The Dowxx And Douxx Operations?
Answer :
DOWxx : If the circumstance turns into real, then best the group of instructions allowed executing.
DOUxx : Irrespective of circumstance, it'll execute at the least one time.
Question 123. Define The Purpose Of The Leave Operation?
Answer :
If you specify LEAVE, the control transfers to the declaration underneath the ENDDO.
Question 124. Define The Purpose Of The Iter Operation?
Answer :
If you specify the ITER, the organizations of statements are allowed to execute again and again.
Question 125. How Can You Check For A Records Existence Without Causing And I/o (chain/read)?
Answer :
With the assist of File Information Data Structure, we will test lifestyles of records in a physical report. The code is described under: In File description continuation line (IPFK), KINFDS RCDS IRCDS DS I *RECORD #RCDS with the above code we can take a look at the existence of records in a document with out causing I/O operation.
Question 126. What Is Message Subfile?
Answer :
Message subfile is special report includes more than one messages taken from application message queue and placed in message sub document for show on the screen.
Question 127. What Is The Purpose Of Putovr (positioned With Explicit Override) Keyword?
Answer :
Use this record-stage keyword to allow the override of either display record attributes or facts contents of specific fields inside a document displayed on the paintings station device.
Question 128. What Are Necessary Keywords To Code Message Subfile?
Answer :
SFLMSGRCD, SFLMSGKEY, SFLPGMQ
Question 129. What Is The Difference Between Seton Lr And Retrn?
Answer :
If you specify SETON LR, all of the documents utilized in software will be closed.
If you specify RETRN, all the files utilized in application will remain open.
Question one hundred thirty. What Is The Purpose Of Ovrdta (override Data) Keyword?
Answer :
Use this area stage key-word with PUTOVR key-word to override the present the facts contents of a field already on the display.
Question 131. What Is The Maximum Number Of Record Formats In Dspf?
Answer :
1024 (One thousand and twenty 4)
Question 132. What Is The Maximum Number Of Fields Under A Record Format Of Physical File?
Answer :
8000 (eight thousand)
Question 133. What Is The Maximum Number Of Parameters Allowed In Rpg?
Answer :
255 (Two hundred and fifty 5)
Question 134. What Is The Maximum Number Of Parameters Allowed In Clp?
Answer :
forty three (Forty 3)
Question a hundred thirty five. What Is The Maximum Number Of Subroutines Allowed In Rpg?
Answer :
254 (Two hundred and fifty four)
Question 136. What Is The Maximum Number Of Files Allowed In Rpg?
Answer :
50 (Fifty including eight printer report)
Question 137. What Is Maximum Number Of Arrays Allowed In Rpg?
Answer :
250 (Two hundred and Fifty )
Question 138. Where Can You Specify An Indicator In Lokup Operation?
Answer :
In 'EQ' role.
Question 139. What Is A Member?
Answer :
It is a subset of statistics information of a physical report.
Question one hundred forty. What Is A Physical File?
Answer :
Physical file nothing however a desk includes a most effective one document format wherein we can describe the field definitions and descriptions.
Question 141. What Is A Logical File?
Answer :
It is nothing however a logical view furnished by means of the physical report.
Question 142. What Is Join Logical File?
Answer :
Join logical file joins more than one report. The maximum of variety of files allowed to sign up for is 32 (thirty two).
Question 143. What Are The Necessary Keywords For The Join Logical File?
Answer :
JDFTVAL, JFILE, JOIN, JFLD, JREF.
Question one hundred forty four. What Is A Non-join Logical File?
Answer :
It most effective provides logical view based totally at the physical document. This is also known as as ordinary logical record.
Question one hundred forty five. What Is The Necessary Keyword For Non-be part of Logical File?
Answer :
PFILE (that is report degree keyword)
Question 146. How Many Levels Are There In A Physical File?
Answer :
Four tiers. They are File degree, Record level, Field level, Key discipline degree.
Question 147. What Is The Use Of Unique Keyword And What Level It Is Defined?
Answer :
It will keep away from to go into duplicate key values. We need to define it in a report level.
Question 148. At What Level S,o Are Defined And What They Will Do?
Answer :
S, O are to defined at key subject stage. The cause Select/Omit logic is relies upon at the standards (condition) given at the important thing discipline level (At function access) it selects and omits the statistics. The S/O is permitted in Logical document most effective.
Question 149. 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.
Question one hundred fifty. What Is Default Data Type (if You Define Decimals '0') In Physical File?
Answer :
Packed decimal
Question 151. What Is Default Data Type For The Fields(sub Fields) Defined In Data Structures In Rpg?
Answer :
Zoned decimal
Question 152. What Is The Use Of Jdftval In Join Logical File?
Answer :
If you specify JDFTVAL at record level, even the primary document file does no longer match with secondary report report, the be a part of takes area.
Question 153. Is It Possible To Create A Physical File Without Dds?
Answer :
Yes. With the help of CRTPF we are able to achieve this. But we must supply report period.
Question 154. What Is A Keyed Physical File?
Answer :
Defining a discipline as a key in bodily file. Hence we are able to get admission to facts via the key subject.
Question a hundred and fifty five. What Is A Composite Key?
Answer :
Defining more than one key as a key discipline in physical report.
Question 156. What Is Logical File?
Answer :
A Logical record is an Access route to the Physical File.
Question 157. How Can You Specify No Duplicate Key?
Answer :
By defining the precise key.
Question 158. What Is The Command To Know How Many Lf Are Related To A Pf?
Answer :
DSPDBR (Display Database Relationship)
Question 159. What Is The Command To Know Key Fields Of File?
Answer :
DSPFD (F4) *ACCPTH(Access Path).
Question a hundred and sixty. What Is A Join Logical File?
Answer :
A be part of Logical File can be built over the 2 PF’s, with the PF’s ‘joined’ with the aid of a common key fee. It is to be had for read get right of entry to.
Question 161. Can A Join Logical File Be Updated?
Answer :
No.
Question 162. Using Dfu, User Will Be Able To ___________ From Physical File?
Answer :
Add/Update/Selected or all fields.
Question 163. What Is The Difference Between Normal Upddta To Pf And Updating Using Dfu Program?
Answer :
Both are equal only distinction is DFU allows you to feature or alternate selected fields.
Question 164. What Is Library?
Answer :
A library is a machine object that serves as a listing to other items or collection of item.
Question 165. What Is Library List?
Answer :
A process’s library listing defines the direction of libraries that the job follows whilst looking to find applications, files or other As/400 gadgets.
Question 166. Difference Between Source Physical File & Physical File?
Answer :
Source Physical File includes participants who include supply statements & Physical File contains contributors, which contain facts.
Question 167. What Is The Object Type Of Pf, Lf, Printer File & Display File?
Answer :
*File
Question 168. What Are The Different Methods To Access Seu?
Answer :
Use the Start Source Entry Utility command (STRSEU) Option eight from STRPGMMNU Through Program Development Manager (PDM)
Question 169. Which Are The Member Types Which Seu Supports?
Answer :
RPG, CL, PF, LF, PRTF & DSPF.
Question one hundred seventy. In Which Specs Arrays, Tables & Constants Are Defined?
Answer :
In I Specs.
Question 171. What Is A Spool File?
Answer :
Printed output items placed in an output queue are known as spooled files.
Question 172. How Many Specs Are There In Rpg & Which Are They?
Answer :
There are 7 Specs in RPG they're H, F, E, L, I, C & O.
Question 173. What Is The Difference Between Goto & Exsr?
Answer :
EXSR is a conditional branching at the same time as a GOTO is an unconditional branching.
Question 174. Difference Between Ca & Cf?
Answer :
CA: - It does not retains the fee into the buffer reminiscence. CF: - It retains the cost into the buffer memory.
Question 175. What Does Exfmt Does?
Answer :
Write & Read.
Question 176. What Does The Ovrdbf Command Do?
Answer :
It overrides the PF briefly for a process.
Question 177. How Does The Runqry Show The Output?
Answer :
RUNQRY shows the output constantly in RRN (Relative Record Number) & not in keyed sequence.
Question 178. How Many Printer Files Maximum Can Be Used In Single Rpg Program?
Answer :
8 because of the overflow signs OA-OG & OV.
Question 179. When You Are Defining A Flat File In Your Program In F Specs Which Format Will You Specify?
Answer :
Flat File: - F (Fixed Length) Other File: - E (Externally Described)
Question a hundred and eighty. Difference Between Skip Before & Space Before?
Answer :
Skip before leaves the specified no. Of strains moving to the next page even as Space earlier than leaves the specified no. Of strains on that web page.
Question 181. Which Indicator Is Used For Read?
Answer :
EQ (Equal to)
Question 182. How Many Types Of Display Are Available On As/four hundred For User Interaction?
Answer :
four Types they're Entry, Menu, Information & List Display.
Question 183. What Are The Basic Features Of Seu?
Answer :
Prompt relying upon type, shows proper hand side date & left hand aspect the road range.
Question 184. Which Are The Figurative Constants Used In Rpg?
Answer :
*ZERO,*BLANK, *ZEROS, *BLANKS, *HIVAL, *LOVAL, *OFF, *ON & *ALL.
Question 185. What Is The Syntax For Plist?
Answer :
*ENTRY PLIST PARM
Question 186. What Are Indicators?
Answer :
Indicators are in-built magnificence of variables for RPG.
Question 187. What Is Cab?
Answer :
It compares Factor1 with Factor2 & if condition is true, manage is transferred to label unique inside the end result subject. The label special ought to appear as the Factor1 of a TAG operation somewhere within the program.
Question 188. Which Are The Relational Operators In Rpg?
Answer :
GT, GE, LT, LE & EQ.
Question 189. In 'o' Specs What Is The Opcode For Write?
Answer :
EXCPT.
Question 190. What Does Lokup Does In Tables & Arrays?
Answer :
The LOKUP opcode searches the Factor1 entry in table or array.
Question 191. File Access Opcodes?
Answer :
READ, SETLL, SETGT, READE, READP, READPE CHAIN, KLIST, KFLD, EXCPT & WRITE.
Question 192. What Is Rpg Fixed Logic Cycle?
Answer :
A logic the compiler components is referred to as RPG Fixed Logic Cycle.
Question 193. Difference Between Interactive & Batch Job?
Answer :
Batch activity starts, runs & maintains to execute instructions with out human intervention or manage whilst.
Interactive process are person driven.
Question 194. How Can We Run A Batch Job?
Answer :
SBMJOB Command.
Question 195. What Is Arrival Sequence?
Answer :
The data may be accessed the way wherein data are brought to physical record.
Question 196. How Many Specifications Are There In Rpg/four hundred? What Are They?
Answer :
There are seven specifications exits in RPG/400. They are listed under:
Header Specification
File Description specification
Extension specification
Line counter specification
Input specification
Calculation specification
Output specification
Question 197. When Do You Use F-spec. Continuation Line ?
Answer :
* In order to refer the named record layout as a subfile report format within the application.
* In order to rename the report layout of a database report in a application.
* In order to outline a named records shape as a file information statistics structure.
Question 198. What Are The Various Types Of Device Files?
Answer :
Display files, printer documents, discket documents, tape documents and so on. ,
Question 199. When Do You Explicitly Open Files And Close Files In An Rpg Program?
Answer :
If you specify the letter ' U ' at column seventy three-seventy four, you need to be open and close documents explicitly in a RPG software.
Question 200. How Do You Know That Records Are Locked?
Answer :
By the use of a command WRKOBJLCK.
Question 201. What Is The Purpose Of Indicators In Rpg?
Answer :
In order to manipulate the logic go with the flow, we will use indicators in RPG.
Question 202. How Do You Read Data Area In An Rpg Program?
Answer :
With the assist of 'IN' opcode, we are able to access the information vicinity record in to this system.
Question 203. What Are The Different Types Of Data Areas?
Answer :
The exceptional kinds of Data Areas are widespread information location, neighborhood facts area, organization data region, pip (program initialization parameter facts region) statistics place.
*General Data Area - It can be created by user implicitely or explicitly
It can be referred by using any other jobs.
It can be related to a library.
It may be created, deleted through the consumer.
* Local Data Area - It can't be referred through some other task.
It is robotically created and deleted by way of the machine.
It isn't associated with any library.
*Group Data Area - It is mechanically created and deleted with the aid of the system We can get admission to the institution records place fee thru clp.
It is meant for institution jobs.
*Pip Data Area - It is supposed for pre begin jobs.
Question 204. What Are Various Techniques To Pass Parameters From One Program To Another?
Answer :
PLIST, CALL, TFRCTL
Question 205. Which Single Rpg Opcode Performs Both Setll And Reade?
Answer :
CHAIN
Question 206. What Is Term Cua , Saa?
Answer :
Common User Access
System Application Architecture
Question 207. Why Is As/400 Called Object Oriented Machine?
Answer :
Everything at the AS/400 System that can be saved and retrieved is contained inside the item.
Question 208. What Is The Version Of Os/four hundred That We Have?
Answer :
V4R2 (Version four. Zero Release 2. Zero)
Question 209. What Is Ddm ?
Answer :
Distribution Data Management is a feature of the OS/four hundred that lets in an utility software or person on one system to apply database files stored on faraway device.
Question 210. What Is An Object?
Answer :
An object is any issue that exists in and occupies area in garage and on which operation may be performed.
Question 211. How Are The Objects Stored On As/400?
Answer :
All gadgets are saved on AS/four hundred in a unmarried level garage. In this method all items are referenced by one virtual deal with that is translated in to a bodily deal with whether or not it's miles an auxiliary storage or primary reminiscence.
Question 212. What Is A Library In As/four hundred?
Answer :
A library in AS/400 is an item that serve(acts) as a repository for other gadgets.
Question 213. Name Few Ibm Supplied Libraries?
Answer :
QGPL, QTEMP, QSYS, QUSRTOOL, QCBL, QRPG
Question 214. What Is Library List ?
Answer :
A listing that shows libraries used for the procedure and the order in which it has to be searched System identifies it in *LIBL.
Question 215. How Many Libraries Can Be There In Library List ?
Answer :
Total forty (15 system and 25 software)
Question 216. What Is Folder?
Answer :
A Folder is a named item this is used as a directory for files and different folders. Folders may be filed with in every other folder.
Question 217. Which Of The Following Operations Does Not Zero The Field Flda Defined As four,zero?
Answer :
C MOVE *ZEROS FLDA
C Z-ADD *ZEROS FLDA
C Z-ADD zero FLDA
C MOVE *ALL'zero' FLDA
C SUB FLDA FLDA
C MOVE '0000' FLDA
C CLEAR FLDA
C MOVE *BLANKS FLDA
The last education does NOT zero the field FLDA.
Question 218. How Would You Design The Process For A Nightly, High Volume Check Producing Process That Needs To Select Only Records That Are Flagged To Be Processed?
Answer :
With the assist of OPNQRYF Clp command, we are able to pick out the data from the information base record. The system includes following steps:
Steps: 1. OVRDBF with SHARE (*YES)
2. OPNQRYF
three. CALL the program
4. DLTOVR
5. CLOF
Question 219. Describe The Function Of Setll Operation In Rpg Language?
Answer :
The SETLL operation positions a report at the subsequent report with a key or relative record range that is more than or same to key or relative report number laid out in factor1.
Question 220. Describe The Function Of Setgt Operation In Rpg Language?
Answer :
The SETGT operation positions a document at the following report with a key or relative report number that is greater than key or relative file range specified in aspect 1.
Question 221. What Is The Purpose Of Level Check Parameter In A Physical File?
Answer :
Specifies whether the level identifiers of the report codecs in the bodily file are checked while the document is opened by using the program.
Question 222. Define A Job Queue?
Answer :
Job queues are queues of batch jobs waiting to be processed.
Question 223. Define A Output Queue?
Answer :
Output queues are queues of jobs waiting to be revealed.
Question 224. What Is The Function Of Cpysplf Command?
Answer :
It copies the spooled document to the facts base record.
Question 225. What Is The Function Of Cpyf Command?
Answer :
To reproduction the statistics f
