How do you
pass parameters in CL?
Ans:Using PARM keyword.
What are the valid user defined data area types?
Ans:CHAR, NUMERIC and LOGICAL
What is Multi-format logical file?
Ans:Logical which uses fields from two or more physical files.
What is the Select and Omit criteria in logical file?
Ans:This is used to specify rules for the Selection/Omission of records from a Physical File.
Can fields be concatenated INa logical file level?
Ans:Yes. by using CONCAT keyword
When would the ALL keyword be used?
Ans:Use with Select or Omit, to select/omit records.
What are the different types of keywords in display files?
Ans:File level, Record format level, Field level
What is difference between CAT, TCAT, BCAT?
Ans:
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 messages in CL?
Ans:Immediate message, Break message, Program message, User message
How to trap errors in CL?
Ans:By using Monitor Message Command (MONMSG)
What is the maximum length of a variable name in CL?
Ans:Maximum 11 characters (including '&')
What are the limitations of CL (compare to RPG) ?
Ans: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.
What is the use of Header Specification in RPG/400?
Ans:It identifies by H in column 6, provides informaion about generating and running programs.
When will DUMP and DEBUG opcodes be ignored?
Ans:If blank is specified in position 15 of H specs.
Specify different indicators used in RPG?
Ans:Overflow indicators
Record Identifying Indicators
Field Indicators
Resulting Indicators
Control Level Indicators
What are Control level indicators?
Ans: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?
Ans:Extension Specs describes all record address files, arrays and tables.
What is the use of L specs in RPG?
Ans:Line counter specification can be used to describe printer file to indicate the length of the form and number of lines per page.
In which specification the report layout can be defined?
Ans:O Specification.
How many files can be defined in F specs?
Ans:50
How many printer files can be defined in F specs ?
Ans:8
Ans:Using PARM keyword.
What are the valid user defined data area types?
Ans:CHAR, NUMERIC and LOGICAL
What is Multi-format logical file?
Ans:Logical which uses fields from two or more physical files.
What is the Select and Omit criteria in logical file?
Ans:This is used to specify rules for the Selection/Omission of records from a Physical File.
Can fields be concatenated INa logical file level?
Ans:Yes. by using CONCAT keyword
When would the ALL keyword be used?
Ans:Use with Select or Omit, to select/omit records.
What are the different types of keywords in display files?
Ans:File level, Record format level, Field level
What is difference between CAT, TCAT, BCAT?
Ans:
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 messages in CL?
Ans:Immediate message, Break message, Program message, User message
How to trap errors in CL?
Ans:By using Monitor Message Command (MONMSG)
What is the maximum length of a variable name in CL?
Ans:Maximum 11 characters (including '&')
What are the limitations of CL (compare to RPG) ?
Ans: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.
What is the use of Header Specification in RPG/400?
Ans:It identifies by H in column 6, provides informaion about generating and running programs.
When will DUMP and DEBUG opcodes be ignored?
Ans:If blank is specified in position 15 of H specs.
Specify different indicators used in RPG?
Ans:Overflow indicators
Record Identifying Indicators
Field Indicators
Resulting Indicators
Control Level Indicators
What are Control level indicators?
Ans: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?
Ans:Extension Specs describes all record address files, arrays and tables.
What is the use of L specs in RPG?
Ans:Line counter specification can be used to describe printer file to indicate the length of the form and number of lines per page.
In which specification the report layout can be defined?
Ans:O Specification.
How many files can be defined in F specs?
Ans:50
How many printer files can be defined in F specs ?
Ans:8
What is
Alternate Table?
Ans:RPG tables stores information in 1 column. To store information in multiple columns, it uses the concept of Alternate Table.
What is an Array?
Ans:Array is a collection of data, the data elements must be of same Length and same type.
The Qualified name for an object ORDPF residing in a library TRAINING is?
Ans:TRAINING/ORDPF
The function key to start SEU session through program development manager is?
Ans:F6
The Member type for an RPG & CL program which SEU supports is?
Ans:RPG & CLP
Printed output items placed in an output queue are known as?
Ans:Spool Files.
When a spooled file is created, it is placed into an?
Ans:OUTQUEUE
The command to display a list of spooled files?
Ans:WRKSPLF
Change in the externally described file does not require recompilation of the program?
Ans:False
Command to display current library is?
Ans:DSPCURLIB
A PF can have how many record formats?
Ans:Only one
Which one of the following has the highest priority Library on top of the library list, Library QGPL, Library on the bottom of the library list & Current library?
Ans:Current library
While designing the screen user wants to add file level keywords then which function key is pressed?
Ans:F14
While designing the report using RLU user wants to add record level keywords which function key is pressed?
Ans:F18
If user wants to add one field on the report then which function key is pressed?
Ans:F11
If user wants to center the company name on his report then which command will be used?
Ans:CF (Center Field)
SEU shows prompt/syntax checking according to?
Ans:Member Type
It is possible to run Query using RUNQRY command?
Ans:YES
Using Query it is possible to create level break report?
Ans:YES
Using DFU user can do which operation?
Ans:Add, Update & Select fields
What is the difference between UPDDTA to PF & updating using DFU?
Ans:Both are same, only difference is DFU program allows you to add & update selected
fields.
Which function key should be pressed to define hidden field while you are working with SDA?
Ans:F4
Which function key should be pressed to watch all string defined on SDA screen?
Ans:F20
While designing the screen using SDA, which function key should be pressed to get the field from the FRF?
Ans:F10.
From WRKMBRPDM screen you have to modify existing member-using SDA which option do you select?
Ans:17.
Write system defined function used to place system name on the screen?
Ans:*SYSNAME
While designing screen F3 function key is kept common for all record formats on which level should it be defined?
Ans:File level
Write down mandatory keywords used when defining a subfile?
Ans:SFL, SFLDSP, SFLSIZ, SFLCTL & SFLPAG
If user wants to change the length of the numeric field defined in the report then which combination of the keys will be used?
Ans:F23 & F10
What is the difference between SKIPB (2) & SPACEB (2)?
Ans:SKIPB (2) skips 1 page & on the next page after skipping 2 lines space print next while SPACEB
(2) skips 2 lines space before printing.
RLU: If user wants to define new numeric field on record format then which line command will be used?
Ans:VF
Maximum report length is 132, if user is designing a report using RLU?
Ans:FALSE (Maximum is 378)
What is full form for DDS?
Ans:Data Description Specification
What are members?
Ans: Members are separate entities within a database file & they are components of As/400 object.
What if RPG, when & who invented it?
Ans:Report Program Generator is IBM introduced a High Level Language in 1960.
For, which purpose is H Specs used?
Ans:Writing header information, date separator, currency symbol etc.
What is the size of the filename in RPG?
Ans:8 Characters (Max.)
Which are the different File Types in RPG?
Ans:I (Input), O (Output), U (Update) & C (Combine).
What are the different File Designation Types in RPG?
Ans:P (Primary) & F (Fully Procedural)
What’s the use of File Designation in RPG?
Ans:It refers to the way program will access or retrieve the data from the file.
What are the different File Format Types in RPG?
Ans:F (Fixed Length) & E (Externally Described)
What is the use of File Format in RPG?
Ans:It tells to the program that the records are within the program (F) or outside the program (E).
What is L Specs for?
Ans:To tell length of page & number of lines to be printed on a page.
What is I Specs for?
Ans:To describe the records within Program described file, fields, constants, divide fields into sub fields & to form a group of
fields.
How many maximum spaces could be given in O Specs?
Ans:3
Which are Control Break Logic indicators?
Ans:L1 – L9.
What are Data Structures?
Ans:Data Structures define an a storage & layout of fields within the defined structure.
Ans:RPG tables stores information in 1 column. To store information in multiple columns, it uses the concept of Alternate Table.
What is an Array?
Ans:Array is a collection of data, the data elements must be of same Length and same type.
The Qualified name for an object ORDPF residing in a library TRAINING is?
Ans:TRAINING/ORDPF
The function key to start SEU session through program development manager is?
Ans:F6
The Member type for an RPG & CL program which SEU supports is?
Ans:RPG & CLP
Printed output items placed in an output queue are known as?
Ans:Spool Files.
When a spooled file is created, it is placed into an?
Ans:OUTQUEUE
The command to display a list of spooled files?
Ans:WRKSPLF
Change in the externally described file does not require recompilation of the program?
Ans:False
Command to display current library is?
Ans:DSPCURLIB
A PF can have how many record formats?
Ans:Only one
Which one of the following has the highest priority Library on top of the library list, Library QGPL, Library on the bottom of the library list & Current library?
Ans:Current library
While designing the screen user wants to add file level keywords then which function key is pressed?
Ans:F14
While designing the report using RLU user wants to add record level keywords which function key is pressed?
Ans:F18
If user wants to add one field on the report then which function key is pressed?
Ans:F11
If user wants to center the company name on his report then which command will be used?
Ans:CF (Center Field)
SEU shows prompt/syntax checking according to?
Ans:Member Type
It is possible to run Query using RUNQRY command?
Ans:YES
Using Query it is possible to create level break report?
Ans:YES
Using DFU user can do which operation?
Ans:Add, Update & Select fields
What is the difference between UPDDTA to PF & updating using DFU?
Ans:Both are same, only difference is DFU program allows you to add & update selected
fields.
Which function key should be pressed to define hidden field while you are working with SDA?
Ans:F4
Which function key should be pressed to watch all string defined on SDA screen?
Ans:F20
While designing the screen using SDA, which function key should be pressed to get the field from the FRF?
Ans:F10.
From WRKMBRPDM screen you have to modify existing member-using SDA which option do you select?
Ans:17.
Write system defined function used to place system name on the screen?
Ans:*SYSNAME
While designing screen F3 function key is kept common for all record formats on which level should it be defined?
Ans:File level
Write down mandatory keywords used when defining a subfile?
Ans:SFL, SFLDSP, SFLSIZ, SFLCTL & SFLPAG
If user wants to change the length of the numeric field defined in the report then which combination of the keys will be used?
Ans:F23 & F10
What is the difference between SKIPB (2) & SPACEB (2)?
Ans:SKIPB (2) skips 1 page & on the next page after skipping 2 lines space print next while SPACEB
(2) skips 2 lines space before printing.
RLU: If user wants to define new numeric field on record format then which line command will be used?
Ans:VF
Maximum report length is 132, if user is designing a report using RLU?
Ans:FALSE (Maximum is 378)
What is full form for DDS?
Ans:Data Description Specification
What are members?
Ans: Members are separate entities within a database file & they are components of As/400 object.
What if RPG, when & who invented it?
Ans:Report Program Generator is IBM introduced a High Level Language in 1960.
For, which purpose is H Specs used?
Ans:Writing header information, date separator, currency symbol etc.
What is the size of the filename in RPG?
Ans:8 Characters (Max.)
Which are the different File Types in RPG?
Ans:I (Input), O (Output), U (Update) & C (Combine).
What are the different File Designation Types in RPG?
Ans:P (Primary) & F (Fully Procedural)
What’s the use of File Designation in RPG?
Ans:It refers to the way program will access or retrieve the data from the file.
What are the different File Format Types in RPG?
Ans:F (Fixed Length) & E (Externally Described)
What is the use of File Format in RPG?
Ans:It tells to the program that the records are within the program (F) or outside the program (E).
What is L Specs for?
Ans:To tell length of page & number of lines to be printed on a page.
What is I Specs for?
Ans:To describe the records within Program described file, fields, constants, divide fields into sub fields & to form a group of
fields.
How many maximum spaces could be given in O Specs?
Ans:3
Which are Control Break Logic indicators?
Ans:L1 – L9.
What are Data Structures?
Ans:Data Structures define an a storage & layout of fields within the defined structure.
Which are
the four keywords supported by Program Status Data Structure?
Ans:*STATUS, *PARM, *ROUTINE & *PROGRAM
Which are the String Manipulation Opcodes?
Ans:TESTN, SCAN, CHECK, CHECKR, SUBST & CAT
DB2 is a type of Database?
Ans:It is an Integrated RDBMS.
An access path may be in which sequence?
Ans:It can be in Arrival & Keyed sequence
To change constant field defined on RLU screen which field level keyword should be used?
Ans:DFT (Default)
Space & Skip are which level keywords?
Ans:Field & Record
A Join Logical File has how many Record formats?
Ans:1
A Multiple format Logical File is also known as?
Ans:Union File
How does Union file maintains Record formats?
Ans:1 Record format for each PF
Records can be Read/Update/Deleted with which file?
Ans:Simple Logical File & Physical File.
Which type of object is used in DB2/400?
Ans:*FILE
What is SQL?
Ans:SQL is an interface for programming language.
File level entry for a PF can be?
Ans:UNIQUE & FIFO
What is the command to create FRF?
Ans:CRTPF
Join Logical File displays data from how many files?
2 or more PF’s
A Query can be displayed without saving it?
Ans:True
Which are the Query selection criteria, which can be given in a Query?
Ans:LIST
To add a file to the ‘File Selection’ option of a Query, the function key to be pressed is?
Ans:F9
A query can be run in which mode?
Ans:Batch & Interactive
What is the values SQLCOD when there is an error in fetching the records specified in the select statement?
Ans:-ve value
A file cannot have more than 1 unique key?
Ans:False
DLCOBJ command is mandatory for removing lock on any object?
Ans:False
What is a Journal?
Ans:A Journal is an object used primarily to record changes to data in a PF.
Which are the DB2 tools to protect Integrity of the database?
Ans:Journaling & Commitment Control, Referential Integrity Embedded SQL & Object/Record Locks. -
Ans:*STATUS, *PARM, *ROUTINE & *PROGRAM
Which are the String Manipulation Opcodes?
Ans:TESTN, SCAN, CHECK, CHECKR, SUBST & CAT
DB2 is a type of Database?
Ans:It is an Integrated RDBMS.
An access path may be in which sequence?
Ans:It can be in Arrival & Keyed sequence
To change constant field defined on RLU screen which field level keyword should be used?
Ans:DFT (Default)
Space & Skip are which level keywords?
Ans:Field & Record
A Join Logical File has how many Record formats?
Ans:1
A Multiple format Logical File is also known as?
Ans:Union File
How does Union file maintains Record formats?
Ans:1 Record format for each PF
Records can be Read/Update/Deleted with which file?
Ans:Simple Logical File & Physical File.
Which type of object is used in DB2/400?
Ans:*FILE
What is SQL?
Ans:SQL is an interface for programming language.
File level entry for a PF can be?
Ans:UNIQUE & FIFO
What is the command to create FRF?
Ans:CRTPF
Join Logical File displays data from how many files?
2 or more PF’s
A Query can be displayed without saving it?
Ans:True
Which are the Query selection criteria, which can be given in a Query?
Ans:LIST
To add a file to the ‘File Selection’ option of a Query, the function key to be pressed is?
Ans:F9
A query can be run in which mode?
Ans:Batch & Interactive
What is the values SQLCOD when there is an error in fetching the records specified in the select statement?
Ans:-ve value
A file cannot have more than 1 unique key?
Ans:False
DLCOBJ command is mandatory for removing lock on any object?
Ans:False
What is a Journal?
Ans:A Journal is an object used primarily to record changes to data in a PF.
Which are the DB2 tools to protect Integrity of the database?
Ans:Journaling & Commitment Control, Referential Integrity Embedded SQL & Object/Record Locks. -
No comments:
Post a Comment