Question { 5093 }

how to view clusters that has more than 10000 records

Answer

One option is using File Aid. Open File in Browse mode
using file aid F.1

Question { Syntel, 16122 }

In BIND, isolation level parameter specifies the duration
of page lock and ACQUIRE, RELEASE also do almost the same
thing. What is the exact difference between the two? Do
they work in conjunction while executing SQL queries and
obtaining locks?

Answer

(1) Isolation specifies type of lock that should be used
(2) Acquire tells when the lock should be acquired
(3) Release tells when it should be unlocked

Question { Wipro, 12803 }

What does MAXCC 3 means? It is used in one my codes.

Answer

File-Aid batch utility return RC-3 when file is empty

Question { IBM, 5833 }

Please let me know at which Scenarios we will go for STATIC
call or DYNAMIC

Answer

If it is static call. More memory will be utilized as the
called program is also included in the compilation.
Compilation mightslightly take more time when comapred with
dynamic calls.Dynamic calls are always done at run time
and execution time for Dynamic calls might be more than
static calls.

Usage of static and dynamic calls depends on your
requirement, based on specific condition- Say when Var1=0 u
need to call PGM1 and whn Var1=1 u need to call PGM2 then u
have to go for dynamic call.

Question { IBM, 5833 }

Please let me know at which Scenarios we will go for STATIC
call or DYNAMIC

Answer

Dynamic calls are used when subprogram is called frequently.
===>
As far as i know, when submprogram is small it is better to
make static calls