DSXchange

You can search for DataStage 8 on this forum for some good threads, you can read my blog entry What is new for DataStage 8 on the Information Server and visit the Moving to DataStage 8 on Squidoo page that has some links to IBM, blogs and this forum.

You should find an upgrade to 7.5.1 to be quite easy and beneficial - getting you some performance improvements and new features. You will need to regression test your jobs as there may be minor changes between the versions to the way data is handled. I wouldn't move to version 8.0.1 just yet as it ...

Sheesh was I wrong. Of course you wouldn't derive an output row until you had worked out what output links that row is on. Thanks Craig.

Stage variables first followed by derivations followed by constraints.

For some actions the Teradata Enterprise stage lets you put in a Before-SQL and an After-SQL statement that runs at the start of end of the DataStage job (not for every row). You might be able to use the After-SQL tab to update stats.

The Designer help files are the first place I go to find information on properties in the stages. If you go to a property window and press F1 it brings up a help page with a bitmap of the property window, if you click on the tab in the bitmap it jumps to the help for that tab. You usually get a help...

The 7.5.2X install was tested and certified for Windows 2003 so the compile options are for that version. You could try switching to the 2005 C++ compile options that get set by the DataStage 8 install and let us know if this works on DataStage 7 installs: APT_COMPILEOPT: -W/TP -W/EHa -DAPT_USE_ANSI...

There are very few administrative tasks to perform in the console. The first is to make sure the DataStage credentials are set, the second is to make sure you have user logins with the rights to the DataStage applications. All other admin tasks can then be performed in the normal DataStage Administr...

It's covered in the DataStage Developers Guide: Defining record ID constraints If you are using the CFF stage to read data from a file that contains multiple record types, you must specify a record ID constraint to identify the format of each record. Columns that are identified in the record ID clau...

I've tried the custom install instead of the basic install and on some products it gives you the option to remove a particular component but on most there are no options. For example with DataStage Client I was able to remove the multi client manager but that was the only optional component. For the...

You can get some basic materials - DataStage comes with a tutorial and if you can find more simple tutorials online, but the real value from a training course is watching a DataStage expert use the product.

You should first make sure it is a compiler compatibility error and not an error specific to that transformer in that job. Create a simple job with a row generator, transformer and copy stage with one column and try compiling it.

A faster way is to highlight the stage and turn it into a shared container (Edit Menu - Construct Container - Shared Container) then delete the shared container stage from your job. The stage and stage links remain in the shared container folder but don't clutter up your job folder. If you need to p...

I'm also using Visual Studio 5 Express (as recommended in the install materials) and didn't have to alter any of the compile options.

I think you are better off exporting all your DataStage components, uninstalling version 7 and performing an 8.0.1 install and importing. This will be easier to rollback and restart if the install fails. You can put your Metadata Server (domain layer and repository) on a separate machine to your Dat...