Mention and explain the contention situations caused by locks?
what is SMP/E? and what are the major steps of it? thanks...
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What does the sqlcode of -818 pertain to?
What is rct?
What is the SQL query to select, delete and get count of duplicate rows in DB2?
What is netezza database?
What is bind plan?
What are common abends
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?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is database alias db2?
what is Runstats? Whem will u choose to runatats?