DSXchange

Not sure I'd want to be actually emailing anything to see if it's good, there's got to be a better way. One sec... I put 'validating email addresses' into Google and got 1.4 million hits and all kinds of references to packages to do this. Also some fun stuff like this that may help someone architect...

Automagic, built-in uniquely generated value? No. Something you could do? Sure.

Do you want to recap why you don't currently have it all in one right now? I don't really understand the relationship between the two in your last post or what issues you've been facing other than the Notification trigger, even after re-skimming the entire thread. Your two different sequences - is o...

RAI ROUSES wrote:ds job can open the xml file, but didn't read any data, it pass 0 records from the stage input xml. The process finished with sucess, but didnt do anything.

Your XPath expressions don't match up to what it found in the file, so nothing made it through. More specific than that, I cannot be.

See if this post helps or any of the other posts you can find by searching for NLS_LANG.

If not, come back with more details, like what NLS_LANG setting your target database is and some examples of these 'special' characters. Some are more special than others, from what I recall.

Why do you think one of his job titles is "analyst"? He could (should?) have pointed out that what's postulated is not even possible in a sequencer. It is, of course, possible in a job sequence. The only thing you can do in a sequencer is fire its output trigger(s) if any or all of its inputs have ...

Well, they do say you can lead a horse to water, but...

Are you running jobs in your 'daily nightly batch' under several different userids? I seem to recall reading that that was the cause of those messages. My current client has been running over 1000 jobs daily and has never seen those warnings, but then they do run them all under a single 'function' u...

I've never seen it officially documented anywhere, this is just from my experience using it. And Narisimha is correct in that whatever your condition is you select - for a file to appear or disappear - when the condition is met you get an OK status from the stage. When the timeout limit is reached, ...

You don't need to check anything specific for this. Two simple triggers - OK (Conditional) and Otherwise will do it for you. OK will fire when the file is found and the Otherwise trigger will catch anything else, including when it doesn't show up.

You don't need a custom stage, or a Nested Condition typically. As noted, you should be able to do this via Triggers the vast majority of the time. Send the results off to Notification that you want and the rest simply bypass it. If that's unclear, why not provide some specific examples so we can un...

Since the ? parameter markers are positional, the only way to 'use the same one multiple times' is to duplicate the column that many times and populate each with the same value.

You don't "need" to stage, it is however a Best Practice. But like any rule, it doesn't need to be slavishly applied 100% of the time. Depending on the nature of the job, volumes, restartability, etc you could skip the stage part. And by 'stage' in this context you mean 'land', as in to a flat file,...

You can also go to Kim Duke's (kduke here) website and download the Ascential 'XML PACK Best Practices' document we uploaded there. His URL is in his sig in any post here.

The next val is not working.... What do you mean "the next val is not working"? Selecting nextval (note that it's one word) from an Oracle sequence object works just fine, however you've never confirmed nor denied if that is the source of this mysterious "sequence number". So either you ain't using...