Joined: 03 Mar 2009 Posts: 12 Location: Trivandrum
1. What will happen if you give GO BACK in a main program
a. Nothing wrong will happen. The program would give the expected
results. You can either use STOP RUN or GO BACK in the main pgm.
2. What is -806 abend?
a. Load module not found.
3. SELECT dept_name
WHERE dept_no > 0;
Will the above query work fine?
a. The query would work fine if a single row is retrieved but would go
wrong if multiple rows are retrieved. A CURSOR should be declared for
retrieving multiple rows.
4. What is EXPLAIN?
a. EXPLAIN command gives explanation about the access paths in DB2
and provides explanation on how data will be accessed and how to
improve the performance of a command.
5. What is BIND in DB2?
a. BIND is used to create executable codes and access paths for the SQL
statements in the DBRM.
6. JUSTIFIED clause in COBOL.
a. JUSTIFIED RIGHT is used to allign data to the rightmost positon of the
receiving field. Default will be left justified.