Regular readers of my blog know that from time to time I use the blog as a forum to answer questions I get via e-mail. Today, we address a popular theme - dealing with DB2 date data...Q:I have a DATE column in a DB2 table, but I do not want it to display the way DB2 displays it by default. How can I get a date format retrieved from a column in a table from DB2 database in the format MM/DD/YYYY?A:The simplest way to return a date in the format you desire is to use the built-in column function CHAR. Using this function you can convert a date column...
Tuesday, 28 October 2008
Wednesday, 22 October 2008
Bad Standards
Posted on 11:38 by Unknown
Just started a new series on bad standards over on my Data Management Today blog.Check it out when you get a chance and share your favorite "bad standards" either here or there... or by e-mailing ...
Monday, 20 October 2008
DBA Rules of Thumb
Posted on 09:24 by Unknown
Database administration is a very technical discipline, but it is also a discipline in which the practitioner is very visible politically within the organization. As such, DBAs should be armed with the proper attitude and knowledge before attempting to practice the discipline of database administration.Just as important as technical acumen, though, is the ability to carry oneself properly and to embrace the job appropriately. With this in mind, I wrote a series of blog entries on DBA Rules of Thumb over at my Data Management Today blog... and I...
Thursday, 9 October 2008
Assuring the Recoverability of Your DB2 Databases
Posted on 12:31 by Unknown
Availability requires much more than just having a reliable hardware and database platform. Most companies cannot afford significant downtime, and some cannot afford any! As such, it is crucial for unplanned outages to be as short as possible. But it is not just a business requirement, in many cases assuring a speedy recovery is also a legal mandate. Regulations such as SOX and Basel II dictate that any outage is resolved within a predefined period of time.But how many of us can answer, with any degree of certainty, the question “How long will...
Subscribe to:
Posts (Atom)
