DSXchange

Welcome aboard.

Try enclosing the column name in double quotes. (You may require user-defined SQL for this.)

You must have in place the same configuration file that was used when the File Set (or Data Set) was created, or at the very least one that is compatible and contains all of the nodes mentioned in the control file.

It's a separate Specification containing the single word NOWARN

There are various ways to mount a shared Windows drive onto a UNIX system, among them Samba. An Internet search will be your friend here.

How about YOU start the discussion by revealing what you've discovered to be useful? There are doubtless myriad approaches to achieving what you seek to do, but the one that is best will depend on many factors about which you have not provided any information, such as the environment, whether files ...

USS is included in DataStage (a) because a couple of very important customers wanted the capability and (b) to yield a couple of certification exam questions that none but the most esoterically prepared candidate can answer correctly.

This also happened when i was the only one running jobs and no one else. You need to monitor your operating system to determine which are the "resource hogs". Parallel jobs have some reporting options that will help, such as being able to report the process ID of each player process and t...

There's a rule of thumb that suggests a maximum of four hashed file lookups per Transformer stage. Such a job can usually benefit from inter-process row buffering. I'm not aware of any "best practices" relating to Link Collector stage apart from don't use it if you don't need to. For examp...

Yes. They are "before/after subroutines" in the routine type field - no differentiation for "stage" or "job".

OK, then your server is simply overloaded. It's a supply versus demand situation. Some, including some at IBM, are coming to realize that having a tiny development server and a huge production server just doesn't "cut it" any more - you also need substantial grunt in the development server...

There are very simple rules that tell what Auto delivers. Link Type Partitioning --------- ------------ Sequential - Parallel Round Robin Parallel - Parallel Same Reference input to Lookup Entire Link to DB2 stage DB2

In version 8 there are two metadata repositories; the common repository (usually known as XMETA) and a local repository in each project. The common repository is open; that is, you can use an appropriate tool (for example DB2 Control Center if your XMETA database is DB2) to view the definitions for ...

With Lookup File Set on the reference input or sparse lookup specified, the Key column is pre-defined. This is why the Lookup stage will not permit you to change the definition of they key. It wants a column with the same name and data type. You can use an upstream Modify or maybe even Copy stage to...

It should be enough just to mount the PXEngine directory on the remote machines (and setting certain environment variables such as APT_ORCHHOME and PXHOME on those machines).

If you need urgent help sign up with your support provider for premium service and learn just how much "urgent" costs. DSXchange is an all-volunteer site, whose members post as and when they can. Specifically, we do not "do" urgent and, indeed, react negatively when such demands...