What is the role of union all and union
No Answer is Posted For this Question
Be the First to Post Answer
What is dynamic SQL?
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?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
What is lock escalation?
What is a result table?
What kind of database is db2?
What is check constraint in db2?
What do you mean by NOT NULL? When will you use it?
Are views updatable ?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Define data page.
How do you retrieve the first 5 characters of firstname column of db2 table emp?