DSXchange

Neither of those affected any of my Information Server installations. Even one in Tokyo (which has alternate servers in Switzerland and Australia) was able to keep going, even with some staff relocating to other cities farther west in Japan and working remotely. And no doomsaying will affect my beli...

Does only having IIS Admin role but with other non-IIS duties count? That is, functioning as IIS Admin (which is not a full time task) and having no other IIS activities to perform?

A range lookup would probably work, with the upper end of the range being some absurdly large value.

Avoid timeout errors by controlling the number (actually the workload) of jobs that can be running simultanously, having heed of other workload on the machine. Avoid locking errors by good design. I agree network down or database down look hard but they're easily handled before a job starts (a small...

DSXchange Learning Center has a video on exactly this topic. (Though it does not cover parallel routines.)

Beware that deleting a pathed dynamic hashed file is trickier than Craig would have it seem. You need to delete the DATA.30, OVER.30 and .Type30 files as well as file file dictionary. If you have created indexes you need to delete them too. And the hashed file must not be in use, so that the T30FILE...

You have a 9-digit zip in the failed case, so you should have a value in the Zip4_CASS field.

Please confirm whether you are using WebSphere Transformation Extender or DataStage and, in either case, the exact version number.

Check your OpenLink driver documentation. There may be a limit on the number of simultaneous connections, or there may be an expired license on the driver (the latter fixed by sending OpenLink more money).

Looks like you're trying to use an OpenLink driver, which does not work with the driver manager for DataDirect drivers shipped with DataStage. Can you use one of the shipped drivers?

Concatenation in Transformer stage.

Column Export stage.

From memory the Programmer's Guide shows mapping between C-style and SQL-style data types. In general they're pretty obvious, though the latter form a subset of the former.

You can achieve any implicit conversion with any stage type that supports input and output links.

Note, however, that Numeric(14,0) does not implicitly convert to int32. Either use int64 on the output or Numeric (9,0) on the input.

You have to install the correct C++ compiler before you install Information Server.

Prevention is better than cure. Design your set of jobs so that it does not violate referential integrity.