DSXchange

Usually Registry is on the C: drive, so backing that up does back up the Registry. Of course you can back up the Registry separately if you wish. Periodically cleaning and defragmenting the Registry is also good practice.

"Blocking" stages, such as Sort and Aggregator, keep consuming rows but don't produce any rows until they can.

You can improve the "one row at a time" scenario by using inter-process row buffering.

DataStage (prior to version 9.1) has no inherent capability to do what you are seeking to do. If you can find a Java class that can write binary Excel files, then you might be able to use that, possibly invoking it from DataStage. If you can find a third party ODBC driver for Excel you could also us...

How about revealing:

• the stage variable initialization expression
  
  the stage variable derivation expression
  
  the actual error?

In shell scripts you can test the exit status of any command via the $? shell variable, or you could pipeline them together using && connectors. Rather than kill sessions, train your users to be clear of their sessions when scheduled outages occur, and do the right thing by giving plenty of ...

Assuming that the value always represents a figure with four decimal places, Craig's solution is apposite for you.

One way to code this would be:

You are "adding spaces". Each of those spaces takes up, well, space.

Note that you need a space (or a "T" perhaps) between the date and time components. The second operand to the concatenate operator should therefore be " 06:00:00" (with leading space character). I prefer not to use BETWEEN, but rather > and <= operators, so that I can run and run...

Shutdown # Engine DSHOME=`cat /.dshome` export DSHOME cd $DSHOME . $DSHOME/dsenv $DSHOME/bin/uv -admin -stop # Agents $DSHOME/../../../ASBNode/bin/NodeAgents.sh stop # Services tier /opt/IBM/WebSphere/AppServer/bin/MetadataServer.sh stop Startup is similar, except that you use appropriate start opti...

There isn't one in version 7.x.

What is the data type of your source and target columns?

The example is NOT a group under any combination of columns.

Another crossover is InfoSphere Information Services Director, which allows you to publish services (for example DataStage/QualityStage jobs) that are exposed through WebSphere Application Server.

Is there one figure per month per row, or many rows per month, or some other format? Basically, I'd be looking at a solution for muliple rows per month, which I'd aggregate grouped by month. I'd also calculate the most recent year and month in the data and, from that, determine the month and year of...