Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
mekrreddy
Participant
Posts: 88 Joined: Wed Oct 08, 2008 11:12 am
Post
by mekrreddy » Tue Mar 02, 2010 11:56 pm
I have to compare a hard coded time in hrs with current time in hrs. I think i can use @TIME, but dont know xactly how to use, can you guys give the syntax for @TIME plz,
your help is greatly appreciated..
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Wed Mar 03, 2010 12:58 am
CurrentTime()
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Mar 03, 2010 7:57 am
All of those "@" variables are documented in the help under the heading of System Variables.
-craig
"You can never have too many knives" -- Logan Nine Fingers
mekrreddy
Participant
Posts: 88 Joined: Wed Oct 08, 2008 11:12 am
Post
by mekrreddy » Wed Mar 03, 2010 10:59 pm
I did this using OCONV(@TIME, "MTS").
Thanks guys.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Wed Mar 03, 2010 11:08 pm
Did you do that in a server job or in a BASIC Transformer stage in a parallel job? Because Oconv() is not supported in the parallel Transformer stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
mekrreddy
Participant
Posts: 88 Joined: Wed Oct 08, 2008 11:12 am
Post
by mekrreddy » Thu Mar 04, 2010 12:39 pm
Sorry, I did this in Uservariable stage in seqence job.
Thanks.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Mar 04, 2010 3:14 pm
Cool.
A Sequence job is a special case of a Server job.
That's one reason server jobs are going to remain in the product indefinitely.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.