What is the maximum number of records you can specify in a display file?
Ans:1024
How can a screen field that has changed since the last output operation be detected ?
Ans:Attach the MDT (modified data tag) attribute to the field, to detect whether field has been changed as a result of user input.
What would be the effect on the field where reverse image, underline and highlight display attributes were active?
Ans:The result is same as if you had specified ND.
What is the use of DSPATR(MDT) keyword?
Ans: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.
If DSPATR(PC) and CSRLOC were specified for a format, which keyword would have priority?
Ans:CSRLOC gains priority.
Saturday, 27 August 2011
AS-400 Interview Questions and Answers: Part II
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
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
AS-400 Interview Questions and Answers: Part III
Give three main purposes of File specification ?
Ans:To define files, to describe the files, to assign the files to specified devices.
How do you specify page overflow indicator for printer files in RPG?
Ans:Specify an indicator in position 33-34 of F specification.
What is a Primary File?
Ans:It is used in RPG Program Cycle to automatically read records in a cycle.
Can a indexed file be accessed in arrival sequence in RPG program?
Ans:Yes.
What opcode could be used to test an alphanumeric field for all numeric values?
Ans:TESTN
What opcode will be used to test the zone of a character field?
Ans:TESTZ
How to read database records without locking them?
Ans:Put 'N' in position 53 of C specs.
Ans:To define files, to describe the files, to assign the files to specified devices.
How do you specify page overflow indicator for printer files in RPG?
Ans:Specify an indicator in position 33-34 of F specification.
What is a Primary File?
Ans:It is used in RPG Program Cycle to automatically read records in a cycle.
Can a indexed file be accessed in arrival sequence in RPG program?
Ans:Yes.
What opcode could be used to test an alphanumeric field for all numeric values?
Ans:TESTN
What opcode will be used to test the zone of a character field?
Ans:TESTZ
How to read database records without locking them?
Ans:Put 'N' in position 53 of C specs.
AS-400 Interview Questions and Answers: Part IV
What the purpose of the keywords FIFO, LIFO, FCFO?
Ans:These keywords are used at file level. The purpose of each one is described below:
FIFO: The duplicate key records will retrieved in first in first out order.
LIFO: The duplicate key records will retrieved in last in first out order.
FCFO: The duplicate key records will retrieved in first changed first out order.
What is the difference between regular logical file and join logical file?
Ans:Regular logical file contains more than one record format.
Record format name in regular logical file should be same based on the physical file.
Join logical file contains only one record format.
Record format name in join logical file should be different.
Through logical file we can made changes in physical file.
Through join logical file we can't made changes in physical file.
Distinguish between logical file and physical file?
Ans:Physical file contains only one record format.
Logical file contains more than one record format.
Physical file contains actual data.
Logical file doesn't contains data but it provides view from the physical file.
Ans:These keywords are used at file level. The purpose of each one is described below:
FIFO: The duplicate key records will retrieved in first in first out order.
LIFO: The duplicate key records will retrieved in last in first out order.
FCFO: The duplicate key records will retrieved in first changed first out order.
What is the difference between regular logical file and join logical file?
Ans:Regular logical file contains more than one record format.
Record format name in regular logical file should be same based on the physical file.
Join logical file contains only one record format.
Record format name in join logical file should be different.
Through logical file we can made changes in physical file.
Through join logical file we can't made changes in physical file.
Distinguish between logical file and physical file?
Ans:Physical file contains only one record format.
Logical file contains more than one record format.
Physical file contains actual data.
Logical file doesn't contains data but it provides view from the physical file.
AS-400 Interview Questions and Answers: Part V
When will you use OPEN and CLOSE opcodes in RPG program?
Ans:If you specify the letter "U" at columns 73 - 74 in a file description specification indicating that user control on a file. Hence we have to explicitly open and close the file in a program.
What is difference between fully procedural file and primary file?
Ans:In primary file the records will be read and processed from begining to end. This order is not changed. In fully procedural file the records will be read and processed in any order. The logic flow is controlled by the opcodes in RPG program.
What is the difference between externally described file and program described file?
Ans:The field definitions and descriptions are defined out side of the program in a externally described file. The field definitions and descriptions are defined in side the program in a program described file.
How many primary files allowed in a program?
Ans:Only one primary file is allowed in program.
Ans:If you specify the letter "U" at columns 73 - 74 in a file description specification indicating that user control on a file. Hence we have to explicitly open and close the file in a program.
What is difference between fully procedural file and primary file?
Ans:In primary file the records will be read and processed from begining to end. This order is not changed. In fully procedural file the records will be read and processed in any order. The logic flow is controlled by the opcodes in RPG program.
What is the difference between externally described file and program described file?
Ans:The field definitions and descriptions are defined out side of the program in a externally described file. The field definitions and descriptions are defined in side the program in a program described file.
How many primary files allowed in a program?
Ans:Only one primary file is allowed in program.
AS-400 Interview Questions and Answers: Part VI
What is message subfile?
Ans:Message subfile is special file contains multiple messages taken from program message queue and placed in message sub file for display on the screen.
What is the purpose of PUTOVR (Put with explicit override) keyword?
Ans: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.
What are necessary keywords to code message subfile?
Ans:SFLMSGRCD, SFLMSGKEY, SFLPGMQ
What is the difference between SETON LR and RETRN?
Ans: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.
What is the purpose of OVRDTA (Override Data) keyword?
Ans:Use this field level keyword with PUTOVR keyword to override the existing the data contents of a field already on the display.
What is the maximum number of record formats in DSPF?
Ans:1024 (One thousand and twenty four)
Ans:Message subfile is special file contains multiple messages taken from program message queue and placed in message sub file for display on the screen.
What is the purpose of PUTOVR (Put with explicit override) keyword?
Ans: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.
What are necessary keywords to code message subfile?
Ans:SFLMSGRCD, SFLMSGKEY, SFLPGMQ
What is the difference between SETON LR and RETRN?
Ans: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.
What is the purpose of OVRDTA (Override Data) keyword?
Ans:Use this field level keyword with PUTOVR keyword to override the existing the data contents of a field already on the display.
What is the maximum number of record formats in DSPF?
Ans:1024 (One thousand and twenty four)
AS400 Realtime Interview Questions Answers : I
How do you set pointers to values 55 or next higher or greater?
Ans:SETGT.
How will I explicitly open a file in an RPG program?
Ans:By defining UC in file condition and to opening the file mention OPEN opcode and closing the file by mentioning CLOSE in opcode of C spec.
What is maximum size of data area?
Ans:9999.
How to fire a JOB?
Ans:SBMJOB.
How many levels of security are there on AS/400?
Ans:There are 10 to 50 level of security on AS/400.
How to translate field values form lower case to Upper case?
Ans:By using opcode XLATE.
What are the maximum parameters can be passed from one RPG program to another RPG program?
Ans:255
Ans:SETGT.
How will I explicitly open a file in an RPG program?
Ans:By defining UC in file condition and to opening the file mention OPEN opcode and closing the file by mentioning CLOSE in opcode of C spec.
What is maximum size of data area?
Ans:9999.
How to fire a JOB?
Ans:SBMJOB.
How many levels of security are there on AS/400?
Ans:There are 10 to 50 level of security on AS/400.
How to translate field values form lower case to Upper case?
Ans:By using opcode XLATE.
What are the maximum parameters can be passed from one RPG program to another RPG program?
Ans:255
AS400 Realtime Interview Questions Answers : II
How to see the CPU usage?
Ans:WRKACTJOB or WRKSYSSTS
While designing the screen, F3 function key is kept common for all record formats. On which level should it be defined?
Ans:File Level
Write down any two mandatory keywords used when defining a subfile?
Ans:SFLDSP, SFLDSPCTL, SFLCTL, SFLSIZ, SFLPAG.
While designing the screen user wants to add file level keywords, then which function key should be pressed?
Ans:F14.
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 strings defined on the SDA screen?
Ans:F20
While designing the screen using SDA, which function key should be pressed to get the field from the field reference file?
Ans:F10
From work with member using PDM screen you have to modify existing member using SDA, which option do you select?
Ans: 17
Ans:WRKACTJOB or WRKSYSSTS
While designing the screen, F3 function key is kept common for all record formats. On which level should it be defined?
Ans:File Level
Write down any two mandatory keywords used when defining a subfile?
Ans:SFLDSP, SFLDSPCTL, SFLCTL, SFLSIZ, SFLPAG.
While designing the screen user wants to add file level keywords, then which function key should be pressed?
Ans:F14.
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 strings defined on the SDA screen?
Ans:F20
While designing the screen using SDA, which function key should be pressed to get the field from the field reference file?
Ans:F10
From work with member using PDM screen you have to modify existing member using SDA, which option do you select?
Ans: 17
AS400 Realtime Interview Questions Answers : III
What is Logical File?
Ans:A Logical file is an Access path to the Physical File.
How can you specify no duplicate key?
Ans:By defining the unique key.
What is the command to know how many LF are related to a PF?
Ans:DSPDBR (Display Database Relationship)
What is the command to know key fields of file?
Ans:DSPFD (F4) *ACCPTH(Access Path).
What is a Join Logical File?
Ans:A join Logical File can be built over the two PF’s, with the PF’s ‘joined’ by a common key value. It is available for read access.
Can a Join Logical File be updated?
Ans:No.
Using DFU, user will be able to ___________ from Physical File?
Ans:Add/Update/Selected or all fields.
Ans:A Logical file is an Access path to the Physical File.
How can you specify no duplicate key?
Ans:By defining the unique key.
What is the command to know how many LF are related to a PF?
Ans:DSPDBR (Display Database Relationship)
What is the command to know key fields of file?
Ans:DSPFD (F4) *ACCPTH(Access Path).
What is a Join Logical File?
Ans:A join Logical File can be built over the two PF’s, with the PF’s ‘joined’ by a common key value. It is available for read access.
Can a Join Logical File be updated?
Ans:No.
Using DFU, user will be able to ___________ from Physical File?
Ans:Add/Update/Selected or all fields.
IBM AS400 Interview Questions Answers: Series I
What is arrival sequence?
Ans:The records will be accessed the way in which records are added to physical file.
How many specifications are there in RPG/400? What are they?
Ans:There are seven specifications are exits in RPG/400. They are listed below:
* Header Specification ,* File Description specification ,* Extension specification
* Line counter specification ,* Input specification ,* Calculation specification ,* Output specification
When do you use F-spec. continuation line ?
Ans:
* In order to refer the named record format as a subfile record format in the program.
* In order to rename the record format of a database file in a program.
* In order to define a named data structure as a file information data structure.
What are the various types of device files?
Ans:Display files, printer files, discket files, tape files etc. ,
When do you explicitly open files and close files in an RPG program?
Ans:If you specify the letter ' U ' at column 73-74, you need to be open and close files explicitly in a RPG program.
Ans:The records will be accessed the way in which records are added to physical file.
How many specifications are there in RPG/400? What are they?
Ans:There are seven specifications are exits in RPG/400. They are listed below:
* Header Specification ,* File Description specification ,* Extension specification
* Line counter specification ,* Input specification ,* Calculation specification ,* Output specification
When do you use F-spec. continuation line ?
Ans:
* In order to refer the named record format as a subfile record format in the program.
* In order to rename the record format of a database file in a program.
* In order to define a named data structure as a file information data structure.
What are the various types of device files?
Ans:Display files, printer files, discket files, tape files etc. ,
When do you explicitly open files and close files in an RPG program?
Ans:If you specify the letter ' U ' at column 73-74, you need to be open and close files explicitly in a RPG program.
IBM AS400 Interview Questions Answers: Series II
What is Spool file, Why is it required?
Ans:A file that holds output data to be processed, such as information waiting to be printed.
What is Job, What are the attributes of a Job?
Ans:A Job is a basic unit of work on AS/400.
The attributes are:
Job Number Unique system generated sequential number
Job Name Any user defined name (Max 10 char)
User Name Who initiated the job.
What is Job description?
Ans:A Job description defines an environment in which a batch job or an interactive job to be executed.
What is the difference between Interactive & Batch Job?
Ans:
Interactive Job: A Job started for a person who signon to a workstation.
Batch Job : A predefined group of processing actions submitted to the system to be performed.
What is Group Job?
Ans:A file that holds output data to be processed, such as information waiting to be printed.
What is Job, What are the attributes of a Job?
Ans:A Job is a basic unit of work on AS/400.
The attributes are:
Job Number Unique system generated sequential number
Job Name Any user defined name (Max 10 char)
User Name Who initiated the job.
What is Job description?
Ans:A Job description defines an environment in which a batch job or an interactive job to be executed.
What is the difference between Interactive & Batch Job?
Ans:
Interactive Job: A Job started for a person who signon to a workstation.
Batch Job : A predefined group of processing actions submitted to the system to be performed.
What is Group Job?
IBM AS400 Interview Questions Answers: Series III
What are the types of data areas?
Ans:User defined Data Area, Local Data Area (LDA), Group Data Area (GDA), Program Initialization Parameter (PIP) Data Area.
What is LDA?
Ans:LDA is created by the system for each job in the system, including auto-start jobs, jobs started on the system by a reader, and subsystem monitor jobs.
What is the type, length of a LDA?
Ans:*CHAR, 1024 bytes
What is GDA?
Ans:The system creates a GDA when an interactive job becomes group jobs. Only one GDA can exists for group.
How can a data area be locked after being updated?
Ans:Using OUT *LOCK
What is the use of Data Queues?
Ans:Data queue is a type of system object that you can create. Data Queues are used in Program to program communication.
How to create a data queues?
Ans:Using CRTDTAQ command.
Ans:User defined Data Area, Local Data Area (LDA), Group Data Area (GDA), Program Initialization Parameter (PIP) Data Area.
What is LDA?
Ans:LDA is created by the system for each job in the system, including auto-start jobs, jobs started on the system by a reader, and subsystem monitor jobs.
What is the type, length of a LDA?
Ans:*CHAR, 1024 bytes
What is GDA?
Ans:The system creates a GDA when an interactive job becomes group jobs. Only one GDA can exists for group.
How can a data area be locked after being updated?
Ans:Using OUT *LOCK
What is the use of Data Queues?
Ans:Data queue is a type of system object that you can create. Data Queues are used in Program to program communication.
How to create a data queues?
Ans:Using CRTDTAQ command.
IBM AS400 Interview Questions Answers: Series IV
Difference between CALL & SBMJOB?
Ans:CALL performs interactively job while SBMJOB performs batch job.
Maximum number of Records in Display File?
Ans:1024
What does VLDCMDKEY means?
Ans:Valid Command Key.
What is Subroutine in RPG?
Ans:A subroutine is a group of statements in a program that can be processed several times in that program.
Do we have to Execute the *INZSR compulsory?
Ans:No, it is a system-defined subroutine it is executed automatically.
What is the use of *PSSR in the program?
Ans:Whenever there is any type error in the program the control straight away passes onto this subroutine.
Ans:CALL performs interactively job while SBMJOB performs batch job.
Maximum number of Records in Display File?
Ans:1024
What does VLDCMDKEY means?
Ans:Valid Command Key.
What is Subroutine in RPG?
Ans:A subroutine is a group of statements in a program that can be processed several times in that program.
Do we have to Execute the *INZSR compulsory?
Ans:No, it is a system-defined subroutine it is executed automatically.
What is the use of *PSSR in the program?
Ans:Whenever there is any type error in the program the control straight away passes onto this subroutine.
IBM AS400 Interview Questions Answers: Series V
How many triggers can be associated with a single PF?
Ans:6 (max)
Can the objects stored in the product library be modified?
Ans:No.
How many types of objects are there on As/400?
Ans:80
How is data stored in PF’s?
Ans:In fixed length records.
Give an example of DEFN opcode?
Ans:*LIKE DEFN ENAME $ENAME (Now the $ENAME has all the attributes same like ENAME)
What is DBMS?
Ans:A DBMS is a software system that controls the creation, organization & modification of a database & access to the date stored within it.
How can we know the triggers associated with the PF?
Ans:DSPFD with parameter TYPE (*TRG)
How can we add & remove trigger to a PF?
Ans:ADDPFTRG & RMVPFTRG
Ans:6 (max)
Can the objects stored in the product library be modified?
Ans:No.
How many types of objects are there on As/400?
Ans:80
How is data stored in PF’s?
Ans:In fixed length records.
Give an example of DEFN opcode?
Ans:*LIKE DEFN ENAME $ENAME (Now the $ENAME has all the attributes same like ENAME)
What is DBMS?
Ans:A DBMS is a software system that controls the creation, organization & modification of a database & access to the date stored within it.
How can we know the triggers associated with the PF?
Ans:DSPFD with parameter TYPE (*TRG)
How can we add & remove trigger to a PF?
Ans:ADDPFTRG & RMVPFTRG
IBM AS400 Interview Questions Answers: Series VI
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
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
AS/400 Interview Questions Answers: Part 2
What is the difference between SFLCLR and SFLINZ?
Ans:SFLCLR : It clears the subfile. SFLINZ : First it clears the subfile and initiliazing the numeric variables with zeros and alphanumeric variables with characters.
Define the purpose/use for SFLRNA?
Ans:Using this,
we can make specified subfile record format inactive.
What is the purpose of the following
I UDS
I 1 60ORDER#
I 7 90LINE#
Ans:The purpose is to define the variables in I-Spec and these are further used in C-spec. Where as ‘U’ indicates data area data structure? The above code is used to update the data area value through the program. The letter "U" indicates that the defined data structure is a data area data structure.
What is the purpose of the following?
A CSRLOC (F1ROW F1COL)
Ans:Using this record level keyword, you can specify cursor location on an output operation to the record format you are defining. The program sends output after setting the cursor location.
Ans:SFLCLR : It clears the subfile. SFLINZ : First it clears the subfile and initiliazing the numeric variables with zeros and alphanumeric variables with characters.
Define the purpose/use for SFLRNA?
Ans:Using this,
we can make specified subfile record format inactive.
What is the purpose of the following
I UDS
I 1 60ORDER#
I 7 90LINE#
Ans:The purpose is to define the variables in I-Spec and these are further used in C-spec. Where as ‘U’ indicates data area data structure? The above code is used to update the data area value through the program. The letter "U" indicates that the defined data structure is a data area data structure.
What is the purpose of the following?
A CSRLOC (F1ROW F1COL)
Ans:Using this record level keyword, you can specify cursor location on an output operation to the record format you are defining. The program sends output after setting the cursor location.
AS/400 Interview Questions Answers: Part 3
Which of the following operations does NOT zero the field FLDA defined as 4,0?
Ans: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.
How would you design the process for a nightly, high volume check producing process that needs to select only records that are flagged to be processed?
Ans: 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
How would you join 3 separate fields, a first name, middle initial and last name together as 1 field with proper spacing? You can describe in either RPG and/or RPG ILE (Integrated Language Environment)
Ans:
MOVE 'Dr. ' FNAME 3
MOVE 'JOHN' MNAME 4
MOVE 'WATSON' LNAME 6
FNAME CAT MNAME: 1 VAR1 8
VAR1 CAT LNAME:1 VAR2 15
DSPLY VAR2
MOVE *ON *INLR
Ans: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.
How would you design the process for a nightly, high volume check producing process that needs to select only records that are flagged to be processed?
Ans: 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
How would you join 3 separate fields, a first name, middle initial and last name together as 1 field with proper spacing? You can describe in either RPG and/or RPG ILE (Integrated Language Environment)
Ans:
MOVE 'Dr. ' FNAME 3
MOVE 'JOHN' MNAME 4
MOVE 'WATSON' LNAME 6
FNAME CAT MNAME: 1 VAR1 8
VAR1 CAT LNAME:1 VAR2 15
DSPLY VAR2
MOVE *ON *INLR
AS400 FAQs, Interview Questions and Answers
What is a library in AS/400 ?
Ans:Library in AS/400 is an object that serves as a repository for other objects.
Name few IBM supplied libraries ?
Ans:GPL, QTEMP, QUSRTOOL, QSYS, QRPG & QCBL.
What is a library list ?
Ans:Library list that indicates libraries used for the process and the order in which it has to be
searched. System identifies it in *LIBL.
How many libraries can be there in a library list ?
Ans:Total 40 (15 system and 25 application).
DDS - Data Description Specification.
Source Physical File contains the source for the various objects created. This file has a specific structure.
RPG, CLP, DSPF, PRTF, etc.
A-spec
UNIQUE, PFILE, REFFLD
Ans:Library in AS/400 is an object that serves as a repository for other objects.
Name few IBM supplied libraries ?
Ans:GPL, QTEMP, QUSRTOOL, QSYS, QRPG & QCBL.
What is a library list ?
Ans:Library list that indicates libraries used for the process and the order in which it has to be
searched. System identifies it in *LIBL.
How many libraries can be there in a library list ?
Ans:Total 40 (15 system and 25 application).
DDS - Data Description Specification.
Source Physical File contains the source for the various objects created. This file has a specific structure.
RPG, CLP, DSPF, PRTF, etc.
A-spec
UNIQUE, PFILE, REFFLD
AS400 Frequently Asked Interview Questions Answers : II
What are the different Opcodes available in RPG for Database access ?
Ans:READ, CHAIN, WRITE, UPDAT, DELET, SETLL, SETGT, READE, READP, REDPE, OPEN, CLOSE, FORCE, NEXT, UNLCK.
How can database records be read without lock ?
Ans:Put 'N' in position 53 of C specs.
What does CHECK opcode do ?
Ans:The check operation verifies that each character in the base string (factor 2) is among the ` character indicated in the comparator string(factor 1).
In conjunction with which statements can ORxx and ANDxx conditions be used ?
Ans:DOUxx, DOWxx, IFxx, and WHxx.
What does opcode POST do ?
Ans:Puts information in INFDS.
Can you have multiple key lists for a single file ?
Yes.
Ans:READ, CHAIN, WRITE, UPDAT, DELET, SETLL, SETGT, READE, READP, REDPE, OPEN, CLOSE, FORCE, NEXT, UNLCK.
How can database records be read without lock ?
Ans:Put 'N' in position 53 of C specs.
What does CHECK opcode do ?
Ans:The check operation verifies that each character in the base string (factor 2) is among the ` character indicated in the comparator string(factor 1).
In conjunction with which statements can ORxx and ANDxx conditions be used ?
Ans:DOUxx, DOWxx, IFxx, and WHxx.
What does opcode POST do ?
Ans:Puts information in INFDS.
Can you have multiple key lists for a single file ?
Yes.
AS-400,AS/400 Technical Interview Questions Answers: Part I
What are the three types of keywords associated with printer file ?
Ans:File level, Record level & Field level.
Difference between SFLRCDNBR and SFLNXTCHG
Ans:SFLRCDNBR will give the RRN of the First record displayed on the screen at a given time.
Whenever a record is changed on display file. An MDT is set ON. If an indicator is associated with SLFNXTCHG and it is SETON then READC will read only the changed record. And if the indicator is not associated and it is seton it READC reads all the records from sub-file
How can see logical file based on which physical file and vice versa
Ans:DSPDBR
How can u check no of records in a file
Ans:DSPFD
How do u compile RPGLE program
Ans:Either thru 15 or crtrpgmod
Ans:File level, Record level & Field level.
Difference between SFLRCDNBR and SFLNXTCHG
Ans:SFLRCDNBR will give the RRN of the First record displayed on the screen at a given time.
Whenever a record is changed on display file. An MDT is set ON. If an indicator is associated with SLFNXTCHG and it is SETON then READC will read only the changed record. And if the indicator is not associated and it is seton it READC reads all the records from sub-file
How can see logical file based on which physical file and vice versa
Ans:DSPDBR
How can u check no of records in a file
Ans:DSPFD
How do u compile RPGLE program
Ans:Either thru 15 or crtrpgmod
AS-400,AS/400 Technical Interview Questions Answers: Part II
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
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
AS400 FAQS,Interview Questions ,Explanations
How to define Global Parameter in ILE ?
Ans:Declare a variable with key word EXPORT and while using this variable in anther program declare with
IMPORT keyword.
What is the disadvantage of using Global variable?
Ans:We can not trace out at which point the value of variable is changed.
What is Service Program?
Ans: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.
What is the structure of Service Program ? What is signature ?
Ans:Declare a variable with key word EXPORT and while using this variable in anther program declare with
IMPORT keyword.
What is the disadvantage of using Global variable?
Ans:We can not trace out at which point the value of variable is changed.
What is Service Program?
Ans: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.
What is the structure of Service Program ? What is signature ?
COBOL400 Interview Questions,DB400 Interview Questions
A program variable coded in an Embedded SQL statement is referred to as?
Ans:Host Variable
Which of the CL command can be used to determine which logical files are dependent on a specific file?
Ans:DSPDBR
What does DFU program you to do on a record?
Ans:Insert, Update Delete & File Enquiry.
When are the Unique Constraints executed?
Ans:During Insert.
When are the Referential Constraints executed?
Ans:Insert, Update & Delete.
How many triggers can be associated with a file?
Ans:6(Maximum)
Why is the Declare cursor statement is used for?
Ans:To define & name the cursor & specify rows to be fetched.
What do we can do with the Embedded SQL statements?
Ans:We can Insert/Update/Delete records, fetch records, fetch values from records into variables.
Ans:Host Variable
Which of the CL command can be used to determine which logical files are dependent on a specific file?
Ans:DSPDBR
What does DFU program you to do on a record?
Ans:Insert, Update Delete & File Enquiry.
When are the Unique Constraints executed?
Ans:During Insert.
When are the Referential Constraints executed?
Ans:Insert, Update & Delete.
How many triggers can be associated with a file?
Ans:6(Maximum)
Why is the Declare cursor statement is used for?
Ans:To define & name the cursor & specify rows to be fetched.
What do we can do with the Embedded SQL statements?
Ans:We can Insert/Update/Delete records, fetch records, fetch values from records into variables.
CCNA Questions 1
How to crimping cat cable without using crimping and any tool...........?
I am just getting into this,I want to jump ahead a do the packet tracers in discovery working at a small to medium business or ISP but I am trying to get the last lab putting it all together. Does anyone have anything for this. I know it is ahead of me but I would like to get this so I can look at the beginning and understand it more
hello i am new to this, i need to know how will i complete a basic scenario that ask the required number of networks that is 80 and the minimum number of host that is 3000 and the network address is 10.0.0.0 and i need to need how to compute to get the answer on what is the subnet mask.
why we have to implement access list in router ??????what is the benifit and how it is configure
Can 2 different VTP Domain Communicate. if yes then How.
How to use PageRank?
PageRank is one of the methods Google uses to determine a page?s relevance or importance. It is only one part of the story when it comes to the Google listing, but the other aspects are discussed elsewhere (and are ever changing) and PageRank is interesting enough to deserve a paper of its own.
PageRank is also displayed on the toolbar of your browser if you?ve installed the Google toolbar (http://toolbar.google.com/). But the Toolbar PageRank only goes from 0 ? 10 and seems to be something like a logarithmic scale:
We can?t know the exact details of the scale because, as we?ll see later, the maximum PR of all pages on the web changes every month when Google does its re-indexing! If we presume the scale is
PageRank is also displayed on the toolbar of your browser if you?ve installed the Google toolbar (http://toolbar.google.com/). But the Toolbar PageRank only goes from 0 ? 10 and seems to be something like a logarithmic scale:
|
We can?t know the exact details of the scale because, as we?ll see later, the maximum PR of all pages on the web changes every month when Google does its re-indexing! If we presume the scale is
Explore The Google Pagerank Algorithm and How It Works
Introduction to Google PageRank Algorithm
Page Rank is a topic much discussed by Search Engine Optimization (SEO) experts. At the heart of PageRank is a mathematical formula that seems scary to look at but is actually fairly simple to understand.
Despite this many people seem to get it wrong! In particular ?Chris Ridings of www.searchenginesystems.net? has written a paper entitled ?PageRank Explained: Everything you?ve always wanted to know about PageRank?, pointed to by many people, that contains a fundamental mistake early on in the explanation! Unfortunately this means some of the recommendations in the paper are not quite accurate.
By showing code to correctly calculate real PageRank I hope to achieve several things in this response:
- Clearly explain how PageRank is calculated.
- Go through every example in Chris? paper, and add some more of my own, showing the correct PageRank for each diagram. By showing the code used to calculate each diagram I?ve opened myself up to peer review - mostly in an effort to make sure the examples are correct, but also because the code can help explain the PageRank calculations.
- Describe some principles and observations on website design based on these correctly calculated examples.
Any good web designer should take the time to fully understand how PageRank really works - if you don?t then your site?s layout could be seriously hurting your Google listings
Source: globalguideline.com
How Search Engines Operates
Search engines have a short list of critical operations that allows them to provide relevant web results when searchers use their system to find information.
- Definition: Crawling the Web
Search engines run automated programs, called "bots" or "spiders", that use the hyperlink structure of the web to "crawl" the pages and documents that make up the World Wide Web. Estimates are that of the approximately 20 billion existing pages, search engines have crawled between 8 and 10 billion. - Definition: Indexing Documents
Once a page has been crawled, its contents can be "indexed" - stored in a giant database of documents that makes up a search engine's "index". This index needs to be tightly managed so that requests which must search and sort billions of documents can be completed in fractions of a second.
Concepts of Google Page Rank, Toolbar and Back Links
Definitions of Page Rank, Toolbar and Back Links
We have started to use some technical terms and shorthand in this page. This Web page will clear the concept of Google Page Rank, Google Toolbar for viewing the Page Rank and Back Links of a web site. Now?s as good a time as any to define all the terms We will use:
|
That?s enough of that, let?s get back to details of these terms Page Rank and Back Links.
Source: globalguideline.com
10 Ways to Build Secure Traffic for Your Website
Building defensible or alternative traffic sources for your website allows it to stay afloat, should any search engine algorithms negatively impact the amount of organic traffic you currently or are able to receive. This article includes a compilation of 10 overall strategies you can use to develop referral traffic sources for your website or business.
As these methods are generally not niche-specific, you can use them effectively for any type of website or industry. Links to similar articles on these topics are also included at the end of this list.
Let?s start first with a general idea of the type of defensible traffic you should be building. While the following points are ideal conceptualizations, they may help you to assess the value of your referral traffic sources.
The traffic source you are developing should:
As these methods are generally not niche-specific, you can use them effectively for any type of website or industry. Links to similar articles on these topics are also included at the end of this list.
Characteristics of an Ideal Defensible Traffic Source
Let?s start first with a general idea of the type of defensible traffic you should be building. While the following points are ideal conceptualizations, they may help you to assess the value of your referral traffic sources.
The traffic source you are developing should:
- Promote your brand.
- Reinforce or build the existing community around your site
- Send targeted traffic (interested visitors)
- Work on both a long and short term basis.
- Connect your website with a broad audience
- Sustain itself over time, without requiring consistent active effort.
- Complement your overall site monetization strategy
how to grow a Web Site's Popularity
While developing a great website is half of the SEO equation, the other half is promotion. Search engines are very particular about growing their ability to detect artificial manipulation and link spam, so effective SEOs who want to promote sites to the fullest extent must use natural, organic link building processes in order to have success.
The techniques and approaches described below are all ultimately designed to improve search engine rankings by growing the number and quality of links that point to a website.
However, each also offers natural growth of your user base and provides visitors that come through systems other than search engines. Strangely, although the goal of SEO is better search rankings, the best sites in each industry often receive 50% or fewer of their total visitors from search engines. Why? Because if thousands of visitors are anxiously visiting your site via bookmarks, links, and direct type-ins at the address bar, you've achieved the content and status necessary to not only be ranked exceptionally well, but have visitors that know your site and want to visit, no matter what the search engines say. This methodology is particularly valuable because a site that doesn't rely entirely on search engines for traffic, ironically, has a far better chance of getting visitors through them.
The techniques and approaches described below are all ultimately designed to improve search engine rankings by growing the number and quality of links that point to a website.
However, each also offers natural growth of your user base and provides visitors that come through systems other than search engines. Strangely, although the goal of SEO is better search rankings, the best sites in each industry often receive 50% or fewer of their total visitors from search engines. Why? Because if thousands of visitors are anxiously visiting your site via bookmarks, links, and direct type-ins at the address bar, you've achieved the content and status necessary to not only be ranked exceptionally well, but have visitors that know your site and want to visit, no matter what the search engines say. This methodology is particularly valuable because a site that doesn't rely entirely on search engines for traffic, ironically, has a far better chance of getting visitors through them.
Community Building
7 Low Cost Ways To Get Constant Traffic To Your Website
There is probably no bigger headache any Webmaster faces that that of getting traffic to their website. With increased competition and the ever-increasing number of websites, this has become an even bigger challenge.
Yet with the right skills and knowledge generating traffic for your site can be a fun thing to do and you can become very successful at doing it.
You should never do any online marketing that does not have a system or method to help you build your opt-in email list. Your email list is the most valuable online marketing tool you will ever have.
Use your opt-in email list to keep the traffic flowing towards your site. Send them special offers and even new article alerts that will lead them back to your site again and again. Then make every effort to ensure that your opt-in email list is constantly growing.
Yet with the right skills and knowledge generating traffic for your site can be a fun thing to do and you can become very successful at doing it.
1 >> Opt-in email list
You should never do any online marketing that does not have a system or method to help you build your opt-in email list. Your email list is the most valuable online marketing tool you will ever have.
Use your opt-in email list to keep the traffic flowing towards your site. Send them special offers and even new article alerts that will lead them back to your site again and again. Then make every effort to ensure that your opt-in email list is constantly growing.
2 >> Blog Advertising
Learn how to Build a Traffic-Worthy Site
One of the most important (and often overlooked) subjects in SEO is building a site deserving of top rankings at the search engines. A site that ranks #1 for a set of terms in a competitive industry or market segment must be able to justify its value or risk losing out to competitors who offer more. Search engines' goals are to rank the best, most usable, functional, and informative sites first. By intertwining your site's content and performance with these goals, you can help to ensure its long-term prospects in the search engine rankings.
Usability
Usability represents the ease-of-use inherent in your site's design, navigation, architecture, and functionality. The idea behind the practice is to make your site intuitive so that visitors will have the best possible experience on the site. A whole host of features figure into usability, including:- Design
The graphical elements and layout of website have a strong influence on how easily usable the site is. Standards like blue, underlined links, top and side menu bars, logos in the top, left-hand corner may seem like rules that can be bent, but adherence to these elements (with which web users are already familiar) will help to make a site usable. Design also encompasses important topics like visibility & contrast, affecting how easy it is for users to interest the text and image elements of the site. Separation of unique sections like navigation, advertising, content, search bars, etc. is also critical, as users follow design cues to help them understand a page's content. A final consideration would also take into account the importance of ensuring that critical elements in a site's design (like menus, logos, colors, and layout) were used consistently throughout the site.
Learn about Critical Components of Optimizing a Web Site
Each of the following components are critical pieces to a site's ability to be crawled, indexed, and ranked by search engine spiders. When properly used in the construction of a website, these features give a site/page the best chance of ranking well for targeted keywords.
The biggest problems in accessibility that most sites encounter fit into the following categories. Addressing these issues satisfactorily will avoid problems getting search engines and visitors to and through your site.
Accessibility
An accessible site is one that ensures delivery of its content successfully as often as possible. The functionality of pages, validity of HTML elements, uptime of the site's server, and working status of site coding and components all figure into site accessibility. If these features are ignored or faulty, both search engines and users will select other sites to visit.The biggest problems in accessibility that most sites encounter fit into the following categories. Addressing these issues satisfactorily will avoid problems getting search engines and visitors to and through your site.
What is SEO?
SEO is the active practice of optimizing a web site by improving internal and external aspects in order to increase the traffic the site receives from search engines. Firms that practice SEO can vary; some have a highly specialized focus, while others take a more broad and general approach. Optimizing a web site for search engines can require looking at so many unique elements that many practitioners of SEO (SEOs) consider themselves to be in the broad field of website optimization (since so many of those elements intertwine).
This guide is designed to describe all areas of SEO - from discovery of the terms and phrases that will generate traffic, to making a site search engine friendly, to building the links and marketing the unique value of the site/organization's offerings.
This guide is designed to describe all areas of SEO - from discovery of the terms and phrases that will generate traffic, to making a site search engine friendly, to building the links and marketing the unique value of the site/organization's offerings.
Why does my company/organization/website need SEO?
Network Engineer Interview Questions
General - -Describe whether you are a network admin or server admin?
-Are you currently or have you worked as a member of a team? If yes, name some of the challenges and how you handled them. Are you currently or have you worked as a member of a team? If yes, name some of the challenges and how you handled them.
-Do you prefer routing or switching?
-What are your strengths and weaknesses?
-How do you troubleshoot network slowness issues?
Switching -
-On a Cisco switch, when would you use a "ip default-gateway" command, and when a default route ip route 0.0.0.0 0.0.0.0 x.x.x.x
-You create an SVI on 3560 switch, and its IP does not respond to ping. What could be the problem?
-On 3560 switch -What command would you use to view the mac table?
-Are you currently or have you worked as a member of a team? If yes, name some of the challenges and how you handled them. Are you currently or have you worked as a member of a team? If yes, name some of the challenges and how you handled them.
-Do you prefer routing or switching?
-What are your strengths and weaknesses?
-How do you troubleshoot network slowness issues?
Switching -
-On a Cisco switch, when would you use a "ip default-gateway" command, and when a default route ip route 0.0.0.0 0.0.0.0 x.x.x.x
-You create an SVI on 3560 switch, and its IP does not respond to ping. What could be the problem?
-On 3560 switch -What command would you use to view the mac table?
Monday, 22 August 2011
Business Analyst Certification Interview Questions
Business Analyst Certification Interview Questions are the set of those questions which are posed in front of the candidates who have taken up a course in business analyst certification and are sitting for the final stage interview for getting the certification. These questions are framed by people who themselves know the working of a business analyst and are framed in such a way that the exact knowledge and skills of the candidate is judged correctly. Business analyst certification is a course which is taken up by people who are interested in jobs of business analysts.
Sample Business Analyst Certification Interview Questions:
Subscribe to:
Posts (Atom)