DSXchange

See response in correct forum. Posting the same question in multiple fora is counter-productive.

Can you create a new project from the project drop-down in the pillar menu or from the projects grid on the Home workspace?

Do you have Information Analyzer Project Administrator role assigned to your user ID?

You've changed the meaning of your data.

A "." at the end means a decimal data type with 0 decimal places.
A "-" at the end means an integer with a value less than zero.

Not easy. You could try a sparse lookup with custom SQL using LIKE operator.

Detecting changes is a very common requirement, particularly when handling slowly changing dimensions.

The ability to re-build a data set from a before-image and captured change data is important in recovery situations.

Remember to click Save or OK button.

datastagenewbie wrote:Can jobs be restored from osh scripts?

No, other than manually.

To answer your other question, a Windows backup can restore an entire DataStage project, and that should work provided that none of the system entries that refer to it (for example UV_SCHEMA, UV.ACCOUNT) have been damaged.

Not really. I come from a UniVerse background, so that helps. I worked for the vendor who created DataStage, which helped a lot. It has always been the vendors' decision not to publish details of the underlying engine databases.

The parallel Sequential File stage is notoriously bad at handling quotes.

Consider using a server Sequential File stage, either in a server job or in a server Shared Container in your parallel job.

No, I think keeping the canvases different for the different engines is appropriate.

Have you defined " " as the field delimiter on the Format properties of the sequential file stage?

Actually, APT_STRING_PADCHAR does not apply to server jobs. This forum is for server jobs.

My bad - I was thinking about the Filter stage.

Here's a rule of thumb: Filter stage filters using expression, Switch stage filters using value. Value does not permit the use of wildcard or, indeed, any comparison other than "equals".

vmcburney wrote:Still no Server Job to Parallel Job migration tool available even though it would be a good idea for IBM to build one.

Only if it's optional.

Sequential ---> ANY Parallel (except as noted - ref input to Lookup, input to DB2)

More information in the Advanced DataStage class from IBM. Not sure where it exists in the documenatation suite, but it has to be in there somewhere. Have you looked in the Information Center?