DSXchange

You can write your own, but it will never be as fast as the inbuilt functions. FUNCTION StripNonAlphas(TheString) Ans = "" CharCount = Len(TheString) For ch = 1 To CharCount Character = TheString[ch,1] If Alpha(Character) Then Ans := Character Next ch RETURN(Ans...

Your ";" delimited string is a de facto dynamic array. A "proper" dynamic array (delimited by @FM, @VM and so on) is slightly more efficient, because you can use the Remove statement to pick of one at a time; with your delimited string you need the Field() function which may require scanning from th...

Chapter 8 of the DataStage Installation and Upgrade Guide (dsupgde.pdf in your manuals folder) describes the installation process on USS, which is a partition of a mainframe running "UNIX". There are some questions in the certification exam on USS.

Job sequences manage flow of control, not flow of data.

All of those messages appeared within at most 1.5 seconds. So it does not appear that the problem is entirely within ProfileStage. Can you use the test utility for the ODBC driver to determine that you can connect successfully and get a list of tables? Can you try to import the ODBC table definition...

A File Set is a number of data files, in human-readable format, spread over the specified processing nodes. It does not require a key column to be specified in its record schema. A Lookup File Set has a similar physical structure, but does require a key column to be specified. Or more than one. This...

Are there only a few lookup values? If so you can pre-load the lookup values into a searchable structure (a dynamic array) in a before-stage subroutine and perform the search in a transform function (a Routine). You will need a small job to get the keys out of DB2 and into a sequential file (sorted ...

Why? The question is about running server jobs simultaneously, not about parallel jobs.

Moderator: please leave this thread right where it is

Welcome aboard. :D

If your DataStage client is Windows XP sp2 you may need a patch from the vendor. Search the forum or ask your reseller for details about downloading this patch from the eService web site (I don't have details with me at the moment).

How long is a piece of string? The answer is "it depends". More jobs can be handled at once if they don't do much compared to fewer jobs that each do a lot. If you make extensive use of common hashed files, you might investigate sharing these (see dsdskche.pdf in your manuals). Ultimately try to des...

Try setting array size to 100 (the same as TOAD) or even 1.

"Null keys" are an anathema! You can't tell whether DataStage found the key or whether it did and returned the null, if you're testing using IsNull().

Does this work?Note that you can not do this with a hashed file, which can only do WHERE key = 'value'.

The -s option is appropriate (you only need the total usage figure). For each directory mentioned as scratch disk resource in the configuration file, monitor with regular executions of

Is there any possibility that (a) the node on which the error was reported is overloaded, or (b) that someone is using kill to knock out processes?