Explore topic-wise InterviewSolutions in .

SIMPLE LOGICAL FILE & PHYSICAL File.

Simple Logical File & Physical File.

*FILE

*FILE

true

true

LIST

LIST

F9

F9

BATCH & INTERACTIVE

Batch & Interactive

By calling QCMDEXC APPLICATION program interface we can execute a CL command with in an RPG program.

By calling QCMDEXC application program interface we can execute a CL command with in an RPG program.

It is special type of RPG/400 SUBROUTINE, which is executed AUTOMATICALLY at beginning of the program. It is a GOOD place to CODE initializes the VARIABLES.

It is special type of RPG/400 subroutine, which is executed automatically at beginning of the program. It is a good place to code initializes the variables.

To SHARE the open DATA PATH by various PROGRAMS in a same JOB.

To share the open data path by various programs in a same job.

To DEFINE FILES, to describe the files, to assign the files to SPECIFIED DEVICES.

To define files, to describe the files, to assign the files to specified devices.

SPECIFY an INDICATOR in POSITION 33-34 of F SPECIFICATION.

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

It is used in RPG PROGRAM Cycle to AUTOMATICALLY READ RECORDS in a cycle.

It is used in RPG Program Cycle to automatically read records in a cycle.

Yes.

Yes.

The FIELD name and LENGTH of the FIELDS are defined with in the RPG PROGRAM.

The field name and length of the fields are defined with in the RPG program.

All information about the FIELDS is specified in DDS and the RPG PROGRAM can use them with in the program.

All information about the fields is specified in DDS and the RPG program can use them with in the program.

Yes.

Yes.

Matching RECORD indicator is SETON when all the matching FIELDS in the record of a SECONDARY file MATCHES with all the matching fields of a record in a primary file.

Matching record indicator is seton when all the matching fields in the record of a secondary file matches with all the matching fields of a record in a primary file.

6 CHARACTERS.

6 Characters.

It is USED as LABEL.

It is used as Label.

TESTN

TESTN

TESTZ

TESTZ

PUT 'N' in POSITION 53 of C SPECS.

Put 'N' in position 53 of C specs.

The check OPERATION VERIFIES that each character in the base string (FACTOR 2) is among the character INDICATED in the comparator string (factor 1).

The check operation verifies that each character in the base string (factor 2) is among the character indicated in the comparator string (factor 1).

CALCULATION OPERATION is a PART of RPG SUBROUTINE.

Calculation operation is a part of RPG subroutine.

SCAN operation scans a character STRING (base string) contained in factor 2 for a substring (compare string ) contained in factor 1.

XLATE operation translates characters in SOURCE string (factor 2 ) to the from and to strings (factor 1 ) and put into the result FIELD.

SCAN operation scans a character string (base string) contained in factor 2 for a substring (compare string ) contained in factor 1.

XLATE operation translates characters in source string (factor 2 ) to the from and to strings (factor 1 ) and put into the result field.

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

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

USING EXCPT OPCODE.

Using EXCPT opcode.

The FREE OPERATION removes a PROGRAM from the list of activated programs, frees STATIC storage and ensures program INITIALIZATION (first cycle processing) the NEXT time program is called. It does not close file or unlock data area.

The FREE operation removes a program from the list of activated programs, frees static storage and ensures program initialization (first cycle processing) the next time program is called. It does not close file or unlock data area.

PUTS INFORMATION in INFDS.

Puts information in INFDS.

The physical file you are working with very large, CREATING and using a LOGICAL file will allow an application to perform faster than using an open query file. Since access paths created by open query files are temporary, APPLICATIONS that use an access path FREQUENTLY will be more EFFICIENT using a logical file, since the access path will not have to be rebuilt every time the file is open.

The physical file you are working with very large, creating and using a logical file will allow an application to perform faster than using an open query file. Since access paths created by open query files are temporary, applications that use an access path frequently will be more efficient using a logical file, since the access path will not have to be rebuilt every time the file is open.

This is a file LEVEL keyword USED in a logical file. If you specify this in a file level, the system doesn't PERFORM record SELECTION until the program reads file. Then on the Select/Omit criteria, it selects the records from the SPECIFIED file.

This is a file level keyword used in a logical file. If you specify this in a file level, the system doesn't perform record selection until the program reads file. Then on the Select/Omit criteria, it selects the records from the specified file.

* Divide a FIELD in to sub fields
* CHANGE the FORMAT of a field
* Group non-contiguous data in a contiguous format
* DEFINE an AREA of storage in more than one format
* Define Multiple occurrences of data structures.

* Divide a field in to sub fields
* Change the format of a field
* Group non-contiguous data in a contiguous format
* Define an area of storage in more than one format
* Define Multiple occurrences of data structures.

Data structures are specified in the Input specifications of an RPG/400 program to DEFINE an AREA in STORAGE and layouts of related SUB FIELDS.

Data structures are specified in the Input specifications of an RPG/400 program to define an area in storage and layouts of related sub fields.

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.

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.

WRKQRY

WRKQRY

QBATCH, QINTER, QSPL, QCMN, QCTL, QBASE.

QBATCH, QINTER, QSPL, QCMN, QCTL, QBASE.

SUBSYSTEM is NOTHING but it provides specialized environment to COMPLETE the EXECUTION of jobs.

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

To CREATE the REPLICA from the ORIGINAL OBJECT.

To create the replica from the original object.

To COPY the DATA from the ONE FILE to ANOTHER.

To copy the data from the one file to another.

It COPIES the spooled FILE to the DATA BASE file.

It copies the spooled file to the data base file.

OUTPUT QUEUES are queues of JOBS WAITING to be PRINTED.

Output queues are queues of jobs waiting to be printed.

With the help of OPNQRYF Clp COMMAND, we can select the records from the DATA base file. The process involves following steps:
Steps: 1. OVRDBF with SHARE (*YES)
2. OPNQRYF
3. CALL the program
4. DLTOVR
5. CLOF

With the help of OPNQRYF Clp command, we can select the records from the data base file. The process involves following steps:
Steps: 1. OVRDBF with SHARE (*YES)
2. OPNQRYF
3. CALL the program
4. DLTOVR
5. CLOF

C MOVE *ZEROS FLDA
C Z-ADD *ZEROS FLDA
C Z-ADD 0 FLDA
C MOVE *ALL'0' FLDA
C SUB FLDA FLDA
C MOVE '0000' FLDA
C CLEAR FLDA
C MOVE *BLANKS FLDA
The LAST instruction does NOT ZERO the field FLDA.

C MOVE *ZEROS FLDA
C Z-ADD *ZEROS FLDA
C Z-ADD 0 FLDA
C MOVE *ALL'0' FLDA
C SUB FLDA FLDA
C MOVE '0000' FLDA
C CLEAR FLDA
C MOVE *BLANKS FLDA
The last instruction does NOT zero the field FLDA.

TOTAL 40 (15 system and 25 APPLICATION)

Total 40 (15 system and 25 application)

A list that indicates libraries USED for the process and the ORDER in which it has to be SEARCHED System IDENTIFIES it in *LIBL.

A list that indicates libraries used for the process and the order in which it has to be searched System identifies it in *LIBL.

QGPL, QTEMP, QSYS, QUSRTOOL, QCBL, QRPG

QGPL, QTEMP, QSYS, QUSRTOOL, QCBL, QRPG

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.

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.

V4R2 (VERSION 4. 0 RELEASE 2. 0)

V4R2 (Version 4. 0 Release 2. 0)

EVERYTHING on the AS/400 SYSTEM that can be stored and RETRIEVED is CONTAINED in the object.

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

COMMON USER Access
System APPLICATION Architecture

Common User Access
System Application Architecture