DSXchange

Integer to string is an implicit conversion - specify (a large enough) string on the output link and integer on the input link and use a KEEP specification or a direct map specification.

What operating system (including "bittage") is your "local machine"?

Why are you asking me? John McKeever suggested it, and explained correctly how to use it.

Third level = third grouping key (imagine you're doing it with an SQL query).

DSD_BP.O/% is not a valid pathname, yet this is where the failure is occurring - DataStage is presumably trying to load one of the routines in the DSD_BP.O directory, but somehow has identified a catalog name of "%".

I think this one needs to go to your official support provider.

Methinks someone has corrputed DS_JOBS and somehow "converted" it into a Type 1 file. Can you please look into the DS_JOBS directory in this project and report what's there, including hidden files?

Not possible. IA has no services of its own.

Moderator: please move to QualityStage forum

Sgiri1, please disable operator combination, even if only temporarily, so that you can be confident about which stage is actually throwing the error.

rafidwh wrote:Is there a way to check without using a trnasformer stage.

Probably. But why?

Depends. The Surrogate Key Generator can, itself, be set up to use a database sequence, and retrieve huge blocks of keys (and why not?). If you're processing 1000000 records, and request blocks of, say, 250000 keys at a time, performance will be amazingly quick. Of course, the same is true if the bl...

What precisely do you mean by a "datastage serial key"? DataStage itself does not have, or need, serial keys except in one case, the unique user number allocated to logins. Actually there are a couple of other internal ones, such as the slot number in the T30FILE table, but I doubt that's ...

For a finite domain use a Transformer, Switch or Filter stage to effect the split.

Does the /SAVE_AS_BITMAP option work for you?

The MSOLEDB stage works fine also, provided that you have specified a valid connection string.

If you want ASAP sign up with your support provider for priority service. DSXchange does not exist to provide urgent support. It is an all-volunteer site whose members post as and when they can (and if they can). I personally will not try to diagnose any error thrown by APT_CombinedOperatorControll...

The report and bitmap options do not cause the Designer to open.

Learn patience. You post during my sleep hours and expect me to reply? Dream on.