DSXchange

0.063 seconds elapsed for the stage doesn't gel with 12 hours for the job. There's something badly awry here. What did your support provider suggest?

I do make serious use of a Template, which contains the standard set of job parameters for the project. (Yes, I know, I should be pushing Parameter Manager.) We do put the template on a shared drive, and change the Registry to point to there. The issue with underscores is a bug, pure and simple, pro...

If you don't want to use ED you can use SQL:

There's no legal way. If you inspect the code produced by compiling a Transformer stage you will discern that each column is assigned to an element of a dimensioned array called STAGECOM.ARR. Other elements in this array are used for other purposes. With lots of knowledge you could use a MATBUILD st...

You can not create a project with any of the commands you're thinking of. It must be created with CREATE SCHEMA so that appropriate entries are made in the SQL Catalog. It also creates an entry in UV.ACCOUNT if done properly. Next, you must copy all files from the Template schema, which has all the ...

Build the error messages in stage variables, setting them to " " (space) if no error. The column to be output is the trimmed concatenation of all (both) the stage variables.

Was DataStage installed by root or dsadm? Can you see the project paths if logged in as root?

Stopped manually is a special case - it has its own status value. You won't get it into version 8, because that's almost finished beta testing and is just about ready to ship. Version 10 maybe, if you can make a business case (so that it's worthwhile IBM expending the effort).

Did they tell you why these particular four parameters, and why those particular values? And why not GSEMNUM, which usually also changes when the last three of your list do? Warning to everyone else: these values are probably the result of an analysis of Yamini's system - they are unlikely to be cor...

I think finally what i need is a function that accepts 2 dates and returns an integer number of days DataStage stores dates in internal format as an integer number of days so all you need is simple arithmetic subtraction of the internal forms. Get to internal form using the Iconv() function. The se...

One of the MKS Toolkit requirements is a temporary directory. Either change the TEMP and TMP environment variables to point to a directory that exists, or create a /tmp (not the same as Temp) directory on what is the current drive when DataStage processes run (on my system it happens to be D:\tmp).

That's what I remember seeing too; at another site where they only installed parallel they could create job sequences. After my visit they had server installed as well (why not? they'd paid for it) and had been shown that lots of small tasks are more efficiently performed with server jobs.

Unusually, all of the metadata you need is in the file dictionaries for these hashed files.

Code -1006 means that the project name can not be found. Check that it is spelled correctly and cased correctly.

Can you use the non-run options with dsjob? For example

Nice technique. Maybe >> would be better in the print command. This would not overwrite the file for each new record from that country.