what is the sqlcode -501

Answer Posted / rajesh patnana

cursor is already opened when we are trying to open again

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

662


How do I add a column in db2?

596


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

752


Why do we use cursor?

599


What is the reason behind not using select * in embedded sql programs?

603






Is ibm db2 free?

577


What is the maximum size of a char data type in db2?

588


What is bind package and plan in db2?

597


Mention data types used in db2 ?

681


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1938


What are the different types of base tables?

587


What is dbrm? What it contains? When it will be created?

595


What is cascading rollback?

624


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2324


How can deadlocks be resolved?

544