DSXchange

That's tricky because sequence jobs changed a lot between those two versions. You could try exporting an empty 7.1 job and a full 7.5 job into text export files and then copy and paste stages from the full job to the empty job.

You are spot on, the XML Input and XML Output stages sit in the "Real Time" folder for a reason, they are better at handling small volumes. Good suggestion on the XSLT translator, I will have to check it out.

I never said this, in fact I was never here, but I would avoid the Windows version until it is more mature. Right now the Unix platform has gone through versions 6.x and several 7.x releases, not to mention many Orchestrate versions, while the Windows platform has had just one release and will have ...

Column Generator will definitely be better then a Transformer unless you are using that Transformer for a range of other tasks (such as constraints and derivations) and it is more convenient to leave it in. The stage is not that complicated to use. Better yet if your lookup source is a database put ...

DS USS is fairly new and not many people on this forum will have used it. It is more of a USS question rather then a DataStage question. What is the connectivity between the USS environment and the hosting mainframe? Have a look at the IBM web site: m Applications can work with data in both UNIX hie...

Sparse lookups behave quite differently and can be trickier to setup. In your lookup stage you will notice you no longer need to drag the primary key fields onto the lookup key fields, there is no linking displayed, with a sparse lookup the linking is done automatically. It links (where clause joins...

I uploaded to Devnet a DB2 Remote Configuration Guide I got from Ascential support, it is a draft document and is not on the install CD. It describes how to setup remote DB2 connections for parallel jobs and is also useful for people trying to setup local DB2 connections. Get it from devnet or ring ...

Have a look in the QualityStage server log file. It should have entries for failed connection requests. You can also increase the debug messaging on the QualityStage stage. I usually make the debug setting a job parameter so you can increase the debug level at run time. If you get the server name an...

I would just ignore the warning and handle it is the message handler. Much easier then trying to split and merge the record down two paths. These warnings happen even if there is no defaulting going on. For example if you drop deletes you still get these warnings, even though the rows with defaultin...

Can the complex flat file stage be used for output? I thought it was just an input stage. The equivelent output stage would be a fixed width file. One thing about the complex flat file stage is that it flattens data on input, it can only really handle one record type at a time, therefore writing out...

As is always the case with transformers the right mouse click menu is your friend. Have a look at the function list, I think the environment function sits under the Utility functions (don't have DataStage on this PC). I never use it, it's dodgy programming, similar to global parameters in Visual Bas...

I've seen this before, the surrogate key generator is an extremely superstitious stage, in Australia it will also skip 87. But seriously, have a look at your job monitoring, with a right mouse click show instances, observe that one partition processed 5 rows the other two processed just 4 rows. This...

Do you have a job that is trying to insert and update to the same table at the same time via seperate stages? Do you have a job using the Load - Import feature? I have found it extremely easy to lock a DB2 table, easier then any other RDBMS I have used, we often get tables locked up via read only qu...

Whenever I get a lookup returning multiple rows I pre-process it into a unique set of rows in a lookup file such as a hash file or parallel dataset. That way you deliberately make a choice as to which duplicate to put into the lookup instead of taking a hit and miss decision within a lookup stage. T...

This is a common problem for people trying to run an evaluation version on a PC or laptop not connected to a network. You can try the following: - Run System Information from your Windows - Accessories - System Tools menu to find the exact name of your machine in the "System Name" field. Use this as...