DSXchange

It's in the BASIC pdf. My version incorrectly documents it as returning a 16-bit value, however. Searching for Michael's posts here - his id is mhester - will get you alot more information on the proper use of it.

Can you partition SQL Server tables?

One of the best ways I've seen, and something I've relied on heavily for years, are the 'Job Control Utilities' freely available from Ken Bland's website. Click on the link in his signature in his post and register there. Check them out. Ken - they are still there and free, I assume, yes? Granted, I...

Oh my, someone has set you up the bomb. Something like that isn't supported now, let alone in Hawk. And the fact that you've created 'an elaborate parm management scheme' based on this is worrisome. Why do you 'need' to update a parameter in a running job? There are plenty of supported mechanizms fo...

Which XML stage are you using? There's no 'XML file stage'...

For that, you could use the Stored Procedure stage rather than ODBC. It can be used like a transformer, so to speak, on a row by row basis.

What version of DataStage? What database?

Greetings, Len! It's always wanted it like '1/01/2500' or perhaps '01/01/2500'. Me thinks yours may work as well (never tried) but that's not the problem.

'Misteak' Arnd? Cute.

Strange to see file names declared in Administrator. Not really, when the OP stated they were Environment Variables. Same reason for the dollar sign, which must be used. Reg txt, dont declare .txt in variable declaration. Or again use the Field command to get the 'basename', using the period as the...

Have you verified, through a tool like XML Spy, that the xsd in question is well formed and all that?

jzijl wrote:While running this job I get the message: 'Sort: Input column does not promote to output column.'

All that should mean is a column on the Input side is not mentioned on the Output side. What goes in must come out, so it (the Sort stage) complained.

Nope. Not that I've ever seen or heard of anyway...

Another option is to use DSGetLinkInfo, either 'after job' or downstream in a Sequence job. Or another link in the current job with the same constraint as the one to seq file2, running into an Aggregator.

Make sure you've got the Authorization code exactly right... sometimes people mix up letters for numbers, or the case. If you've got the 'old fashioned' paper codes, the numbers are in italics from what I recall, which helps. The other problem we see once in a while is a cut-and-paste error where th...

Dude... give us a break. Read the documentation that comes with the product rather than asking questions like this.

We're more than happy to help solve DataStage problems, but these posts of yours are getting annoying...

From what I understand Craig, OP wants the Routine activity to run no matter what i.e. when job fails or finishes and extract the log information Which is exactly the kind of situation an Unconditional trigger is used for. Vijay, are you positive the Routine Activity stage is not being triggered? I...