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