ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  MainFrame  >>  IBM MainFrame  >>  DB2
 
 


 

 
 COBOL interview questions  COBOL Interview Questions
 JCL interview questions  JCL Interview Questions
 CICS interview questions  CICS Interview Questions
 DB2 interview questions  DB2 Interview Questions
 IMS interview questions  IMS Interview Questions
 IDMS interview questions  IDMS Interview Questions
 Natural interview questions  Natural Interview Questions
 ADABAS interview questions  ADABAS Interview Questions
 REXX interview questions  REXX Interview Questions
 Assembler interview questions  Assembler Interview Questions
 CLIST interview questions  CLIST Interview Questions
 QMF interview questions  QMF Interview Questions
 MVS interview questions  MVS Interview Questions
 OS390 interview questions  OS390 Interview Questions
 OS 2 interview questions  OS 2 Interview Questions
 VSAM interview questions  VSAM Interview Questions
 QSAM interview questions  QSAM Interview Questions
 Sysplex interview questions  Sysplex Interview Questions
 IBM MainFrame AllOther interview questions  IBM MainFrame AllOther Interview Questions
Question
How to resolve -504 sql code in DB2?
 Question Submitted By :: Vikram And Mangesh
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to resolve -504 sql code in DB2?
Answer
# 1
Hi,
-504 is cursor not declared error.may be cursor name 
misspeled also coming this error.
 
Is This Answer Correct ?    13 Yes 0 No
Kk
 
  Re: How to resolve -504 sql code in DB2?
Answer
# 2
There are following possibilities to this issue to come,
	1) Cursor is not declared in application program or 
in stored procedure depending on where it is used. 
		Soln - Declare the cursor in application 
program or in stored procedure depending on where it is 
used.
	2) Cursor spelling is not correct which you are 
going to open or fetch.
		Soln - Check the name used and correct.
 
Is This Answer Correct ?    2 Yes 0 No
Anandrao
 
 
 

 
 
 
Other DB2 Interview Questions
 
  Question Asked @ Answers
 
what is a plan and how do you refer the plan in the program? Xansa2
What is an alias?  2
If I have a view which is a join of two or more tables, can this view be updatable?  2
where can we use index and subscript ? with example ? CTS2
How do you prepare a COBOL + DB2 program from coading till execution ? Xansa1
What else is there in the PLAN apart from the access path?  1
What is the SQL Communications Area and what are some of its key fields?  1
Explain what a plan is? CTS2
What is a cursor and what is its function?  2
Can a array declared with an index be displayed(readable format) in spool? UST4
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?  1
What are the various locking levels available?  2
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help? Syntel3
can i code union in cobol-db2 pgm ? Patni2
When will you chose to run RUNSTATS?  1
What is referential integrity?  5
Explain transactions, commits and rollbacks in DB2.  3
Name some fields from SQLCA.  2
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?  2
Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.  1
 
For more DB2 Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com