As far as I know, there is no standard function in Datastage called DateIconv, if it is, please let me know where I can find it. I am assuming that it might be some custom transform that you guys wrote yourself.
Sorry guys, maybe it is. It was authored by a name I didn't recognize, but maybe another consultant imported it while on contract. It's simple really - parses the input for the format and spits it out as an Iconv. Nothing to it. The last posting is much simpler!
cheers,
Heather
what a man is contributes much more to his happiness than what he has, or how he is regarded by others.
Suggestion to all employers of consultants: make sure (a condition of hire?) that anything the consultant leaves is tagged with the consultant's contact details, and some kind of warranty as to fitness for purpose (plus, maybe, some form of support undertaking).
You won't regret it.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Suggestion to all consultants of employers: include something like this in all your work.
This code is provided "AS IS" without warranty of any kind, either expressed or implied, including, but not limited to, the implied warranties of merchantability, fitness for a particular purpose, or non-infringement.
(just joking Ray)
-craig
"You can never have too many knives" -- Logan Nine Fingers