DSXchange

The second person personal pronoun in English is spelled "you" - not "u". U is the name of one of our posters. Please strive for a professional standard of written English on DSXchange - it makes life easier for those whose first language is not English (like U, for example, who...

Moderator: please move to Enterprise Edition (parallel) forum

The forum in which you are presently reading is dedicated to testimonials about the DSXchange websites.

I can't see any property in the stage that allows this. However, if non-numeric data types are quoted in the data file, the fact that you have delimiter characters in the data should not matter. Are you using IQ Write or ASE Write? If you use the Sybase IQ Load stage you have full control over the l...

No. For version 8.anything, one engine tier per machine. It can share that machine with a version 7 server, but not with another version 8 server.

What you seek to do is not possible as far as I am aware. Of course, it can be accomplished from the Designer client.

But you can remove the executable (DSJOBBINARY) from the export file subsequently.

Very interesting... I can't find one either. Did you install the DB2 Connector from a fix pack, or was it part of a regular installation?

As I read the question, your outer loop processes a date, and the inner loop uses the outer loop's date as the previous date. Is this a correct reading? Otherwise it's a single loop with multiple loop index variables which you could combine (as a delimited string) into a single loop index variable a...

Is this a server job (as posted) or a parallel job (as marked)?

QualityStage would do that parsing for you.

If you choose not to use QualityStage (maybe because you don't have it) then the parsing operation is something you have to do. I would recommend Field() functions into stage variables.

What exact version of DataStage?

A simple remedy for your dilemma exists here.

I posted a full answer.

You might investigate the Trans() function for your lookups against a hashed file. This allows you to specify fourth argument of "C" that returns the original code if the reference value is not found. It will save you coding a number of If..Then..Else constructs. You will also, of course, ...

Get in touch with IBM to learn about their eLearning and remote delivery options.

Noting that you may need to modify the expression because of the space following the "-" character one solution is If Index(InLink.TheString, "-", 1) > 0 Then Field(InLink.TheString, "-", 1, 1) : "-" : UpCase(Left(Field(InLink.TheString, "-", 2, 1)))...

There is a single stream of data here. Of course partitioning it will screw things up!