IBM AS400 Interview Questions Explanations

Aired Consulting 12/26/2009 No Comment

IBM AS400 Interview Questions and Answers.

COBOL400 Interview Questions, DB400 Interview Questions.

A program variable coded in an Embedded SQL statement is referred to as?
Answer :
Host Variable

Which of the CL command can be used to determine which logical files are dependent on a specific file?
Answer :
DSPDBR

What does DFU program you to do on a record?
Answer :
Insert, Update Delete & File Enquiry.

When are the Unique Constraints executed?
Answer :
During Insert.

When are the Referential Constraints executed?
Answer :
Insert, Update & Delete.

How many triggers can be associated with a file?
Answer :
6(Maximum)

Why is the Declare cursor statement is used for?
Answer :
To define & name the cursor & specify rows to be fetched.

What do we can do with the Embedded SQL statements?
Answer :
We can Insert/Update/Delete records, fetch records, fetch values from records into variables.

Which CL command is used to trap error messages during program execution?
Answer :
MONMSG

Which CL command can be used at program execution to redirect the file named in an RPG program?
Ans
:OVRDBF

What is the length of the variable in the given example?
Answer :
DCL VAR (&Name) TYPE (*Char)? Default 32 & for Decimal 15,5
We can determine weather a record is in use bye another user with the help of status code (*STATUS). If
*STATUS = 01218 i.e. record already locked.

How to write *PSSR ?
Answer :
It just similar to any other subroutine.
*PSSR BEGSR
………………
………………
…………….
ENDSR

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

What is Procedure Prototype and Procedure Interface.
Answer :

Procedure Prototype
In this section we specify the name of the procedure along with PR.
D PROC1 PR
Procedure InterfaceIt 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

How to define a procedure ?
Answer :

First we have define Procedure Prototype along with all parameter. And PR.
D PROC1 PR
Then define Procedure with Begin/End
Procedure Name Begin/End
P PROC1 B Export
Then define Procedure Interface along with parameter and PI
D PROC1 PI 5 0
D PARMA 5 0
D PARMB 5 0
Define all the parameters as a variable to the procedure
D PARMA S 5 0
D PARMB S 5 0
In not returnable procedure, the procedure should end with
C PROC1 E
In returnable procedure, it should end with
C RETURN PARMA + PARMB
Related Posts

No comments:

 

Aired | Copyright © 2009-2014| All Rights Reserved 2014 | Privacy Policy and Disclaimer

Contact Us | About Us