How do I add a column in db2?

1088

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2155

Which component is used to execute the sql statements?

1141

What is a db2 cursor?

1106

What is role in db2?

1157

What is a bind in db2?

1100

How do I import a csv file into db2?

1037

How do I create a view in db2?

1072

What are the full forms of spufi and dclgen and why are they used?

1136

What is dbrm? What it contains? When it will be created?

1099

What is the syntax for creating a table in the db2 database?

1144

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2433

What is the clustering index in the db2 database?

1044

Explain correlated sub-queries.

1092

What is a trigger in the db2 database?

1137