DSXchange

Keep in mind that - potentially - every stage in a parallel job requires one process on each processing node in the configuration file, not to mention one section leader process per job per processing node and one conductor process per job on the conductor node. Multiply this by 18 and you have way ...

Keep in mind that - potentially - every stage in a parallel job requires one process on each processing node in the configuration file, not to mention one section leader process per job per processing node and one conductor process per job on the conductor node. Multiply this by 18 and you have way ...

Someone seems to have reinvented the echo "" > filename command!

Assuming you are running version 7.5x2 (the only parallel version certified for Windows), you can use UNIX commands because MKS Toolkit is installed. However, there is no /.dshome file. The dsenv file is in the DataStage engine directory, by default D:\Ascential\DataStage\Engine (substitute the corr...

In which stage type? You could use an External Filter stage and use the regular expression syntax. You could use a Filter stage and use SQL WHERE clause syntax.

We expect shortly to announce availability of a beginners' class in writing server routines. (This is already available from my personal business, we're working on offering it through DSXchange.)

Welcome aboard. :D These are not "groups" as such, they're properly referred to as DataStage roles. Each role can have one or more operating system groups associated with it. Thus, for example, you might set up UNIX groups for each project and another for the operator staff. Once these have been set...

Trigger would be slower. You'd have the overhead of the trigger, which would have to get the NEXTVAL from the sequenece anyway and then modify the row being inserted. Eschew triggers for this kind of work.

If INDEX(strValue,'-',1) > 0 Then Ans = Ereplace(ValueString,'-':Substrings(ValueString,INDEX(strValue,'-',1)+1,1),'-' : Substrings(upcase(ValueString),INDEX(strValue,'-',1)+1,1)) End would also solve the problem of the return variable (named ...

I have worked on modules which involved around 150 - 200 jobs running one shot. At such place I can't go for sequencers. Wrong. There is actually no limit. To keep things easy to read/understand, build a hierarchy of control, using Job Activities to call other job sequences. I'm confident you can f...

I rather suspect Arnd was subtly suggesting a search.

ANY data type can hold null, provided that the column is defined as nullable (that is, not defined as NOT NULL).

Null (unknown value) is not the same as "" (empty string, or zero-length string, which is a known value). You can not put "" into any kind of numeric column.

From memory (in an airport lounge again!) DSP.Open may have something to do with initializing a stored procedure call. If that turns out to be the case, check that the SP definition exists in your repository. Curiously this airport does not have a copy of the source code for DSP.Open, so I can't adv...

Try Iconv(StrCol, "DDMY")

I've met that challenge in the last eight out of eight months.
Guess that makes the point a strongly as anything else I may have posted.