DSXchange

balajisr wrote:yes craig i know about the Continue Trail button.

Good, just wanted to double-check as not everyone did.

Can't help on the specifics of DB2 connections, but in general... There should be no need to manually add the branded odbc libraries to the library path, that happens automatically during the installation and is controlled by the dsenv file. Adding it into the user's .profile won't help when it come...

Hmmm... didn't really want to build any kind of a singleton looping structure, as I could have upwards of 500 files at a time to process. The folder stage makes pretty short work of them as they are small files. For example, the 509 I mentioned in my original post took all of 10 seconds to process. ...

On the other hand wasn't there an option to have a column containing the file name somewhere? I wonder if that might be also used? Yes, but you are thinking of the Folder stage which is used to feed the XML Input stage. However, once it gets there I can't find a way to capture that information when...

I've been trying to find a way to capture the filename of XML files that fail validation as they are processed through an XML Input stage. Right now, I've got the 'Validate input XML' and 'Log reject errors' options enabled in the General tab of the stage. This gets me messages like this in the job'...

Chulett Lando had mentioend he did not want to use two seperate links and u gave him the suggestion of using two links ?? My suggestion of using the customized sql was based on the assumption that the users have a basic knowledge of working with DataStage. If he had asked about the details of how t...

If you are on version 7.5.x and Designer is crashing specifically while editing a Sequence job, this is a known issue and there is a patch availalbe from Support for this. Other than that, sometimes a reinstall of the Client software helps...

Had to go back to the homepage and double-check. Sheesh... what a long, strange trip it's been. Thanks all!

Did you try clicking 'Continue Trial' under the button?

It was another of his own quotes, about Sequence versus Sequencer I do believe. Hence the (ibid) that he added.

Time to change mine.

I guess that makes it unanimous.

What 7.x version of DataStage do you have? Ideally, the answer should be to check / enable the "Add checkpoints so sequence is restartable on failure" option. You may also set the "Automatically handle activities that fail" so that all you need to include are the "Ok" paths. When the job aborts, its...

Welcome aboard! Check this post for your answer.

Was gonna get there when the query was posted. Biggest thing is to ensure that all columns are 'bound', that there is a parameter marker in the query for each column defined in the stage. Also, fields marked as Keys are expected to be used in the 'where' clause but I'm not sure if that is enforced w...

First place would be the "XMLPACK_20_Designer.pdf" document in the Docs folder under your PC's client install folder.