Can DB2 be accessed by TSO users? If yes, which command is
used to invoke DB2?
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
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
pls tell me abt the normalization five types....
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
How Plan is created while executing the query using SPUFI?
What do you mean by rollback?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Where would you find information about the type of database authority held by the user?
What is the physical storage length of timestamp data type?
How to resolve -502 sql code in DB2?
what is the use of bind parameter, Replace?