Global variable

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Depending on the platform on which you're executing, you should be able to get a CPU millisecond count using SYSTEM(9) and the current system time in milliseconds using SYSTEM(12); in the latter case you may (probably will) need to enable collection of milliseconds using compiler directive $OPTIONS TIME.MILLISECOND

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
trobinson
Participant
Posts: 208
Joined: Thu Apr 11, 2002 6:02 am
Location: Saint Louis
Contact:

Post by trobinson »

How do I format the oconv for milliseconds? The Help examples are only to the second. I'm told by Ascential that DataStage 5.2.1 on HP-UX 11.11, which is our system, cannot support milliseconds without a patch. This illustrates Ascential's overall shortcoming with designing a realtime architecture. They can come out with functional Realtime Bells and Whistles (7.0) and call it a silk purse but until they upgrade their core architecture to support real-time, its' still a sow's ear. How's that for mixing metaphors?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Well, if HP-UX can't deliver milliseconds, it is surely unreasonable to expect DataStage Engine to retrieve milliseconds from the operating system environment? DataStage Engine acquires system time by making calls to system functions.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
trobinson
Participant
Posts: 208
Joined: Thu Apr 11, 2002 6:02 am
Location: Saint Louis
Contact:

Post by trobinson »

Yeah, that would be unreasonable. However, it is a DataStage patch not a UNIX patch.
battaliou
Participant
Posts: 155
Joined: Mon Feb 24, 2003 7:28 am
Location: London
Contact:

Post by battaliou »

I've been playing with named pipes for temporary unix variables. You will need to create a named pipe using the mkfifo command, then you can echo to it and extract from it eg:
$ mkfifo martin
$ echo 88 > martin &
$ head martin

This remains fairly persistent, although it requires re initialisation after extract.
Post Reply