What is a DB2 access path?
Answer / guest
It is used to determine efficient way to access db2 tables.
| Is This Answer Correct ? | 4 Yes | 1 No |
What are catalog tables in db2?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
What is the syntax required for the creation of a cursor?
Which are the db2 tools to protect integrity of the database?
How do I add a column in db2?
What are the 4 environments which can access DB2 ?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
What is the connection string to connect to the DB2 Database ?
is there any restrictions for unions ?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
my project is insurance management system,how to explain my work environment in interview?