IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2: How to solve -805 DB2 Sql code


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
trushant.w

New User


Joined: 22 Sep 2013
Posts: 81
Location: pune india

PostPosted: Fri Oct 04, 2013 3:47 pm
Reply with quote

Hi All,

I came across the question
How to solve -805 DB2 Sql code

As i know it is plan/package not found error.I answered we have to provide correct plan/pckage name in SYSTSIN card.

But it look like they were not satisfied with the answer.I work in project where all this thing are done by tool,so i have never done it manually.

Please put some light on it.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19245
Location: Inside the Matrix

PostPosted: Fri Oct 04, 2013 6:53 pm
Reply with quote

Hello,

Who are "they"?

Have you read all of the info in the IBM manual about a -805?
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnmcj10/2.1.6.398?

It looks like the "answer" in the book says a lot more than you answered.
Back to top
View user's profile Send private message
Joseph Reynolds

New User


Joined: 07 Oct 2013
Posts: 6
Location: United States

PostPosted: Tue Oct 08, 2013 12:19 am
Reply with quote

I have asked the same general question during an interview.

While understanding how to solve the -805 is a skill to have, it may be as well-served to demonstrate understanding of how to get a program into productive use. By understanding this, the reason for the -805s fall into place and can be avoided.

Here is what I typically ask:

What is the compilation process for a <COBOL> program?

What things are produced, for example, program listing? (Probe to see if the interviewee provides DBRM as an object produced, and what it is).

How do the compilation artifacts 'come together', and get run?

etc.

-805s are due to a lack of experience, understanding or attention to the over-all process. Handling -805s are best done by preventing them.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19245
Location: Inside the Matrix

PostPosted: Tue Oct 08, 2013 12:27 am
Reply with quote

Hello and welcome to the forums,

Quote:
Handling -805s are best done by preventing them
Yup, agreed for sure!

People new to an environment should be provided with the "correct way to do it here".

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts IEF085I REGION UNAVAILABLE,ERROR CODE... Java & MQSeries 0
No new posts How to convert RESP code 12 to text? CICS 9
No new posts Execute step regardless of previous s... JCL & VSAM 2
No new posts Error 0C1 Reason Code 1 with branch i... PL/I & Assembler 3
No new posts JCL for replacing code in Cobol JCL & VSAM 7
Search our Forums:

Back to Top