Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Global Variable for all IP's in a collaboration


Mack Rienstra

Recommended Posts

I'm working with a Windows integration server and an IBM server and the IBM server clock loses 5.4 seconds each week (~ 5 minutes per year). Some queries run every 5 minutes and eventually start missing newly edited records.

I am able to query the clock value of each, deduct them and store this value. I would like to then use it in each of my 3 time-base queries for this collaboration.

i.e.

WHERE

O4MTTM > (LastRunTime - :Offset Minutes)

/* O4MTTM is the IBM timestamp, :Offset is the stored value of the clocks in decimal minutes */

However, if I store this value in the ScribeInternal DB I am not able to use it in a Source Query. I have not found a place within the DTS I can store it AND update it daily or weekly using a live DTS/IP. I'm currently updating a variable in each DTS manually on Mondays.

Is there a place to store a global variable that can be updated by a running IP Or, can a pre-operation process pass this to the DTS

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...