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 :