GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Mainframe  >  DB2
Go To First  |  Previous Question  |  Next Question 
 DB2  |  Question 179 of 195    Print  
If Sql return -805 , what will user want to do

  
Total Answers and Comments: 1 Last Update: May 09, 2008     Asked by: sprabodhini 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
May 09, 2008 05:37:44   #1  
rajasekhar24 Member Since: May 2008   Contribution: 1    

RE: If Sql return -805 , what will user want to do
Bind the database to avoid the -805 error.

The package was not bound or it was dropped. If attempting to run a DB2 utility or CLI application, the DB2 utilities may need to be rebound to the database.

'%.pkgname' if the CURRENT PACKAGE PATH is set but no package with the name 'pkgname' could be found in any of the schemas in the CURRENT PACKAGE PATH.

 
Is this answer useful? Yes | No

 Related Questions

An embedded sql statement may return a number of rows while the programming language can only access one row at a time. The programming device called a cursor controls the position of the row.  
Latest Answer : hi friends,             In DB2 actually we use CURSOR when there are more than one row to be fetched in a SELECT statement. ...

SQL statements may return any number of rows, but most host languages deal with one row at a time by declaring a cursor that presents each row at a unique isolation level.  

It is a data structure that must be included in any host-language program using SQL. It is used to pass feedback about the sql operations to the program. Fields are return codes, error messages, handling 
Latest Answer : SQLCA is t communication area wher v can check t return codes, no of updated , deleted records it contains SQLCODE, SQLERRD, SQLERRM etc..... ...

Latest Answer : You should use cobol defined variable RETURN-CODE in you cobol program ...

Which of the following is not a purpose of a View ?a.To simplify the appearance of data to different usersb.To control access to a tablec.To show more meaningful data, such as summaryd.To store data separately 
View Question | Asked by : radibioinfo

Table1 has 6 rows and Table2 has 6 SELECT * FROM Table1, Table2; a.6b.12c.36d.720e.Cannot sayrows.36 
View Question | Asked by : radibioinfo

Latest Answer : Bind the database to avoid the -805 error.The package was not bound or it was dropped. If attempting to run a DB2 utility or CLI application, the DB2 utilities may need to be rebound to the database.'%.pkgname' if the CURRENT PACKAGE PATH is set ...

If, for a given table, the Control Center does not show the choice Generate DDL, which of the following describes the reason? A. The table is a system object. B. The table is a summary table. C. The table 
View Question | Asked by : suvidha

If, for a given table, the Control Center does not show the choice Generate DDL, which of the following describes the reason? A. The table is a system object. B. The table is a summary table. C. The table 
View Question | Asked by : suvidha


 Sponsored Links

 
Related Articles

printf() Function Return Value

What is the return value from printf() function? printf function always returns the number of characters printed. Let us understand this with an example: main() { int a=10; printf("%d",printf("%d %d %d", a,a,a)); } In this above program the inner printf i
 

What is the default return value of a function?

The default return value from a function is int. In other words, unless explicitly specified the default return value by compiler would be integer value from function.   When a programmer wants other than integer values to be returned from function then it is essential that the pro
 

exit and return statements

  How does the exit () and return () differ exit () is used to exit the program as a whole. In other words it returns control to the operating system. After exit () all memory and temporary storage areas are all flushed out and control goes out of program. In contrast, the return () stateme
 

The Interview Snafu

How to turn someone else’s mistake to your advantage Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de
 

Winning a Job Interview with a Winning Resume

Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof
 

Mainframe Features

Mainframe Features In this Mainframe tutorial you will learn about features of Mainframe Processing power memory capacity performance computing multiple operating system time sharing reliability serviceability availability clustering technology and other features available in Mainframe mosgoogle cen
 

Importance of Proper English during Job Interview

Importance of Proper English during Job Interview Your job interview is crucially important and it will determine whether or not you will get the job Depending on the type of job you re going for it is very important for you to use proper English In most cases jobs which offer higher salaries will h
 

How Ajax Can Become as User Friendly as Flash

How Ajax Can Become as User Friendly as Flash There are a number of reasons why Flash has become so popular on the web today and this lies in the fact that users don t have to reload the page Products such as Flash Remoting will allow users to access the background server and Ajax can do the same th
 

HR Interview - HR Interview Mistakes You Will Want To Avoid

HR Interview Mistakes You Will Want To Avoid The job interview can be a stressful process This is especially true for those who are going after a competitive position Your nonverbal communication combined with the answers you give during the interview will determine if you are hired mosgoogle While
 

HR Interview - Behavioral HR Interviews

Behavioral HR Interviews As the name implies a behavioral interview is an interview that is held by a human resources department to determine if an applicant has the behaviors that are appropriate for a job The company must know how an applicant will behave in a certain situations mosgoogle The logi
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape