DSXchange

Copy stage makes zero or more copies of its input. You may drop or rename columns, but not change the data in any other way.

Modify stage is a very fast stage for performing certain simple, single-argument functions on data. Vincent has posted a blog on how to become a Modify stage Zen master.

It may be that not every capability of Oracle 10.2.0.2.0 is supported by the stage types that ship with DataStage 7.5.1. Note, too, that stage types and routines are independently versioned.

Upgrade to 5.2 first, then from there to 7.5.2. I do not think upgrading from 4.5 directly to 7.5.2 is supported. Involve your support provider to get advice directly from IBM.

The job sequence needs to run daily. If it's Monday (Iconv(Date(),"DWA") = "Monday") it runs the weekly job. If it's the 6th (@DAY = 6) it runs the monthly job. You can add additional activities to retrieve the database value, of course.

You can use the Data Set Management tool under the Tools menu.

getEnv() gets environment variables' values, not job parameter values.

Investigate the programming chapters in the manuals for information on how to use DataStage API functions to get information out of DataStage.

What values are coming out of the CDC stage? How are you asking the Transformer stage to generate the "S"?

Create a source-to-target mapping document. For every column in each target file create a specification about how its value is to be obtained. You can use a table in a spreadsheet or a word processing document, or FastTrack if you have that.

The rest (the ETL design) will follow with great ease.

Although it's not strong encryption (at least in versions earlier than 8.0) the algorithm is unpublished. Putting it slightly more strongly, the algorithm is "unpublished proprietary information and intellectual property of International Business Machines Corporation" and your licensing agreement ex...

Take a training class - you get hands-on experience in a non-threatening environment where errors are OK, indeed encouraged (since you learn more if you make mistakes). DSXchange is not intended as a substitute either for training or for support; though there will be some training materials offered ...

Please be more precise about weekly and monthly. Is this on a specific day (e.g. weekday for weekly, month date for monthly)? Do you want to run something every day that determines whether the job runs or not?

For less than 30c per day you can have premium membership and access to all the benefits thereof, including being able to read the entire posts of the five premium posters. Premium membership is one of the ways that DSXchange funds the hosting and bandwidth charges incurred by the site; in short, o...

Data are not stored in the ORDER BY order in the database table, nor are they stored in that order in the hashed file, and for exactly the same reason. You can not control the order of storage in a hashed file; you must use either a sequential file or a B-tree structure to preserve order (there are ...

Should be OK, provided you have four columns marked as Key with which the parameter markers can be substituted (the fourth "key" may need to be a copy of the third).

Take the 7.5 class. There are a whole heap of stages that you need in 7.5 that simply do not exist in 8.0 (because of the closer interaction with DataStage), and there is as yet no certification for version 8.0. IBM has a QualityStage 7.5 class (DX731AU) scheduled in Canberra 03-07 December - contac...