Highlight all the advantages that are attached to a package.
No Answer is Posted For this Question
Be the First to Post Answer
What is coalesce in db2?
What are union and union all?
What is the physical storage length of the data types date, time, and timestamp?
How to insert more than one record using insert?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What are bind parameters in db2?
What is the difference between Where and Having Clause
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
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
On the create tablespace, what does the CLOSE parameter do?
What is a db2 cursor?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?