DSXchange

Phee,

what was unclear in my previous post? I'll be glad to explain.

When data is written to a sequential file with fixed width the Display width value will override the length attribute; if you are writing to a table then the length is used. The Display affects only the presentation layer (and for historical reasons the fixed width of a sequential file is considered...

Thomas, DataStage is stack-based and supports recursion - it just needs to be correctly defined. I can't figure out from your BOM description exactly what you are trying to do. What are your columns supposed to denote? Why is "1 2 b 5" a duplicate of "1 2 a 20"? I think if I understood what you are ...

Kumar was giving you the lowest level function function that you can use. This is not what I would do, but illustrates an approach you can take: OwnedPos = Index(YourString,'owned by ',1) ;** find keyword NextWord = Field(YourString[OwnedPos+10,99],' ',1) ;** find next word delimited...

Can you determine which job your routine is failing on and try that one explictly in the manager? Has that job been called in different invocations and what is the job's status? I've used these routines include the DSJ.JOBINVOCATIONS often before and have not seen any problems like this. I also went...

My fault, I was asleep at the wheel, the line should read TRIM(MyString,"'","A").

The new question is possible to answer if your rule could be written as "After the text 'owned by' or 'printed on' or 'Size in bytes:' take the next word as delimited by spaces."

Colin,

as I stated before the order isn't important within the dsx file.

Dslearner, I think I'm getting a bit confused here. You need to execute the basic code you've been listing from a routine, which is in turn called from a transform stage in a DataStage job. Your routine can be tested directly from the Manager interface, could you tell us what the error message is th...

What problems are you getting importing interdependant jobs? If you just import a job sequence which calls a server job that hasn't been imported yet you won't get a problem (at least not until you compile it).

Phee wrote:...Trim("String", " " ","A")...

won't compile since the quotes are mismatched, try if you prefer that syntax.

It sounds like you need to change your lookup hashed file into the main input stream and your current data stream into the reference stream to get the intersection and thus the complement of your two sets. Your current design will, as you've already noted, only get you the reference rows that match ...

I checked the price here in the UK and it is GBP100. I'm waiting on my userid and once I get it I'll sign up for the test {I'm assuming that it's already complete and available}. I think I do need to study up a bit, it would be embarrasing to fail it

I've done some exports of projects in that size and hadn't gotten issues - but it was on fast and mostly idle hardware. By excluding the executables from your DSX files you will save quite a bit of space; the binaries are UUENCODED {remember that old technology from old e-mail systems?} which increa...

If you have MKS Tookit or cygwin you can use the UNIX "cat" command to concatenate all your files with the same format into just one file, then you can use that name as your parameter to DataStage jobs. If you are on windows as your subject suggests, you can use the command "copy /b {filea}+{fileb}+...

sgiang wrote:...I opened a job in Designer and the session was left idle, so it timed out, thus locking the job. So the configuration changes made to dsdlockd.config did not work in this case...

That is exactly the kind of lock that the deadlock daemon will take care of.