Name the various locking levels available?
No Answer is Posted For this Question
Be the First to Post Answer
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
Are view updateable?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
Explain package in db2 and its advantages?
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
How do I import data from excel to db2?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
Comment whether the cursor is closed during commit or not.
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
What is read-only cursor?
What does db2 stand for?