DSXchange

You can also use DSExecute - check the online help.

denzilsyb wrote:Are file sizes an issue?

Yes! There is definitely a limit on the file sizes the Folder stage can handle. Unfortunately, I don't believe there is a hard-and-fast number published by Ascential... it seems to vary by hardware and version.

At this point, it would seem the SQL Catalog for that project is horked up. There are a few posts on the subject here, this is one of the ones that helped me when facing a similar problem. Note the rather strong warnings Ray gives in this post about having a good backup. Executing any of these steps...

PilotBaha wrote:How can I prevent the hash file name to be drived from the link name?

You can't, the link name is the default hash name. However, it's a simple matter to rename each one to a single, consistant name so they all end up writing to the same hash file.

As an FYI, these SDK routines are documented, some better than others - check out the Short and Long Descriptions in their properties. For example, this routine says: Sequence number generator. Routine to generate a sequential number. This routine does not support access to a particular sequence by ...

The 'fix' is to uninstall SP2. There are notices of the issues SP2 causes posted over on ADN if you have access to that. I understand there is a patch for the problem, but it is only available for 7.5 as far as I know. Edit: There is a post here where this is discussed. It notes that the patch will ...

I think Ray may have missed the point that you want to capture the 'errors' from when the DB2 lookup 'fails' - i.e. it doesn't return a record. He is answering based on the failure of the write of the Output link, not the lookup. I think you've already gotten your answer in your first post - I don't...

When you include Routines that return a non-zero return code, you can't take advantage of the 'automatically handle failure' option, as that is considered a failure in the routine. Not without special handling, anyway. Make sure the trigger from the routine isn't just a 'Ran OK' trigger, try making ...

sonia jacob wrote:sorry i panicked.

No problem. I certainly would have, given the same situation. :D Glad you seem to have it sorted out.

Is there anyway to get the list of jobs aborted in the Project directly? More than likely. I'm sure you could query the underlying structures and only get the jobs you are looking for. The syntax is probably in the forum somewhere, or one of the Grognards could post it for you here, I would bet. Ho...

Anything happen to your server that you are aware of? Any chance you've run out of space where your project is installed? Here's hoping you've got a recent backup, just in case...

No, sorry, wasn't kidding. I misunderstood what you were saying was your favorite. From the way the sentence was phrased I didn't think you meant BASIC jobs in general, I thought you had a specific example that had been posted here and had forgotten to link to it. FWIW, I completely agree. While we ...

Hey Ogmios, out of curiousity... which one is your favorite?

Was thinking about this. Is there any way to constrain your job to a unit of work such that it completes within your 10 minute window? You could setup a looping master control job that kept it executing. Was wondering what your alternative was to your job constantly killing itself. In either situati...

Check the syntax for the DSExecute command. You need four parameters, only one of which is the command to execute. First parameter is the O/S, in your case "DOS". Second is the command(s) to execute. Third is an array to hold any screen output from the command and lastly the parameter that holds the...