Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

COBOL,DB2 Interview Questions

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
deepthimadhu

New User


Joined: 03 Mar 2009
Posts: 12
Location: Trivandrum

PostPosted: Mon Dec 07, 2009 10:16 am    Post subject: COBOL,DB2 Interview Questions
Reply with quote

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
INTO :ws-dept-name
FROM department
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.
Back to top
View user's profile Send private message

deepthimadhu

New User


Joined: 03 Mar 2009
Posts: 12
Location: Trivandrum

PostPosted: Mon Dec 07, 2009 10:41 am    Post subject:
Reply with quote

I missed out one question

What is the difference between SPUFI and QMF?

SPUFI
a. Return codes for the queries are obtained.
b. The result is directly stored in a data set.
c. Multiple queries can be executed at the same time.
d. Result appears in a less organised manner.

QMF
a. Return codes for the queries are not obtained.
b. The result is not stored in a data set.
c. Only a single query can be executed at a time.
d. Result appears in an organised manner.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Dec 07, 2009 2:51 pm    Post subject:
Reply with quote

So should we learn from these answers or you've some question(s)? icon_smile.gif
Back to top
View user's profile Send private message
deepthimadhu

New User


Joined: 03 Mar 2009
Posts: 12
Location: Trivandrum

PostPosted: Mon Dec 07, 2009 4:58 pm    Post subject:
Reply with quote

I just posted the questions that I came across in an interview. icon_biggrin.gif

Correct me if any of the answers are incorrect or if anything else needs to be added.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Dec 07, 2009 5:02 pm    Post subject:
Reply with quote

deepthimadhu wrote:
Correct me if any of the answers are incorrect or if anything else needs to be added.
Did you hear back from them, interviewers? icon_biggrin.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts XML Parse for COBOL 5.2 Bhanu Praveen COBOL Programming 1 Sat Jul 08, 2017 8:58 pm
No new posts Dynamic output file creation in cobol... smileheal COBOL Programming 7 Thu Jun 15, 2017 10:53 pm
No new posts Search utility(3.14) using JCl and Cobol RKS3 COBOL Programming 12 Sat Jun 10, 2017 10:24 pm
No new posts COBOL DB2 program - zIIP eligible vasanthz COBOL Programming 7 Wed May 31, 2017 5:12 am
This topic is locked: you cannot edit posts or make replies. Cobol GUI (like Editor) Kala Mainframe COBOL Programming 14 Wed May 10, 2017 12:30 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us