How to execute stored procedures?
No Answer is Posted For this Question
Be the First to Post Answer
Mention some fields that are a part of sqlca.
how to take the back up of the DB2 table.
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 techniques are used to retrieve data from more than one table in a single SQL statement?
In terms of DB2 indexing, what is the root page?
What is the result of open cursor statement?
What is a thread?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
What is a dbrm in db2?
Explain dclgen.
What is the role of union all and union
What do you mean by NOT NULL WITH DEFAULT? When will you use it?