What is ALTER ?

Answer Posted / jitendra

ALter is to change db2 table definition. for eg:
Alter tablename
add column number(11,2)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is precompiler in db2?

587


What is with ur in db2?

760


How do you stop a db2 database in linux?

568


What is a cursor in programming?

596


What is db2?

743






What is the reason behind not using select * in embedded sql programs?

603


What is scrollable cursor in db2?

583


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.

2757


What is view db2?

626


What is reorg and runstats in db2?

696


What is declare cursor?

613


What is a db2 package?

599


Why select is not preferred in embedded sql programs?

715


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2379


define clustering index.

618