Explore topic-wise InterviewSolutions in .

FILE LEVEL, RECORD level & FIELD level.

File level, Record level & Field level.

Define CURSOR ,DECLARE Cursor ,OPEN Cursor ,FETCH record ,Processing ,Close Cursor

Define Cursor ,Declare Cursor ,Open Cursor ,Fetch record ,Processing ,Close Cursor

View will not any data.. It only shows a data from table while Index has a Indexing Data for a sequence on which Index is created. View is similar to LOGICAL file without having Key and Index is similar to Logical File having Key (as keyed logical file has access PATH data) Table is similar to PF.

View will not any data.. It only shows a data from table while Index has a Indexing Data for a sequence on which Index is created. View is similar to Logical file without having Key and Index is similar to Logical File having Key (as keyed logical file has access path data) Table is similar to PF.

USING SINGLE STATEMENT.
SELECT * FROM FILE1, FILE2
WHERE FILE1.FLD1 = FILE2.FLD1

Using Single statement.
SELECT * FROM FILE1, FILE2
WHERE FILE1.FLD1 = FILE2.FLD1

Two types of Cursor
SIMPLE / Serial Cursor
A serial cursor is ONE DEFINED without SCROLL key word
For serial cursor each row is fetched only once per OPEN When it is opened it is positioned before the first row in the table.
To use serial cursor we have to re-issue OPEN

Scrollable Cursor which is defined with SCROLL key word.
Cursor defined with SCROLL key word
Rows of cursor can be fetched many times
When it is opened it is positioned before the first row in the table.
When the FETCH is issued , the cursor is positioned to the row of the table that is specified by the POSITION option. (FIRST, LAST, PREV, NEXT, RELATIVE)

Two types of Cursor
Simple / Serial Cursor
A serial cursor is one defined without SCROLL key word
For serial cursor each row is fetched only once per OPEN When it is opened it is positioned before the first row in the table.
To use serial cursor we have to re-issue OPEN

Scrollable Cursor which is defined with SCROLL key word.
Cursor defined with SCROLL key word
Rows of cursor can be fetched many times
When it is opened it is positioned before the first row in the table.
When the FETCH is issued , the cursor is positioned to the row of the table that is specified by the POSITION option. (FIRST, LAST, PREV, NEXT, RELATIVE)

With the HELP of Validity check KEY words VALUE, RANGE, COMP

With the help of Validity check key words VALUE, RANGE, COMP

With the help of COMMAND attention KEY we can pass only the indicator status to PROGRAM not the data from screen. While command FUNCTION key passes indicator status as well as a data from screen to program.

With the help of Command attention key we can pass only the indicator status to program not the data from screen. While command function key passes indicator status as well as a data from screen to program.

RSTDSP is a PARAMETER to be SPECIFIED at compile TIME for DISPLAY file.

RSTDSP is a parameter to be specified at compile time for display file.

It ALLOWS a record format to be DISPLAYED on screen RETAINING the PREVIOUS displayed record formats.

It allows a record format to be displayed on screen retaining the previous displayed record formats.

With the help of RTNCSRLOC KEYWORD, here we need to define a FIELD to get ROW and column. Length of variable should be 5,0 fixed We can SPECIFY *FILED for filed *REC for RECORD on which a key is pressed.

With the help of RTNCSRLOC keyword, here we need to define a field to get row and column. Length of variable should be 5,0 fixed We can specify *FILED for filed *REC for Record on which a key is pressed.

Define a filed in a DSPF of USE HIDDEN.(H)

Define a filed in a DSPF of use HIDDEN.(H)

We must DEFINE ERROR message RECORD format (SFLMSG). And a Program Queue. (PGMQ) and Record format is associated to a line number.

We must define error message record format (SFLMSG). And a Program Queue. (PGMQ) and Record format is associated to a line number.

EDTCDE & EDTWRD are key words USED for formatting purpose. EDTCDE cannot be applied to Character filed. And EDTCDE has some CODES pre-DEFINED for example,

EDTCDE(Z) – for suppressing the leading zero Y – for DATE field.
EDTWRD can be used to define user defined formatting for a fields.

EDTCDE & EDTWRD are key words used for formatting purpose. EDTCDE cannot be applied to Character filed. And EDTCDE has some Codes pre-defined for example,

EDTCDE(Z) – for suppressing the leading zero Y – for date field.
EDTWRD can be used to define user defined formatting for a fields.

By using the standard BUILT In Expressions like %FOUND,%EOF, NOT %EOF, %BOF, NOT %BOF…etc.
Display / PRINTER FILE

By using the standard Built In Expressions like %FOUND,%EOF, NOT %EOF, %BOF, NOT %BOF…etc.
Display / Printer File

Program CRASHES, as in case of *ISO format it REQUIRED FIELDS of 4,2,2.

Program crashes, as in case of *ISO format it required fields of 4,2,2.

YYYY-MM-DD for other formats REFER to IBM manual or ERIS DOCUMENT.

YYYY-MM-DD for other formats refer to IBM manual or ERIS document.

A Service PROGRAM is a collection of RUNNABLE procedures and available data items EASILY accessible by other ILE programs. In many respects it is similar to a subroutine library and procedure library.

A service program differs from a program in two ways:

It does not contain a program entry procedure. This means that you cannot call a service program using the CALL OPERATION.

A service program is bound into a program or other service programs using binding by REFERENCE.

A Service Program is a collection of runnable procedures and available data items easily accessible by other ILE programs. In many respects it is similar to a subroutine library and procedure library.

A service program differs from a program in two ways:

It does not contain a program entry procedure. This means that you cannot call a service program using the CALL operation.

A service program is bound into a program or other service programs using binding by reference.

We can not TRACE out at which POINT the VALUE of VARIABLE is CHANGED.

We can not trace out at which point the value of variable is changed.

Declare a variable with key WORD EXPORT and while USING this variable in anther program declare with IMPORT KEYWORD.

Declare a variable with key word EXPORT and while using this variable in anther program declare with IMPORT keyword.

Procedure Prototype
In this section we specify the name of the procedure along with PR.
D PROC1 PR
Procedure INTERFACE
It is section where we define all the parameter which are RECEIVING or returning some VALUES.
D PROC1 PI 5 0
D PARMA 5 0
D PARMB 5 0

Procedure Prototype
In this section we specify the name of the procedure along with PR.
D PROC1 PR
Procedure Interface
It is section where we define all the parameter which are receiving or returning some values.
D PROC1 PI 5 0
D PARMA 5 0
D PARMB 5 0

A procedure is the set of self contained HIGH LEVEL LANGUAGE STATEMENTS that can perform a particular task and then returns to a caller.

A procedure is the set of self contained high level language statements that can perform a particular task and then returns to a caller.

It just SIMILAR to any other SUBROUTINE.
*PSSR BEGSR
………………
………………
…………….
ENDSR

It just similar to any other subroutine.
*PSSR BEGSR
………………
………………
…………….
ENDSR

OVRDBF

OVRDBF

MONMSG

MONMSG

We can Insert/Update/Delete RECORDS, FETCH records, fetch VALUES from records into VARIABLES.

We can Insert/Update/Delete records, fetch records, fetch values from records into variables.

To define & NAME the cursor & SPECIFY rows to be FETCHED.

To define & name the cursor & specify rows to be fetched.

6(MAXIMUM)

6(Maximum)

INSERT, UPDATE & DELETE.

Insert, Update & Delete.

During INSERT.

During Insert.

INSERT, UPDATE Delete & File ENQUIRY.

Insert, Update Delete & File Enquiry.

DSPDBR

DSPDBR

HOST VARIABLE

Host Variable

8

8

50

50

O SPECIFICATION.

O Specification.

You can not use CL program to ADD or UPDATE records in database files.
Use Printer or ICF files.
Use Program described files.
Use the concept of subfile (to display more than one RECORD), but a single output MESSAGE subfile is a special TYPE of subfile that is SUPPORTED well in CL.
Use subroutines.
You cannot declare more than one object (file) in a CL programme.

You can not use CL program to ADD or UPDATE records in database files.
Use Printer or ICF files.
Use Program described files.
Use the concept of subfile (to display more than one record), but a single output message subfile is a special type of subfile that is supported well in CL.
Use subroutines.
You cannot declare more than one object (file) in a CL programme.

Logical which uses FIELDS from TWO or more PHYSICAL FILES.

Logical which uses fields from two or more physical files.

USING PARM KEYWORD.

Using PARM keyword.