DSXchange

There is no such thing as a Lookup stage in server jobs. You may have seen references to a Lookup stage on this Forum, but the stage type exists only for parallel and mainframe jobs (and isn't the same in them). In server jobs you perform lookups using a Transformer stage. The first input link drawn...

You are fortunate that you live in a part of the world where the change to and from daylight saving time is on dates specified in legislation and, therefore, "locked in". You can build this knowledge into your routine. For example "the first Sunday in April" or "the last Sunday in April" can be easi...

The simplest thing is to let DataStage generate the SQL for you; depending on the stage type you are using there are between six and ten "update rules", such as "insert new rows only", "update existing rows", and so on. Feed the rows to be updated through a stage with "update existing rows" as the u...

DataStage server jobs do not generate COBOL. In a server job, I would assume that you're processing a text file produced by a COBOL program, in which case the "date" field is simply text, and you can process it as you will. Read the documentation accompanying the TAG.TO.DATE and DATE.TAG transforms ...

An "active stage finishing" event in the log file shows the number of rows processed along each of its links. You could obtain the number of rows sent to your database from this event in the job log. Alternately you could add some code in an after-job or after-stage routine, or in job control code, ...

Sometimes, but not always, dependencies can be determined from the DS_TEMPnn files (tables). Once the sequencer has been compiled, you may get more from RT_CONFIGnn, though I note you've already abandoned this as a source.

Why are you being so quick to blame the length of the WHERE clause? Just because that was the fix in one job doesn't mean that it's going to be be the fix in all jobs! You need to determine what the cause of the abnormal stage termination was. There may be information in the job log after you reset ...

Since you have NLS (national language support) enabled, it may also be the case that whatever characters are in the first message (or is it only the MsgId?) cannot successfully be mapped. Appearance of the "?" character usually indicates a character mapping problem. You could try setting the map dif...

This error code can be caused by the RPC service not running. Depending on the exact value of x in 5.x (your DataStage version) you are looking for a process running unirpcd or uvrpcd. You can also look for the UniRPC (or UniVerse RPC) services in the Services applet of the Windows Control Panel, or...

That's going to depend on a number of factors, none of which you bothered to tell us about. Let's call TableA the table that has to be updated, and TableB the table that contains the updates. Does TableB contain only records to cause updates to TableA, or does TableB contain these and other records ...

5.x is definitely not supported (officially) on any version of Windows XP, not least because 5.x pre-dates the release of Windows XP.

An I-descriptor is an entry in a UniData (or UniVerse) file dictionary that describes a virtual column - that is, a column that does not have an actual existence but the value in which is generated when the column name is referred to in a query. Needless to add, virtual columns (also known as I-type...

Just to be totally clear, you omitted the "=" character after each of the /H, /U and /P switches.

it is magically transmogrified into multiple lines based on these characters! And it's FAST. I'm not sure doing it this way is either bizarre or fantastic, but is pretty cool Regards, I originally learned this technique from Jim Tsimis, to whom credit must go for inventing the technique, in the day...

The Pivot stage can handle a variable N, but you must provide definitions for the maximum possible N. Any not represented will be either NULL or not assigned (can't recall which), which you can test for using IsNull() or Unassigned() functions. Search the forum for a technique that involves a design...