DSXchange

Hello & Welcome to DSXchange. This is an odd first post.There are hundreds, if not thousands of experienced DataStage developers in this forum, yet you have managed to alienate many of them, including myself, by stating ...most DS consultants can't answer this, and don't know where to begin look...

You can use the DS/Basic "MATCHFIELD" function. If I remember correctly it even has an example on how to parse a ZIP code or SSN from a string. Look it up in the BASIC Programmer' Guide

There are so many factors that can affect the optimal configurtion that there really is no easy answer. The best approach in my opinion is to develop with a 2 or more node configuration. Once the job is ready to be tested, do timings with 1 (yes, many times a single node configuration will be the mo...

You do not have 30Gb free in /path/xx.

Never assume a CWD in scripts. The CWD of any script called from DataStage will be the directory where the project is installed. If you use an absolute path for all references or you change your working directory explicitly inside the script you will be OK

Ken is right - and I've been Nastygrammed (haven't opened the pm yet, but I suspect a Harry Potter-like "Screamer")

Could one of the table names be invalid for ODBC (i.e. contains unmappable characters or be a keyword)? What is the name and DDL for the "bad" table?

Comment out the after-job subroutine call in your job, run it with the full data and then see if manually running the .bat file from a DOS session works or perhaps has the same problem.

Go to the Manager, job view. Select & delete all jobs. Go to the Routines, select & delete user routines. Repeat for other categories as necessary, i.e. the table definitions, shared containers, transforms.

But the error is that the source files aren't being found. Have you tried using the DOS "move" instead of the add-on "mv" {probably MKS tookit or like}? Just to make sure the error isn't being introduced by that program.

Try using "move" instead of "mv" in DOS.

sam, what happens when you run the .bat file from the cmd shell manually? If that works and it doesn't from the job then I would look to make sure your paths are absolute in the .bat file. Perhaps you could post the code here as well.

edward_m wrote:...'alex alex alex' gives 5 spaces.

Why don't you do a COUNT(TRIM(In.String),' ') to get the number of "words" as separated by one or more spaces? You could also extend that and do a COUNT(TRIM(CONVERT(',',' ',In.String)),' ') to parse out the commas.

It looks like your two string are identical, was that a typographical error? Won't the function COUNT(In.String,' ') work for you?

try "chmod -R 775 NewDDWHash" for a recursive change.