| Author |
Message |
rythms
Participant
Joined: 29 May 2010
Posts: 3
Points: 18
|
|
| DataStage® Release: 8x |
| Job Type: Parallel |
| OS: Unix |
|
Hi,
I am getting an error as 'Oconv not defined' when I use the following transform function (in parallel job) to convert mm/dd/yyyy date format to mmddyyyy.
OConv(IConv(DSLink3.BTH_DT, "D/MDY[2,2,4]"), "DMDY[2,2,4]")
Can someone please tell me help me.
Thanks.
|
|
|
|
|
|
anbu
Group memberships:
Premium Members
Joined: 18 Feb 2006
Posts: 377
Location: india
Points: 1492
|
|
|
|
|
|
Oconv and Iconv are not available in Parallel transformer. You can these functions in BASIC transformer.
You can use convert function to convert mm/dd/yyyy date format to mmddyyyy
| Code: |
| Convert("/","",DSLink3.BTH_DT) |
|
_________________
You are the creator of your destiny - Swami Vivekananda |
|
|
|
|
chulett
since January 2006
Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group
Joined: 12 Nov 2002
Posts: 28887
Location: Denver, CO
Points: 149307
|
|
|
|
|
|
|
If your conversion is simply the removal of the delimiters then what anbu posted should work fine for you. If it doesn't then let us know what your target for this "date" is...
|
_________________
-craig
And as in uffish thought he stood, the Jabberwock, with eyes of flame,
Came whiffling through the tulgey wood, and burbled as it came!
|
|
|
|
|
rythms
Participant
Joined: 29 May 2010
Posts: 3
Points: 18
|
|
|
|
|
|
Appreciate your inputs.
The output I am getting now is in the format YYYY-MM-DD but I wanted it to look MMDDYYYY. My source is a db and target is a sequential file with output column format as Date.
Thanks again.
|
|
|
|
|
|
ray.wurlod
Participant
Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group
Joined: 23 Oct 2002
Posts: 41029
Location: Canberra, Australia
Points: 228711
|
|
|
|
|
|
The functions you require are StringToDate() and DateToString().
Research these in the
Parallel Job Developer's Guide
|
_________________
Zenith Solutions (Australia) Pty Ltd
-- from obscurity to
clarity
|
|
|
|
|
rythms
Participant
Joined: 29 May 2010
Posts: 3
Points: 18
|
|
|
|
|
|
|
