DSXchange

Just to add to the previous post... Even if your source isn't a Seq file there's nothing stopping you from writing it to a Seq file and using that same method.

OK, hopefully I haven't misunderstood. But the way I would do it is to extract all the rows and only keep the one I need. I would probably do this using Stage Variables or easier still in an aggregator stage.

Is there a reason why you can't sort the data to get the max date?

If I understand your question correctly then the "Overwrite Existing file" check on the Seq File stage does just that. It doesn't delete the file and recreate so the "Created" timestamp remains the same. If that's what you really need to do then you can do it in a before job rout...

Hi, '@AM' is the same as the system variable '@FM'. Both equate to a CHAR(254). You can get some info from the DS Basic guide which should be installed on the DS client. Your syntax looks fine. But it depends where it's being used. For this type of thing you have a choice of building the array befor...

Doh . Should of read the question properly. Thought they were looking for the first 0.

One more suggestion would be to use LOCATE statement on your array.

something like... Check out the DS Basic manual for more/better help.

Regu.

please ignore - should've read the manual!! didn't realise I could do command line dsjob with a -server option.

How about loading to a hash file. You can have multle inputs to the same file. Obviously make sure your keys are unique and since you don't know which link will write first ensure that the file is cleared prior to the job running.

Gents,

We have two installation of DS (one NT and one UNIX). I need to invoke one of the jobs on the NT installation from a job on the UNIX installation and if that job is successful continue processing on UNIX. Any ideas on how I can do this would be appreciated.

Regu.

that's great - thanks.

Thanks Ray - I did try and get the company looking at the Product but they decided they could do it better and cheaper.... 9 months and a whole lot of caveats later there still trying. All I need to do is test a small bit of their code by replicating the same type of functionality in DS. They've use...

Thanks and you're right the joys of name/address data.... can you give me a bit more info about "bubble-sort". I'm guessing it'll be something like load the string to an array and sort it on the way out, but it's the sorting on the way out bit that I need help with.

Cheers,
Regu.

Hi Gents, I have a situation where I need to compare the contents of two columns. Easy enough I hear but there are catches. It need to be case insensitive and only compare alphanumeric characters. Now I'm ok up to this bit but what I need to also is demonstrated by this example. String 1 = "Mr ...

Hi Ray, I can't do the tracing thing until Monday because I'm working remotely today with no access to DS. I have run the command though and got the following result... DataStage/SQL: Invalid association operation: Column "f2" in an association must be MULTIVALUED. mmm... This TCL stuff is...