date conversion
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 19
- Joined: Tue Feb 01, 2005 11:46 pm
date conversion
hello.,
i am new to datastage.
my inut date format is : YYYY-MM-DD
THE Output date format has to be : DD-MM-YYYY
can anyone please tell me how do i do it in transformer.
also can anyone please tell me how do i set flag status to either YES or NO in a transformer.
thanks
mark
i am new to datastage.
my inut date format is : YYYY-MM-DD
THE Output date format has to be : DD-MM-YYYY
can anyone please tell me how do i do it in transformer.
also can anyone please tell me how do i set flag status to either YES or NO in a transformer.
thanks
mark
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Did you search the forum? What did you turn up? This post for example may prove informative.
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.
hi mark,
As ray indicated, if u make a search in this forum, you can get at most all of your basic doubts cleared.
you can acheive your requirement by many ways,
one way can be as follows
And regarding your flag setting, is that u want to set a column as YES and NO based on any other column or a value, is this case u can very well use
-kumar
As ray indicated, if u make a search in this forum, you can get at most all of your basic doubts cleared.
you can acheive your requirement by many ways,
one way can be as follows
Code: Select all
Oconv(Iconv("data value","D2-YMD[422]),"D2-DMY[224])
Code: Select all
If <condition1> Then "YES" Else "NO"
Saravanan, i never knew this.elavenil wrote:This OConv/IConv functions available when you use Basic transformer not for Parallel transformer. Pls keep in mind that when you use transformer to achieve this.
do mean to say that the transformer in parellel extender is quite different from the server edition transformer stage.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It is VERY different. For a start it generates C++ rather than BASIC. Try it; you will see different operands in the expression editor. And you will see "data type" as an extra grid in stage variable declaration (one of the more common traps for those converting from server jobs).
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.
-
- Premium Member
- Posts: 37
- Joined: Wed Mar 23, 2005 5:20 am
clarification..
hi saravan,
kindly tell me what does D2-YMD[422]),"D2-DMY[224] this part of the IConv function exactly... does??
naraine.
kindly tell me what does D2-YMD[422]),"D2-DMY[224] this part of the IConv function exactly... does??
naraine.
Re: clarification..
hi naraine,narayana_382 wrote:hi saravan,
kindly tell me what does D2-YMD[422]),"D2-DMY[224] this part of the IConv function exactly... does??
naraine.
it i simply converting
Code: Select all
YYYY-MM-DD formate to DD-MM-YYY
Do a search in this forum or go thorugh the document for more clear information.
regards
kumar
Re: clarification..
YMD corresponds to year/month/day....the [422] indicates a format like YYYY-MM-DDnarayana_382 wrote:hi saravan,
kindly tell me what does D2-YMD[422]),"D2-DMY[224] this part of the IConv function exactly... does??
naraine.
DMY[224] ---> DD-MM-YYYY
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Kumar,
go to the on-line PDF manuals and open up Ascential DataStage Basic Guide to page 804; it will explain the date conversion codes.
go to the on-line PDF manuals and open up Ascential DataStage Basic Guide to page 804; it will explain the date conversion codes.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>