DSXchange

Better to use an 'Otherwise' trigger... and make sure you set the Sequencer to Any not All.

The reason why this is needed is well documented in the help available either online or in the pdf documents on your client pc.

Your problem isn't very clear. Are you trying to find a way to load XML without going through MQ? What is your target for this data? "Into DataStage environment" doesn't really mean anything. Have you looked at a combination of the Folder and XML Input stages? That's a very typical way of doing what...

Hah! This time Ken typed faster than I did.

Interesting. Hopefully it was done for a reason. If you've been reading along with us for awhile, you'll find a few references to Oracle and the fact that - if you let it - there are times that it will slow down what it is doing. In other words, if it senses that you can't keep up with the pace it i...

Which exact 7.x version are you running? And are you under the impression that none of the property values are changeable for you or are you just having an issue with the default padding symbol?

Unless you've got a 7.5.x version, in which case it is on both.

But, it says, converting string value '02-Feb-2004' to date is unsuccessful... What makes you think Oracle wants it in that format? Best Practice would be to standardise on an ISO Standard Timestamp format to eliminate any date and/or timestamp handling issues with Oracle. If you declare the dataty...

No problem. I think technically it may need a Warning trigger rather then Failed for the file not found - it should be documented in the help for the stage. In any case, I've always found the 'Otherwise' trigger to be the better option as it handles 'everything else' not already handled.

It's 'not working' how?

Simplest way is an 'Ok' trigger and an 'Otherwise' trigger. The Ok trigger will fire when the file is found and the Otherwise one will handle when it doesn't show up.

In general it's a bad idea to have two or more writers to the same sequential file. In general? I'd use stronger words - it does not work, is a Very Bad Idea and, as you noted, if it seems to be working it's just luck. The solutions have been touched upon, separate 'sessions' working on the file, s...

That's a far better answer than what I was thinking about giving, which was basically one word that started with a 'G' and ended with an 'oogle'.

That's true with regards to the change to enable expressions in the parameter area. It's already bitten one dev here who put 2006-02-07 (for example) into one rather than "2006-02-07" and instead of getting a date ended up with only the 'year' of 1997.

He was shocked. I laughed.

You are probably not connecting as the same user that you used for sqlldr... and the user that you *are* using doesn't 'own' the table in question. Do you specify the schema during the load or is that left empty?

A job activity in a job sequence, however, expects to find an expression (rather than a value) there. No, it doesn't... it is perfectly happy with blank expressions. I have tons of Sequence jobs with Job Activity stages where nothing is in most of the parameters. When you park your cursor in them t...

Search the forum. If you have 7.5.x there is an official Stored Procedure stage, other than that you need to use an ODBC stage.