Explore topic-wise InterviewSolutions in .

DEFINING a FIELD as a KEY in physical file. Hence we can access records through the key field.

Defining a field as a key in physical file. Hence we can access records through the key field.

YES. With the help of CRTPF we can ACHIEVE this. But we have to GIVE record LENGTH.

Yes. With the help of CRTPF we can achieve this. But we have to give record length.

If you specify JDFTVAL at file LEVEL, EVEN the PRIMARY file record does not match with secondary file record, the join TAKES PLACE.

If you specify JDFTVAL at file level, even the primary file record does not match with secondary file record, the join takes place.

ZONED DECIMAL

Zoned decimal

PACKED DECIMAL

Packed decimal

PACKED decimal : One digit OCCUPIES 1 byte.
Zoned decimal : One digit occupies 2 bytes.

Packed decimal : One digit occupies 1 byte.
Zoned decimal : One digit occupies 2 bytes.

S, O are to defined at key field level. The purpose Select/Omit LOGIC is depends on the criteria (CONDITION) given at the key field level (At function ENTRY) it selects and omits the records. The S/O is ALLOWED in Logical FILE only.

S, O are to defined at key field level. The purpose Select/Omit logic is depends on the criteria (condition) given at the key field level (At function entry) it selects and omits the records. The S/O is allowed in Logical file only.

It will AVOID to enter DUPLICATE KEY VALUES. We have to DEFINE it in a file level.

It will avoid to enter duplicate key values. We have to define it in a file level.

FOUR LEVELS. They are File level, RECORD level, Field level, KEY field level.

Four levels. They are File level, Record level, Field level, Key field level.

PFILE (which is RECORD LEVEL KEYWORD)

PFILE (which is record level keyword)

It only PROVIDES logical view based on the PHYSICAL FILE. This is also called as REGULAR logical file.

It only provides logical view based on the physical file. This is also called as regular logical file.

JDFTVAL, JFILE, JOIN, JFLD, JREF.

JDFTVAL, JFILE, JOIN, JFLD, JREF.

JOIN LOGICAL FILE joins more than one file. The maximum of number of files allowed to join is 32 (THIRTY TWO).

Join logical file joins more than one file. The maximum of number of files allowed to join is 32 (thirty two).

It is nothing but a LOGICAL view PROVIDED by the physical file.

It is nothing but a logical view provided by the physical file.

PHYSICAL FILE nothing but a table contains a only ONE record format in which we can DESCRIBE the field definitions and DESCRIPTIONS.

Physical file nothing but a table contains a only one record format in which we can describe the field definitions and descriptions.

In 'EQ' POSITION.

In 'EQ' position.

250 (TWO HUNDRED and FIFTY )

250 (Two hundred and Fifty )

50 (Fifty INCLUDING EIGHT PRINTER FILE)

50 (Fifty including eight printer file)

254 (TWO HUNDRED and FIFTY FOUR)

254 (Two hundred and fifty four)

43 (FORTY THREE)

43 (Forty three)

255 (TWO HUNDRED and FIFTY FIVE)

255 (Two hundred and fifty five)

8000 (EIGHT THOUSAND)

8000 (eight thousand)

1024 (ONE THOUSAND and TWENTY FOUR)

1024 (One thousand and twenty four)

USE this field level KEYWORD with PUTOVR keyword to override the existing the data contents of a field ALREADY on the DISPLAY.

Use this field level keyword with PUTOVR keyword to override the existing the data contents of a field already on the display.

If you specify SETON LR, all the files USED in program will be CLOSED.
If you specify RETRN, all the files used in program will remain OPEN.

If you specify SETON LR, all the files used in program will be closed.
If you specify RETRN, all the files used in program will remain open.

SFLMSGRCD, SFLMSGKEY, SFLPGMQ

SFLMSGRCD, SFLMSGKEY, SFLPGMQ

Use this record-level keyword to permit the override of either DISPLAY file attributes or data contents of SPECIFIC fields within a record displayed on the WORK STATION device.

Use this record-level keyword to permit the override of either display file attributes or data contents of specific fields within a record displayed on the work station device.

MESSAGE subfile is special FILE contains multiple messages TAKEN from PROGRAM message queue and placed in message sub file for display on the screen.

Message subfile is special file contains multiple messages taken from program message queue and placed in message sub file for display on the screen.

With the help of File Information Data Structure, we can check EXISTENCE of RECORDS in a physical file. The code is described below: In File description CONTINUATION line (IPFK), KINFDS RCDS IRCDS DS I *RECORD #RCDS with the above code we can check the existence of records in a file WITHOUT causing I/O operation.

With the help of File Information Data Structure, we can check existence of records in a physical file. The code is described below: In File description continuation line (IPFK), KINFDS RCDS IRCDS DS I *RECORD #RCDS with the above code we can check the existence of records in a file without causing I/O operation.

If you SPECIFY the ITER, the GROUPS of statements are allowed to execute repeatedly.

If you specify the ITER, the groups of statements are allowed to execute repeatedly.

If you SPECIFY LEAVE, the CONTROL TRANSFERS to the STATEMENT below the ENDDO.

If you specify LEAVE, the control transfers to the statement below the ENDDO.

DOWXX : If the condition becomes true, then only the GROUP of INSTRUCTIONS ALLOWED executing.
DOUxx : Irrespective of condition, it will execute at LEAST one time.

DOWxx : If the condition becomes true, then only the group of instructions allowed executing.
DOUxx : Irrespective of condition, it will execute at least one time.

To CONCATENATE the two STRINGS by placing a SINGLE blank in a RESULTANT.

To concatenate the two strings by placing a single blank in a resultant.

To CONCATENATE the TWO STRINGS into a ONE STRING.

To concatenate the two strings into a one string.

To EXTRACT the INFORMATION from the SPECIFIED STRING.

To extract the information from the specified string.

RCVF command used to receive the RECORDS either from the data base FILE or DEVICE file.

RCVF command used to receive the records either from the data base file or device file.

STRDBG(for BATCH JOBS), STRISDB.

STRDBG(for batch jobs), STRISDB.

UDATE SUPPORTS two-digit YEAR. The FORMAT is *MDY (MMDDYY).
*DATE (system date) supports FOUR digit year. The format is *MDYY (MMDDYYYY).

UDATE supports two-digit year. The format is *MDY (MMDDYY).
*DATE (system date) supports four digit year. The format is *MDYY (MMDDYYYY).

Data queues provides communication between programs by calling API's QSNDDTAQ and QRCVDTAQ along with parameters LIKE data queue NAME, library in which data queue exists, VARIABLE to store the number of characters to be SENT, variable to store the information to be sent. We can send the same data queue to the many programs.

Data queues provides communication between programs by calling API's QSNDDTAQ and QRCVDTAQ along with parameters like data queue name, library in which data queue exists, variable to store the number of characters to be sent, variable to store the information to be sent. We can send the same data queue to the many programs.

Data AREA is a storage area to STORE limited information.
Example: a NEW and unique customer number is generated whenever a new customer is added to customer master file. Data area keeps track of LAST record added and ADD 1 to it. Through program we can access new customer number.

Data area is a storage area to store limited information.
Example: a new and unique customer number is generated whenever a new customer is added to customer master file. Data area keeps track of last record added and add 1 to it. Through program we can access new customer number.

To DESIGN & PROTOTYPE a REPORT.

To design & prototype a report.

REPORT LINE, FILLER line & SAMPLE line.

Report line, Filler line & Sample line.

Use SFLROLVAL KEYWORD in DDS along with the NUMBER, which specifies the number of records to scroll at a TIME.

Use SFLROLVAL keyword in DDS along with the number, which specifies the number of records to scroll at a time.

Seton SFLNXTCHG KEYWORD indicator and update the SUBFILE RECORD.

Seton SFLNXTCHG keyword indicator and update the subfile record.

SFLPAG : it is an attribute which SPECIFIES the NUMBER of RECORDS that can be DISPLAYED in a screen.

SFLSIZ : it is an attribute which specifies the number of records can be stored in the subfile.

SFLPAG : it is an attribute which specifies the number of records that can be displayed in a screen.

SFLSIZ : it is an attribute which specifies the number of records can be stored in the subfile.

Not POSSIBLE.

Not possible.

MOVE a VALID relative RECORD number(RRN) in the field specified USING SFLRCDNBR keyword in DDS.

Move a valid relative record number(RRN) in the field specified using SFLRCDNBR keyword in DDS.

READ, READC, CHAIN,UPDAT and WRITE

READ, READC, CHAIN,UPDAT and WRITE

12

12

24

24