DSXchange

I think we're seeing wraparound here Craig. Apart from the first record they do appear to be the same size allowing for the wraparound. However, that said, for fixed-width to work, then EVERY line must have the same size and structure. Your alternative is to read the file as a single VarChar, and pa...

What do you mean by OK? If you mean "will the jobs still work" then the answer is "yes". If you mean "can I do accurate Usage Analysis in the new environment" then the answer is "probably not" but you can effect the Usage Analysis in the original environment.

Metadata mismatch occurs once and is not fatal (unless you get more that 50 of them). What other warnings are appearing?

The absence of this combination on the IBM website tells you that, even if you can get it installed, you're on your own as far as support is concerned.

So how do i start to write the routine? You would start by designing it. What do you want it to do? Create a precise specification, including connecting to and disconnecting from database, creating and dropping cursor, binding variables, and all the other things you need to do with your particular ...

PhilHibbs wrote:is it feasible for a Before Job routine to deliberately abort the job?

That's precisely what the ErrorCode argument is for.

Why not Aggregator? For an ungrouped count there are no memory issues.

To get a count in a stage variable initialize it to zero and add 1 for each row processed. This number is also available through system variables such as @OUTROWNUM.

Have you searched DSXchange, read the manuals or taken the IBM class, or do you just want it all handed to you on a silver platter?

Quite easily. There are several strategies, usually involving "always running" jobs exposed as web services or listeners. But your question is far too vague to give a more specific answer than that.

When's the interview?

Presumably you mean Microsoft Excel - why not say so?

You need an ODBC driver for Microsoft Excel. None is supplied with DataStage, therefore you will need to source this yourself.

Otherwise contemplate working with CSV files.

On which operating systems we can able to install datastage server?(list of os to installl datastage server) All of the ones mentioned on the IBM web site - it's a movable feast so not possible to answer unless qualified by "as at this date" - but it's always there on the IBM web site. Does it requ...

You're right - it's not related to DataStage. DataStage uses SMTP to send a message to an address. If the mail server has been configured to treat that address as a list address, then that's what will happen. Any problem with that will need to be resolved in configuration of the mail server. If Data...

This is a ridiculous requirement. You are grouping data (in the Aggregator) so the rows can only come out of that group by group.

A Funnel stage with only one input is a waste of space.

You're going to have to involve your official support provider here. I suspect - but can't get close enough to the design to be sure - that the "index" here is a reference to a slot in the internal table where the dimension data are stored, and that it's gotten to be larger than the structure (that ...