ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » IBM IIB-Date format conversion in Mapping file

Post new topic  Reply to topic
 IBM IIB-Date format conversion in Mapping file « View previous topic :: View next topic » 
Author Message
ajayrana
PostPosted: Thu May 08, 2014 1:53 am    Post subject: IBM IIB-Date format conversion in Mapping file Reply with quote

Apprentice

Joined: 08 May 2014
Posts: 35
Need some help on date format conversion in mapping files.
We are trying to read a fixed length file with the help of DFDL and push the data into some table with a mapping file.
The DFDL reads the date elements correctly from the file correctly.
The issue comes when we are trying to insert the same into ORACLE database column with type date.
It gives the below error :
ORA-01861: literal does not match format string
(Element in DFDL and DB column are both set to date)

Also, we are using the current date time function for one of the date column which works perfectly. Below is the format in which it is getting stored :
5/8/2014 5:53:24 AM
And if we store the date coming from DFDL element in some string column it is getting stored as :
2014-02-01T00:00:00.000

Last edited by ajayrana on Tue May 27, 2014 10:29 pm; edited 1 time in total
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Thu May 08, 2014 4:23 am    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
Did you set the elements to be represented by their types?
Looks like your date is not in broker default time format but rather in ISO datetime format... Make sure it is effectively represented either in a broker date format or broker TIMESTAMP.

May be you need to reformat before passing to Oracle...

Have fun
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
DirtyHowi
PostPosted: Thu May 08, 2014 5:19 am    Post subject: Reply with quote

Novice

Joined: 17 Feb 2014
Posts: 22
try xs:datetime in the mapping instead of convert (which does not seem to work for dates).

we have the same issue going from a cobol copy book to a .net input object, and found that for straight dates that are CCYY-MM-DD that xs:date works without a hitch.
Back to top
View user's profile Send private message
ajayrana
PostPosted: Fri May 09, 2014 6:14 pm    Post subject: Reply with quote

Apprentice

Joined: 08 May 2014
Posts: 35
Thanks for the reply !! it seems the issue was with one of the DFDL date elements. I created the that section of the DFDL again and it started working.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » IBM IIB-Date format conversion in Mapping file
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.