DSXchange

When an expression is red, right click on it and ask DataStage to validate the expression. It will indicate the syntax error for you.

Is there a string_from_raw() function for the Modify stage in version 7? (I don't have version 7 documentation with me at the moment.)

Some stages require sorted input because of the way they operate. This is unrelated to the partitioning algorithm used. If you do not achieve key adjacency using a key-based partitioning algorithm your results can be simply wrong; for example on four nodes summarising by US state, you can end up wit...

Welcome aboard. These tables in the scratch disk *should* be cleaned up automatically, as you surmise. That they aren't is something you should raise with your official support provider. In the meantime your cleanup script serves as a workaround.

Not all optimizations turn out to be optimal. The same is especially true of operator combination, which is way too aggressively done for my liking.

Version 8 is radically different architecturally from version 7. For a start there are two repositories, and one of them in not your DataStage project.

It is no longer possible to do what you are attempting. Learn the right ways.

shripal86 wrote:I need to migrate datastage jobs from Server7x to Parallel8x edition.

Why not just keep the server jobs?

I have only had success with the encrypted password on the dsjob command line. Are you fully up to date with your fix packs?

Welcome aboard. The optimized job score will remove a Copy stage that does a simple transfer, so the two jobs will have identical performance. You can prevent this removal via the Force option in the Copy stage itself, but it's a pretty efficient operator and you may still not see any performance di...

You can, but there's no simple COUNT when calculating. You can count missing values, you can count non-missing values, but there's no actual count. If you know there are no missing values then a count of non-missing values would probably suffice.

Welcome aboard.

For starters, version 7.x is a purely 32-bit application - you need to be aware of that. They are also of an age that their installation is not supported on Windows 7 (which did not exist at the time).

I have used that syntax only successfully. Is your password actually correct? Has it expired?

There is no limit. Do whatever is best for your purposes, not neglecting ease of maintenance.

You always get that message when the job aborts. Look for earlier errors in the job log.

Indeed, as a general practice, always try to resolve the first error first.