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.
how to take the back up of the DB2 table.
What is the use of COMMAREA ?Minimum how much data we can pass from it?
What is performance tuning db2?
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
What are some characteristics of columns that benefit from indexes?
what is the use of commit ? and what is the syntax?
Which component is responsible for db2 startup and shutdown?
What is schema in db2?
what happend with out using Commit,when closing cursor and program?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.