DSXchange

Basically your projects are incompatible. Does this message cause jobs to abort, or is it just a warning? There are two workarounds and one solution. Workaround 1 is to use a message handler to suppress the warning or convert it to informational. Workaround 2 is to edit the export file before import...

Does the dsjob -logsum command work correctly?

What about the partitioners in the score (the tokens like <>, =>, etc.)?

Windows Explorer

Never heard of it.

Can you provide more context?

I tested the more recent one that I posted and it works. For arbitrary string lengths. On what basis do you assert otherwise?

Do the scores yield any useful information, particularly about partitioners?

I was responding to datisaq and still am. Check out the permissions on objects in the project directory. The best place to set umask is in the dsenv script. Since you are certified in (what, exactly? there is no Information Server 8.1 certification as far as I am aware) you should have been aware of...

The "Left:Right" solution involves concatenating everything to the left of the removestring with everything to the right of the removestring. It's most clearly represented as a set of stage variables. svLeft Left(InLink.TheString, Index(InLink.TheString, InLink.RemoveString, 1)) svRight Ri...

Transaction size = 1.

The count in DataStage is how many records were sent. Your transaction size is a whole multiple of the array size, which is the right thing to do. End of data always generates a COMMIT (well, it's supposed to anyway). Might be one for official support. I wonder could it be an issue with client and s...

There's no best practice on this. XMETA is merely the default name for the database instance. As noted, that name is still required for the tablespace and the owning user.

You can not update @RECORD, because it's a system variable. The only way you can update any field using SQL in a UV context (such as DataStage) is to have a properly defined data field in the file dictionary. Of course, that can be created with an INSERT statement with the keyword DICT preceding the...

Once you get version 8, you have a resource estimator tool and a performance analysis too, which make this task far easier.

Just out of curiosity (since it won't be an obstacle), is your production a Protected project?