I am writing date(YYYY-MM-DD from sequential file) to Hashed file, hashed file is storing in its internal integer format. I need to populate this date to Oracle table date field. Is there any way to populate date to target without doing any Iconv/Oconv conversions. I mean can we store the date as it is in hashed file.
Thanks
VS
storing Date(YYYY-MM-DD) in Hashed File
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA
storing Date(YYYY-MM-DD) in Hashed File
Regards
VS
VS
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you're reading YYYY-MM-DD as a VarChar from a sequential file and loading it into a hashed file as VarChar, there is NO WAY it can be converted into internal format.
Does your job look like this?
I've been seeing a number of developers lately interposing hashed files in data streams in this fashion. There is absolutely no reason to do so, apart from being paid more to come back and improve performance by removing them. ![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
Does your job look like this?
Code: Select all
SeqFile ------> HashedFile ------> ODBC
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.