Is it possible using max on a char column?
What is -904 sql code? How to resolve it?
Name the various locking levels available?
what is the difference between normal select query and currosor
What does runstats do in db2?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
What is the function of the Data Manager?
What is the default page size of buffer pools?
Is db2 a programming language?
What is a lock?
Name some fields from SQLCA
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?
What is a synonym? How is it used?