in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
Answer Posted / azharuddinsyed
ALTER TABLENAME
ADD COLUMN <COLUMN NAME> <DATATYPE>(<SIZE>)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
How to find schema of a table in db2?
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?
How do I delete a column in db2?
What are the 2 sqlcodes that are returned?
What do you mean by rollback?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What does reorg do in db2?
what is db2 restart?
How do I delete a table in db2?
What is ibm db2 connect?
What are the prerogatives?
What is the physical storage length of the data types date, time, and timestamp?