Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
IBM,
2008Post New DB Development Questions
What are the 18 schemas?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
Where is dbms used?
What are the main phases of database development?
Explain about relational database management systems?
What is DB Development software?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
How to combine two function together?
Who are end users in dbms?
How to generate OIDS
Which data type cannot be used as a parameter in a udf?
What are the three basic rules which are to be followed for the relational model of the database?
What are the three types of database design?
What are the key features of dbms?
Explain the role of indexing in databases?