DSXchange

All kinds of information out there on the subject that a search would turn up. Ignoring that this one is for Java (as that doesn't really matter) here is one such example.

Have you asked? Mine has "very strict" rules as well but will make an exception for a good business case.

I doubt Ray (or IBM) will be updating it any time soon to support new operating systems but he may come along and be able to share the algorithms behind it... who knows?

Have you thought about taking the ddl from an XP machine and moving it over to your Windows 7 pc? You'd need to manually register it using regsvr32 but that might do the trick.

True.

It's the old 'command output has field marks in it' issue since it returns the values in a dynamic array. Try using array notation: Trigger1:command_activity1.$CommandOutput<1> > 1 Trigger2:command_activity1.$CommandOutput<1> = 1 Or use Convert() in the trigger expression to convert @FM to ''.

As noted in the initial post, this is 7.5 which I don't recall coming with any such scripts. Could be wrong, of course, but don't remember any such.

This section of the documentation should help.

#1 is valid, #2 is not as the 'OR's make it always evaluate to TRUE.

Welcome! "One by one" would mean using a Sequence job with the "looping" stages - Start Loop and End Loop. You can use the User Variables Activity stage to generate / retrieve a delimited list of filenames and the Start Loop stage can iterate through them and pass them one at a t...

Shouldn't be all that hard to confirm. As noted, the error tells you that based on your lookup key that it found more than one match in the lookup data. So please, check your 'data set' again.

I doubt you enter either the actual SID or ServiceName there, have you tried using the name of the TNS entry there? It would then specify the actual connection information to use.

It seems you have more than one statement, which is problematic. And the fact that it 'runs fine' outside of DataStage doesn't mean a whole lot if it is not properly constructed for what it is being used for inside DataStage. However, the error is Invalid object name '#SCTY_XREF_TEMP8' so I'd sugges...

You need to properly size the hashed file when it is created, which involves computing the initial 'Minimum Modulus' value under the 'Create File' options in the stage. I'm assuming the Hashed File Calculator is still being provided... if you can find it, it will help with computing the correct value.

Well... you can alway try stopping and restarting DataStage. Worst case reboot the server itself. Otherwise, I've used DS.TOOLS in the past but don't have any access so examples will have to be off the top of my head. From the command line: cd $DSEngine bin/uvsh (you should have a TCL prompt ">...

What kind of "info" are you looking for? Batch files would be the Windows equivalent to UNIX scripts, batch jobs are something else entirely... basically they are hand-coded job control opportunities written in BASIC and the API much like a Server routine. If you don't have an Enterprise s...