DSXchange

See how you go with the ten question trial exam (on the IBM website).

Initialize a stage variable - let's call it svSeqNo - to the partition number (system variable @PARTITIONNUM). Derive it with an expression that increments it by the number of partitions (system variable @NUMPARTITIONS), for example

i am waiting for responce :( There is nothing to compel anyone on DSXchange to respond to any post - it is an all-volunteer site and members post when and if they can. If they don't it may be that they don't have anything to add or, (quite unlikely) that they feel offended by something. If you're i...

I assume you mean here "replacing the default value of a parameter that is a member of a parameter set when the job run request is made".

In that case, yes, what you propose is feasible and viable. Beware that you may need to strip the newline from the end of the retrieved command output.

Welcome aboard.

Ask you network administrator about the port number (typically 50000 for DB2) - is it, for example, blocked by a firewall?

Speed - as in elapsed time? Well, all else being equal, more partitions (up to a sane amount) should finish faster than fewer. Or you may prefer fewer partitions but more than one job simultaneously. Or you may prefer to schedule jobs when not much else is happening on the machine. Or...

While it is possible to create SQL statements in Transformer stage it is not possible to execute them there or anywhere else in the same job. My preferred approach would be to create the SQL statement in one job (or routine) controlled from a sequence, then to pass the SQL statement as a parameter i...

Not for me.

Define "performance" in an ETL context.

What's more important - speed or correct results?

Force the Transformer stage to execute in Sequential mode.

Moderator: please move to Server forum

Once there an answer suitable for server jobs will be provided.

Vectors are not the same as subrecords. To decompose a subrecord you need to use either Split Subrecord or Promote Subrecord stage.

The important thing is that now the error is from the SCD stage, not from APT_CombinedOperatorController. So we've narrowed things down somewhat. Now show us how you've configured the SCD stage - in particular what's connected to it. If you have an initially empty dimension table then this alert mes...

A Transformer stage can not access a data source.

Does invocation from the sequence disable use of the job monitor or disable collection of operational metadata?

Craig would not know what solutions U does or doesn't have.

The second person personal pronoun in English is spelled "you", not "u".

How are you using a SELECT statement in a Transformer stage? The Transformer stage does not connect to external data sources.