Hi All,
Please help me out in finiding a way to do oracle INITCAP function in parllel jobs
Thanks in advance.
initcap function in parllel jobs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard. :D
Naveen's post informs you that you posted a question about parallel jobs in a server jobs forum.
You can perform the INITCAP function in Oracle itself, as part of your column selection clause in your SQL passed from DataStage.
There's no direct equivalent in parallel jobs but, in the Transformer stage you have Upcase, Downcase, Len, Substring and concatenate capabilities, so you could construct an appropriate expression.
Or you could create a Custom stage (buildop) or a parallel routine (both need C++ code) to perform the task.
Naveen's post informs you that you posted a question about parallel jobs in a server jobs forum.
You can perform the INITCAP function in Oracle itself, as part of your column selection clause in your SQL passed from DataStage.
There's no direct equivalent in parallel jobs but, in the Transformer stage you have Upcase, Downcase, Len, Substring and concatenate capabilities, so you could construct an appropriate expression.
Or you could create a Custom stage (buildop) or a parallel routine (both need C++ code) to perform the task.
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.