DSXchange

Is the file system on which your project directory occurs full?

Review the Transforms MONTH.LAST and QUARTER.TAG - you will be well on your way. (You don't need a loop.)

Open Administrator, project properties, Schedule tab, and determine whether a different user ID is used for scheduled jobs.

This "feature" occurs only on Windows platforms.

Someone at your site has been playing around with "UniVerse" things and without knowledge of what they're doing. The SHM.TO.LOAD file exists if an Administrator has identified BASIC routines that are to be pre-loaded into shared memory so that the one copy of object code can be used by all process, ...

The technique to establish the (so far) maximum value of a stage variable is to replace its value only if the incoming value is larger. For example derive svMyValue as If InLink.MyCol > svMyValue Then InLink.MyCol Else svMyValue Based on that value you can then make the decision whether or not to in...

In a parallel job?!!

Do you mean IMPORT the table definition? There is no capacity in DataStage Manager to export table definitions, other than as DataStage export files (DSX or XML format). Search (Google?) for S1000 as an SQLState value, and search your Paradox driver information as to the meaning of error code -5015....

You have not made the environment variable $STATUS_TGT a job parameter in the current job (the one that's generating the error).

DataStage just ticked over 20,000 registrations, to huge fanfare.

Woo hoo.

However not all ten digit numbers can be represented as Integer. The largest four-byte integer in a twos-complement machine (just take that as given) is 2147483647.

...but only if it fails on the "existence/non-existence of the row" criterion.

OK here's the deal.

A hashed file (note: it's not a "hash" file) is a "UniVerse" database table.

So, you tell me how to read, say, an Oracle table from UNIX and I'll respond with how to read a UniVerse table from UNIX.

StartLoop does not have to be the first activity in a job sequence - there could be any kind of upstream activity (User Variables, Routine, Execute Command) for fetching this value before the loop gets under way.

Before/after subroutines do not show up in the list of functions callable from the Routine activity, because they are not functions. You need to create an interlude function if you want to call a before/after subroutine from a Routine activity.