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
- 1 Answers
- 2644 Views
- TCS, I also Faced
- E-Mail Answers
ALTER TABLENAME
ADD COLUMN <COLUMN NAME> <DATATYPE>(<SIZE>)
| Is This Answer Correct ? | 1 Yes | 0 No |
Mention some fields that are a part of sqlca.
List out the data types available.
What is the max length of sqlca?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
What is isolation level?
Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How will you delete duplicate records from a table?
What are catalog tables in db2?
what's the error code for Unique Index Violation?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
How to create db2 table in mainframe?
COBOL 
