Solved

LOAD and long date formats

Posted on 2004-09-09
5
779 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
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…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

867 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

15 Experts available now in Live!

Get 1:1 Help Now