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 can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
How to create backup table in db2?
What is temporal table in db2?
select 100 records from million records ?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
What is commit in db2?
What is a DBRM, PLAN ?
What are db2 objects?
I use CS and update a page. Will the lock be released after I am done with that page?
what is parm utility
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?