can all users have the privilage to use the sql statement select * (dml)?
No Answer is Posted For this Question
Be the First to Post Answer
Which component is responsible for processing sql statements and selecting access paths?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
When is the skeleton cursor table created?
What is database manager in db2?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
Explain how can you do the explain of a dynamic sql statement?
Can there be more than one cursor open for any program?
What is cursor with hold option in db2?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
What is host variable in db2 cobol?
What if we fail to give values in columns declared as NOT NULL ?
What is the difference between db2 and oracle?