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 |
Describe the elements of the SELECT query syntax?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
pls explain the precompilation process of cobol-db2 pgm
When do you use the IMAGECOPY?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
what is cursor stability?
What is the syntax for creating a table in the db2 database?
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
Is schema the same as database?
how do we solve soc 7 and soc4 ?
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?