IBM DB/400 Online Assessment Test

Q 1. Which of the following order is correct for writing program that will modify report?

1. Modify the report specification to meet your requirements using your preferred technique.

2. To save the new report, use the method update(object, options) to overwrite the existing report in the content store with the new specification or method add(parentPath, object, options) to add a new report to the content store. Ensure that the search path you use for the new report is unique and that you do not overwrite another report.

3. Query the content store using the method query(objectPath, parameterValues, options) to retrieve the specification for your report. The query method returns an array of details, including the report. The specification is the value of the specification property for the returned report.

4. Use the method validateSpecification(specification, parameterValues, options) to confirm that the new report specification is valid.

Q 2. How to create a multi-member physical file?

Note: There can be multiple correct answers to this question.

Q 3. What is missing in following script so it could run properly?

CREATE PROCEDURE divide ( IN numerator INTEGER,
                             IN denominator INTEGER, 
                              OUT divide_result INTEGER )
  LANGUAGE SQL
    BEGIN
       DECLARE overflow CONDITION FOR '22003';
      // ....
           RESIGNAL SQLSTATE '22375';
       IF denominator = 0 THEN
           SIGNAL overflow;
       ELSE
           SET divide_result = numerator / denominator;
       END IF;
     END