hi,
pls give any help for converting iconv&oconv functions to px.
1) in server i have
Oconv (Iconv (Txfm_input.PMMDATETIME[1,6],'D/DMY'),'D-YMD[4,2,2]')
i need to convert this to px.
2) Oconv ((toTrans.CALLG_PARTY_NO),"MCN") to PX.
3) fmt() function tell me use in server jobs
thnks
venkat
convertiong iconv& oconv functions to px.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 94
- Joined: Fri Dec 14, 2007 3:22 am
1) This depends upon your input data type, if it is string then you need DateToString() with the right output mask. If it is date, then no function is required, just change the date representation mask in your output stage by going into the columns tab, right click on your date column and go to extended properties.
2)You can use a CONVERT() function that converts all non numeric characters to an empty space.
3)It depends what you are trying to achieve with the FMT() function.
2)You can use a CONVERT() function that converts all non numeric characters to an empty space.
3)It depends what you are trying to achieve with the FMT() function.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 94
- Joined: Fri Dec 14, 2007 3:22 am
thnks to kumar and dsguru
my problem is input field i.e. PMMDATETIME as a timestampe datatype. i need to convert this to store date in one output column and hrs (hh) to other output column.
thnks
venkat
thnks
venkat
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Then (a) stop thinking like a server developer in your Iconv/Oconv rut, (b) explore all the date/time conversion functions that are available (Appendix A of Parallel Job Developer's Guide would be a good place to start) and (c) be prepared to experiment.
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.