Explore topic-wise InterviewSolutions in .

C KEY CHAIN FILE N 99.If you specify 'N' in 53rd position, the record will not be locked if you TRY to READ the locked record. It is a way of AVOIDING the record lock.

C KEY CHAIN FILE N 99.If you specify 'N' in 53rd position, the record will not be locked if you try to read the locked record. It is a way of avoiding the record lock.

You SPECIFY the indicators OA through OG and OV in 33 - 34 columns in a printer file. This indicator AUTOMATICALLY set on whenever overflow OCCURS on a type of page.

You specify the indicators OA through OG and OV in 33 - 34 columns in a printer file. This indicator automatically set on whenever overflow occurs on a type of page.

If you try to READ the locked record, we can get system defined message i. E. , the program will ended abnormally. With the HELP of File Information Data STRUCTURE we can handle record lock situation. Generally it will happen, when the same file of type " U" USED in different programs.

If you try to read the locked record, we can get system defined message i. e. , the program will ended abnormally. With the help of File Information Data Structure we can handle record lock situation. Generally it will happen, when the same file of type " U" used in different programs.

It is the most DESIRABLE METHOD in building a REAL TIME applications. We can use at all the times.

It is the most desirable method in building a real time applications. We can use at all the times.

Using this, we can MAKE specified SUBFILE RECORD FORMAT inactive.

Using this, we can make specified subfile record format inactive.

SFLCLR : It clears the subfile.

SFLINZ : FIRST it clears the subfile and initiliazing the NUMERIC variables with zeros and ALPHANUMERIC variables with CHARACTERS.

SFLCLR : It clears the subfile.

SFLINZ : First it clears the subfile and initiliazing the numeric variables with zeros and alphanumeric variables with characters.

DEC, CHAR, LGL

DEC, CHAR, LGL

Subfile RECORD is DEFINED by SFL KEYWORD, where as Message subfile is defined by SFLMSG keyword.

Subfile record is defined by SFL keyword, where as Message subfile is defined by SFLMSG keyword.

USING SFLDROP KEYWORD.

Using SFLDROP keyword.

By SPECIFYING this keyword, the Bottom/More MESSAGE could be DISPLAYED at end of SCREEN.

By specifying this keyword, the Bottom/More message could be displayed at end of screen.

Seton SFLNXTCHG KEYWORD indicator and UPDATE the SUBFILE record.

Seton SFLNXTCHG keyword indicator and update the subfile record.

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.

Use SFLROLVAL KEYWORD in DDS ALONG with number, which specifies the number of RECORDS to scroll at a TIME.

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

YES, by USING SFLLIN KEYWORD.

Yes, by using SFLLIN keyword.

12

12

24

24

512

512

SUBFILE record FORMA (SFL), and subfile CONTROL record forma (SFLCTL).

Subfile record forma (SFL), and subfile control record forma (SFLCTL).

Subfile RECORD Format, Subfile Control Record Format, Relative Record NUMBER, Subfile Record Number, ASSOCIATED Subfile Keywords.

Subfile Record Format, Subfile Control Record Format, Relative Record Number, Subfile Record Number, Associated Subfile Keywords.

Subfile is group of RECORDS of same RECORD FORMAT and can be read from or WRITE to the DISPLAY in a single operation.

Subfile is group of records of same record format and can be read from or write to the display in a single operation.

OVERLAY

OVERLAY

Immediately DISPLAY a RECORD FORMAT without waiting for the NEXT I/O operation.

Immediately display a record format without waiting for the next I/O operation.

No RECORDS will be DISPLAYED until there is any I/O OPERATION.

No records will be displayed until there is any I/O operation.

KEEP: Keep the display from being deleted when the display file is closed.

ASSUME: It is used to specify that the OS/400 PROGRAM is to assume that this record is already SHOWN on the display when this file is OPENED.

KEEP: Keep the display from being deleted when the display file is closed.

ASSUME: It is used to specify that the OS/400 program is to assume that this record is already shown on the display when this file is opened.

This File-level keyword is used to remove option and response indicators from the BUFFER and PLACES them in 99-byte SEPARATE INDICATOR area.

This File-level keyword is used to remove option and response indicators from the buffer and places them in 99-byte separate indicator area.

PUTOVR KEYWORD MUST USED.

PUTOVR keyword must used.

By USING MSGCON (MESSAGE CONSTANT) KEYWORD.

By using MSGCON (message constant) keyword.

1.OVRDTA keyword (field or record level) can be USED to OVERRIDE the existing DATA contents of a field or record already on the DISPLAY.
2.OVRATA keyword (field or record level) can be used to override the existing display attributes of a field or record already on the display.

1.OVRDTA keyword (field or record level) can be used to override the existing data contents of a field or record already on the display.
2.OVRATA keyword (field or record level) can be used to override the existing display attributes of a field or record already on the display.

YES, through CHKMSGID KEYWORD.

Yes, through CHKMSGID keyword.

CSRLOC GAINS PRIORITY.

CSRLOC gains priority.

SETS on the MODIFIED Data TAG of the field. The Data Tag DETECT whether the field has been changed as a result of user input.

Sets on the modified Data Tag of the field. The Data Tag detect whether the field has been changed as a result of user input.

The RESULT is same as if you had SPECIFIED ND.

The result is same as if you had specified ND.

Attach the MDT (MODIFIED data tag) ATTRIBUTE to the FIELD, to DETECT whether field has been changed as a RESULT of user input.

Attach the MDT (modified data tag) attribute to the field, to detect whether field has been changed as a result of user input.

1024

1024

CALL performs INTERACTIVELY JOB while SBMJOB performs batch job.

CALL performs interactively job while SBMJOB performs batch job.

VALID COMMAND KEY.

Valid Command Key.

There is some PROBLEM with SUBSYSTEM.

There is some problem with subsystem.

CHANGE the PRIORITY or RENAME the JOB.

Change the priority or rename the job.

1.Dividing a FIELD into SUB fields.
2.Changing the format of a field.
3.Grouping non-contiguous DATA in a contiguous format.
4.Defining an AREA of STORAGE in more than 1 format.

1.Dividing a field into sub fields.
2.Changing the format of a field.
3.Grouping non-contiguous data in a contiguous format.
4.Defining an area of storage in more than 1 format.

FIELD & RECORD

Field & Record

1

1

UNION FILE

Union File

1 RECORD FORMAT for each PF

1 Record format for each PF

DATA DESCRIPTION SPECIFICATION

Data Description Specification

Members are SEPARATE entities within a DATABASE FILE & they are COMPONENTS of As/400 object.

Members are separate entities within a database file & they are components of As/400 object.

3

3

L1 – L9.

L1 – L9.

TESTN, SCAN, CHECK, CHECKR, SUBST & CAT

TESTN, SCAN, CHECK, CHECKR, SUBST & CAT

It is an INTEGRATED RDBMS.

It is an Integrated RDBMS.

It can be in ARRIVAL & KEYED SEQUENCE.

It can be in Arrival & Keyed sequence.