Can anyone please tell me what this trim function actually does?
Trim(oconv(date(), 'DMD[2,2]')," ","A")
Trim function in a User Variable Activity
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 11
- Joined: Tue Nov 21, 2006 3:08 am
- Location: Pune
-
- Participant
- Posts: 11
- Joined: Tue Nov 21, 2006 3:08 am
- Location: Pune
-
- Premium Member
- Posts: 301
- Joined: Thu Jul 14, 2005 10:27 am
- Location: Melbourne, Australia
- Contact:
Are you having trouble accessing the online help?
If the help/documentation don't help you could try <a href="search.php">searching</a>...?Oconv(expression, conversion [@VM conversion] ...)
expression is a string stored in internal format that you want to convert to an output format. If expression is a null value, null is returned.
conversion is one or more conversion codes specifying how the string is to be formatted. Separate multiple codes with a value mark. If conversion is a null value, it generates a run-time error.
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Trim function in a User Variable Activity
Nothing at all in a parallel job.prajish_ap wrote:Can anyone please tell me what this trim function actually does?
Trim(oconv(date(), 'DMD[2,2]')," ","A")
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.
-
- Participant
- Posts: 11
- Joined: Tue Nov 21, 2006 3:08 am
- Location: Pune
Re: Trim function in a User Variable Activity
ray.wurlod wrote:Nothing at all in a parallel job. ...prajish_ap wrote:Can anyone please tell me what this trim function actually does?
Trim(oconv(date(), 'DMD[2,2]')," ","A")
The Developer has used the function in a User Variable Activity Stage in a Sequence Job
Why did you post in the PX forum, then?
Hint - go to the manager, create a new routine and enter the text Ans = Trim(oconv(date(), 'DMD[2,2]')," ","A") and compile then run it. You'll find out what that statement actually does.
Hint - go to the manager, create a new routine and enter the text Ans = Trim(oconv(date(), 'DMD[2,2]')," ","A") and compile then run it. You'll find out what that statement actually does.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Simple enough and the same advice applies. As noted, both the OConv and Date functions are documented so are something easily looked up. And any time you've got something like that you need to check, build a small routine in the Manager and use the 'Test' button to run it and see the actual output in a controlled environment.prajish_ap wrote:I actually wanted to know as to what this OConv function does..
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers