Important AS400 Interview Questions Part – 2
How To See All Record Formats Used In A File?
By using the command shown below:
DSPFD FILE(IROBO1/QRPGLESRC) TYPE(*RCDFMT)
How To See All Members Of A File?
By using the command shown below:
DSPFD FILE(IROBO1/QRPGLESRC) TYPE(*MBRLIST)
What Is Source Physical File?
Source physical file is a file which contains the sources of different types of objects. There can be up to 32768 members. Source physical file is an object. But the source member is not an object. When we compile the member, the object is created for that source. Command used is CRTSRCPF.
CRTSRCPF FILE(IROBO1/QRPGSRC) RCDLEN(112) TEXT(‘SOURCE PHYSICAL FILE’)
Is Qgpl A User Library Or System Library?
It’s a user library.
What Is Library Is As400? What Are The Types Of Library?
When we execute a command or call a program, the AS/400 must know where to find the command or program and the answer is library. A Library is a collection of objects.
QSYS is the only library that contains other library. QSYS is the root library where the entire user defined/ system defined library is created. System supplied libraries begin with the letter “Q” or “#”.
Library list types:
System library:
All IBM supplied library e.g. QSYS, QHLPSYS, QUSRSYS…
Product Library:
Whenever Ibm product is used it is added to the library automatically and is removed itself when the job completes.
Current Library:
Current library is the working library i.e. all the work done by you is stored in current library.
User Library:
Non-IBM supplied i.e. created by the user.
What Is The Use Of L Specs In Rpg?
Line counter specification can be used to describe printer file to indicate the length of the form and number of lines per page.
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.
What Is The Use Of E Specification In Rpg?
Extension Specs describes all record address files, arrays and tables.
Specify Different Indicators Used In Rpg?
Overflow indicators
Record Identifying Indicators
Field Indicators
Resulting Indicators
Control Level Indicators
When Will Dump And Debug Opcodes Be Ignored?
If blank is specified in position 15 of H specs.
What Is The Use Of Header Specification In Rpg/400?
It identifies by H in column 6, provides informaion about generating and running programs.
What Is The Maximum Length Of A Variable Name In Cl?
Maximum 11 characters (including ‘&’)
How To Trap Errors In Cl?
By using Monitor Message Command (MONMSG)
What Are The Different Types Of Messages In Cl?
Immediate message, Break message, Program message, User message
What Is Difference Between Cat, Tcat, Bcat?
CAT –
Concatenate two variables or constants into one continuous string.
BCAT –
Truncates all trailing blanks in the first character string, one blank is inserted, then the two character strings are concatenated.
TCAT –
Truncates all trailing blanks in the first character string, the two character strings are concatenated.
What Are The Different Types Of Keywords In Display Files?
File level, Record format level, Field level
When Would The All Keyword Be Used?
Use with Select or Omit, to select/omit records.
Can Fields Be Concatenated Ina Logical File Level?
Yes. by using CONCAT keyword
What Is The Select And Omit Criteria In Logical File?
This is used to specify rules for the Selection/Omission of records from a Physical File.
What Is Multiformat Logical File?
Logical which uses fields from two or more physical files.
What Are The Valid User Defined Data Area Types?
CHAR, NUMERIC and LOGICAL
Define A Batch Job?
A user request the job.
The job is created (job name is assigned, job attributes are allocated)
The job is placed on a job queue
The sub system QBATCH takes the job from job queue and starts it.
Output generated by the batch job is placed on an output queue.
The spool sub system prints the output on the output queue.
Describe About Query/400?
Query/400 is a licensed program that uses a query to analyze and select the information contained in the data base files and create a query report.
A query report can be:
displayed on a workstation (screen)
printed
stored in another database file.