DSXchange

If you can attend the IOD EMEA 2010 conference next week I am giving a presentation on rule sets on Friday morning.

This is based on material on rule sets available from DSXchange Learning Center on DVD.

This should only appear on your own posts. It IS there on mine. You have two choices: Edit/delete this post and Delete this post.

Now read Ernie's post again.

You must break this task down into smaller chunks.

You can use DSJ.ME directly in the routine, but you have to tell the routine what DSJ.ME means. There is a header file that you need to include in your code ahead of any executable statement.

Welcome aboard.

In one stage (at least) in your job design you have a dfloat column on an input link mapped to an sfloat column on an output link.

The full error message may name the stage. But you didn't post the full error message.

8.1

Don't do it. Version 8.0.1 is buggy. If you're going to version 8, make your first version 8.1.2.

Yes, both the Join stage inputs read data from the same file.

What is the "normal configuration" at your particular site?

The row count on the link shows how many rows were sent to the database server, not necessarily how many rows were loaded.

Are there any errors/warnings reported?

Show us exactly what you're doing in the DRS stage, it's usually easier to spot errors than to regurgitate the manual.

Moderator: please move to Server forum

DataStage imposes no limit.

The operating system may.

My guess is that your command search list (PATH environment variable) is finding the MKS Toolkit at command ahead of the Windows one.

My guess is that you have some unbounded VarChar column definitions - that is, data type VarChar but no Length specification. DataStage can handle that, but SQL Server cannot.

Umm.. don't know if you can do this directly, but you could post-process the data with $DSHOME/bin/format.conv (also known as $DSHOME/bin/fnuxi) command.

Forget Pivot, it's not really what you're doing. You're doing selective accumulation. You could do this with a Transformer stage, but I like the suggestion of Max() function in Aggregator stage.