CurrentTimestampMS - uservariable stage

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
Cherukuri
Participant
Posts: 46
Joined: Wed Jul 25, 2007 2:43 am
Location: India
Contact:

CurrentTimestampMS - uservariable stage

Post by Cherukuri »

Hi,

I have to pass the currect micros seconds with time using in the uservaraible stage but could'nt.
as exist in transformer the fucntion 'CurrentTimeMS()' is not avaiable in Uservariable stage expression tab..
I want the value like for example '08:04:25.697899' using uservariable stage that where i can pass the function for the current timestamp with micro seconds in sequence jobs.

Could any one please give inputs on this ...Thanks.

Regards,
Cheru
jwiles
Premium Member
Premium Member
Posts: 1274
Joined: Sun Nov 14, 2004 8:50 pm
Contact:

Post by jwiles »

As jobs sequences are at heart DataStage Server jobs, look at the Time() function and the documentation surrounding BASIC in Server jobs.

Regards,
- james wiles


All generalizations are false, including this one - Mark Twain.
Cherukuri
Participant
Posts: 46
Joined: Wed Jul 25, 2007 2:43 am
Location: India
Contact:

User variable micro seconds funcitons

Post by Cherukuri »

Please any one help to give a correct syntax.

Regards,
Cheru
adityavinay
Participant
Posts: 32
Joined: Tue Dec 13, 2011 7:27 am

Re: User variable micro seconds funcitons

Post by adityavinay »

Cherukuri,
use a execute command stage first with command ->date +%H:%M:%S.$(( $(date +%N) / 1000000 ))
if you want to set this as parameter to other activity stages - use command output of execute command stage.
Let me know if this works
Post Reply