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
ALTER TABLENAME
ADD COLUMN <COLUMN NAME> <DATATYPE>(<SIZE>)
Is This Answer Correct ? | 1 Yes | 0 No |
How to check last update on table in db2?
What is the difference between oracle and db2?
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
What types of tables are there in the db2 database?
For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?
How to handle null values in db2
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
What is cursor with hold option in db2?
What are the three types of page locks that can be held?