DSXchange

This is a DB2 error. Try to learn what error code 7 means in this context by consulting the DB2 error codes manual.

In UNIX (for example using ExecSH or ExecSHSilent as your after-job subroutine) you can capture the output of the date command with an appropriate date picture. mv DaySales.xml DaySales_`date "+%mm%yyyy"`.xml Or you can write your own after-job subroutine and use DataStage BASIC functions ...

(a) WebSphere Application Server is the mechanism via which the Information Server services (e.g. login/security service, metadata delivery and analysis services, reporting service) are deployed. (b) Think in database terms. The server is the server, the repository is the database itself. (c) Inform...

kandyshandy wrote:this is not readily available with datastage (until current version)

More information please? It's not mentioned in any of the "what's new in 8.1" material from the Information on Demand 2008 conference.

There's no such thing as a version controller. You simply leave components in place and they will be upgraded in place. If you want to move from one to the other, the usual export and import is the correct way.

Huge number of ANYTHING = performance issue.

It's supply and demand again.

Do you really need all those columns?

Have you investigated IBM's CDC for Oracle?

The usual way is to write to DaySales.xml then rename it in an after-job subroutine.

Yes, but you're biased!

Welcome aboard.

The answer is yes. You need client software for Teradata and an ODBC driver for MySQL, both installed on the same machine as your DataStage server.

Gee, and I didn't even get to do my "what's changed?" schtick.

Meanwhile you might also investigate why there's no data to read.

<Cff_Read_DA,0> Import complete; 0 records imported successfully, 0 rejected.

Ask Tom is an excellent resource for Oracle questions.

But we dont have DB2 native stage to use. Very doubtful. All stage types are supplied with DataStage. Did "someone" elect not to install them all? Why not use DB2 Enterprise stage? It can automatically pick up the table's partitioning information and effect parallel SELECT on that basis. ...

Parallel Job Advanced Developer's Guide

This is part of the standard manual set. From memory there's a long chapter describing the available classes in alphabetical order.

Did you refresh the Director's view after clearing the status file?