DSXchange

Welcome aboard! :D I prefer to use job sequences in this context. One of the first things I do with a new project is to create a "template" job sequence (unfortunately one can not create a Template from a Job Sequence) containing all the standard parameters for the project. By using "Save As" I clon...

Not more than four, and that may be reduced by whatever else is happening in the job, particularly between the link partitioner and link collector stages.

Having OVER.30 larger than DATA.30 is not a problem unless it is approaching 2GB in size. OVER.30 stores overflow from group buffers, which may indicate a tuning issue. OVER.30 also stores records that are larger than the LARGE.RECORD value (default 80% of your group size). So it may mean that you a...

I think this is the post to which you were referring.

If you don't mind BASIC expressions, there's always

At a quick glance this is something where the Aggregator stage might be the one you need. Read the help or manual for Aggregator stage and see whether you agree.

This isn't really a job for QualityStage; it's probably better done with a DataStage server job. Read the file using a Sequential File stage. In a Transformer use an output constraint expression to test the string against its converted value. string = Oconv(string, "MCT") If this t...

Don't even think of doing it that way! Use Designer. Don't open the job; merely select it from the Repository, right mouse click, and choose Delete from the menu. DataStage will look after everything it needs to on the server. Your list was hugely incomplete. If you have done this and there are orph...

These warnings are simply to alert you to the fact that arguments are passed by reference so that, if you change any of them, the change will propagate back to the caller. You will notice that, following these warnings, the message "compiled with no errors" appears. That's the one that's important. ...

Sounds like some kind of corruption in the DS_STAGETYPES table in the repository. Have you tried re-indexing the repository? You may need to re-install the Pivot stage (from the CD) using the DataStage Package Installer.

No, what you need to do is to pass the "1" unchanged by DataStage, and use user-defined SQL in the stage that connects to the table. In the user-defined SQL specify LIKE rather than "=", and use an appropriate wildcard character (usually %).

Reset the job in Director.

Look for a message in the log called "from previous run...". What does this tell you?

Are there any "?" characters in "the whole record" in the logged message? These are used to indicate which characters can not be mapped.

Ascential would counsel you to purchase licences for 12 CPUs.

Concatenating NULL to any string returns NULL. Change CoStr so as never to return NULL, and your concatenations will probably start working as required. And you don't need parentheses. When you said "Transform" did you mean "Transform" or "transform function" (which is a Routine)? In an expression i...

You may also need to be granted write permission to cronjobs and atjobs directory, or be made a member of the group that has write permission.