DSXchange

As delivered, that is the case. But you can readily adapt it - you need one extra variable to record the previous time.

Don't forget that you are sending these data from the server to the client if you are using View Data; this means that there must be a proper map (one whose name ends in "-CS") for that. If you write the data to a text file and view that on UNIX with a text viewer (such as pg, more, cat) do the char...

Does the target end of your design look like this? -----> Transformer -----> ODBC | Output |Rejects | V SequentialFile In the ODBC stage set rows/transaction to 1 and parameter array size to 1. Create new columns on the rejects output to capture SQLSTATE, DBMSCODE and LASTERR link variables from the...

The operating system prescribes ONE WRITER ONLY for a sequential file. Therefore: 1. Yes, you will have a file locking scenario. 2. No, using Append mode will not help. Use temporary files, cat them to the main file at job end - that is, in an after-job subroutine - (it does not matter if this locks...

FUNCTION WaitForFile(RegExp, TimeOut) * RegExp is a regular expression to be matched by command * TimeOut is number of seconds to wait before abandoning wait Equate CheckInterval To 2 ; * seconds to sleep between tests Equate LF To Char(10) Equate COMMA To "," Start = Time...

WaitForFile activity does not support wildcards. It is easy enough to create a routine that can do so, and invoke it through a Routine activity.

Yes. Several stage types, Join among them, are documented as requiring that their inputs be sorted.

How was the Data Set created? Does the job that reads from it use the same configuration file as the one that created it?

Explore the DateFromDaysSince() function.

Use Pivot stage.

The best partitioning for lookup is identical partitioning to the stream input.

Because you haven't changed anything! BigInt is uint64. The function requires uint32 as its argument.

More simply: cd to the project directory before invoking uvsh/dssh.

What is the Lookup Failed rule in your Lookup stage? How large is the reference data set?

ALL the commands need to be in upper case, including UNLOCK.
The UNLOCK verb must be in the VOC file where you are attempting to execute it.