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,
2227Post New DB Development Questions
What is data modeling with example?
How can you fix a poorly performing query?
What is DB Development software?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
What are the three basic rules which are to be followed for the relational model of the database?
What is an application role and explain a scenario when you would use one?
fact table and dimension table containg one to many relationship or many to one relastionship
How is data stored in dbms?
How can you log an error to the server event log from a stored procedure?
How to generate OIDS
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
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?
How to read and create .LDC data files which are used by linguatic dictionary.
What is database design and development?
What are the constraints on severity level in raiseerror?