Solved

LOAD and long date formats

Posted on 2004-09-09
5
773 Views
Last Modified: 2012-06-21
Hello,

I'm experienced with databases but still new to DB2. I've been using the LOAD utility to load data and have done so successfully with dates of the form YYYY-MM-DD. Now I need to load data that contains dates in this format:

Mon DD, YYYY

Examples:

Jan 1, 2003
Jul 12, 2004

How do I do this?
0
Comment
Question by:yoren
  • 3
  • 2
5 Comments
 
LVL 13

Expert Comment

by:ghp7000
ID: 12023081
you will have to write either a UDF, a stored procedure or a c program to convert the date formats you have to valid dates. What is the source of your data, an excel data sheet?
0
 
LVL 7

Author Comment

by:yoren
ID: 12024130
Thanks for the response. So DB2 can't read that format natively? That's unfortunate. What's involved in writing a UDF (and what is it)? If I write one, will I be able to use the LOAD utility?

The source of the data is a proprietary database program. It can be made to export into YYYY-MM-DD, but the default is what I stated above. I was hoping to be able to handle the default format.
0
 
LVL 13

Accepted Solution

by:
ghp7000 earned 125 total points
ID: 12032540
no, db2 cant read the format, your easiest solution is to export to YYYY-MM-DD format.
0
 
LVL 7

Author Comment

by:yoren
ID: 12037417
Yet another reason to use Oracle! Too bad I have no choice in the matter.
0
 
LVL 13

Expert Comment

by:ghp7000
ID: 12039820
Well, its not such a big point, you can simply export the data from the source in the required format
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now