What is the advantage in De-normalizing tables in DB2?

1175

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8288

What is cobol db2?

1000

How does cobol compile db2 program?

1057

Which command is used to remove all rows from a table?

1110

How can deadlocks be resolved?

936

What is syscat in db2?

1010

How do you concatenate the firstname and lastname from emp table to give a complete name?

1076

Why do we need reorg in db2?

986

What is a buffer in memory?

1058

What is db2? Explain.

1043

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2535

How to run db2 command in windows?

1193

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

1050

What is an instance database?

1052