DSXchange

All links are buffered, at least by default, which basically means that you can't control the speed at which they process rows. You might try changing the buffering policy to "do not buffer", but that will slow things down somewhat. And I don't guarantee it, since I've never tried it in th...

Convert the date to a Julian date (an integer) and get the max of that. Convert back to a date when needed.

Easily done - use a sequence with a loop that includes a sleep command to wait until 7:00am.

But consider including some mechanism for shutting down your always-on job, for those times when, perhaps, an upgrade is necessary or even for when it's desired to take a system backup.

It depends on how you're doing your incremental load. If all you're interested in is matching in the new data then no, use an unduplicate match. If you want to compare the new data against the existing data in the target then use a reference match.

%d matches a single digit in the date. %dd matches two digits in the date. %dd,v allows the format to be variable (one digit or two). There are other variations.

Try using NVarChar as the data type.

Please mark this thread as Resolved

Why not just use these statements as user-defined SQL?

No. It's because TZ wasn't set in the environment of the user acting as the agent process of your client (probably dsapi_server or dsapi_slave).

Our guessing capacity is limited.
What is the expected result? What is the actual result?

The most useful reports are those that answer the questions that the business users have. You gave no indication about what these are.

For example, are they interested in violations (such as out of range values), are they interested in compliance with data rules, and so on?

The first numeric part is the time and the second numeric part is the date that the program started, both in DataStage server internal format (number of seconds since midnight and number of days since 1967-12-31 respectively).

No One ?? Funnily enough, some of us have to work for a living, sleep, fly to other cities, and all kinds of other things that mean we can't monitor DSXchange 25x8 just for your benefit. DSXchange is an all-volunteer site whose members post as and when they can. There is no compulsion for them to d...

What do you mean by "other system" in this context - another client? It can be the case, when a player process on one node fails but all player processes on other nodes finish successfully before the error reporting from the failed node arrives and is processed by the conductor, that the p...

You need to determine under what circumstances the /datafs3/Datastage_Resources/BI/Scripts/Load_Incremental.sh script can generate an exit status of 1.