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?
I have a table which has thousand of records i want to
fetch only record num 100 to record num 200. Write a query
that satisfies this criteria.(Cant use any keys)
Anyone please reply ASAP!
quary for
1> fetch last record
2> fetch in reverse order
3> fetch last 5 row
4> fetch second last record (their is no primary key)
i think concept of count can be use for this in 4th
what will be the output of the below given query, if no
matching records are found : (a.) 0 (b.) null (c.) error
select Avg(salary)
from TableA
where Deptno = 'insurance'
db2 query
I have one table with the following details.
SNO SNAME DOJ
------ -------------------- ----------
10 KRISH 2007-03-19
20 REDDY 2007-05-19
30 RRRRR 2007-05-19
40 BBBBB 2008-05-19
50 CCCCC 2009-05-19
60 JJJJJ 2009-05-19
70 JJJJJ 2004-05-19
i want the output in the following format:( no of students
joined in each year(no nedd to consider about month and
date)
year count
--------- ----------
2004 1
2007 3
2008 1
2009 2
What is normalization and what are the five normal forms?
110
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?
DB2 can implement a join in three ways using a merge join,
a nested join or a hybrid join. Explain the differences?
91
Hello All,
We have requirment to Replace BMC Db2 Load product thru CA
FAST LOADPlus product. Do anyone have JCL to for FAST
LOADPLUS and what all are thing need to take in
consideration.
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map