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
 

 

DB2: How to solve -805 DB2 Sql code

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
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    Post subject: DB2: How to solve -805 DB2 Sql code
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

Site Director


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

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

Hello,

Who are "they"?

Have you read all of the info in the IBM manual about a -805?
http://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    Post subject: Reply to: DB2: How to solve -805 DB2 Sql code
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

Site Director


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

PostPosted: Tue Oct 08, 2013 12:27 am    Post subject:
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    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 Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm


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