DSXchange

What exactly are you expecting it to do? What a key combination does is up to the application, one shouldn't assume it does anything in particular.

Welcome to your own topic! :D FYI - I split this out from this older post on a similar subject, if anyone wants to see where this came from. Always best to start your own post when you have a problem, even if it is similar to someone else's issue. You can always write up what you are dealing with an...

The database you would connect to using the Oracle Connector? Pretty sure that would be Oracle. (I kid) :wink: I've asked my DBA if there are any specific grants needed to do DIRECT loads via sqlldr but he doesn't think there are any. Now you may need to drop and rebuild indexes as part of the proce...

If you are really concerned and want to track down the root cause of this behaviour, involve your official support provider. Afterwards, come back and let us know what you found out.

Ah yes, the wonders of dynamic SQL. I would assume all databases have a similar set of metadata tables / views.

I know it was a little confusing but IsValid() only takes a string value to check to see if it can be successfully converted to the desired data type. It makes no sense to call it with any other data type because as you noted all you could have in any of them would be (at that point) a valid value, ...

I will try not to think field() function in every post and reading the records as single string. :( Please don't take that as any kind of comment that you shouldn't help people here - we appreciate everyone who pitches in with the problems that people post. I'm just saying to save the field() funct...

The Parallel Job Developer's Guide has a large section on "Date and time formats". For time formats it includes the tag for AM/PM.

zulfi123786 wrote:I have a question regarding "Fails to run" , does it mean the exception handler is triggered when the job is invoked but did not run as in the job is not compiled or is in aborted state or job does not exist etc

Yes. And (as noted) only in those circumstances.

As is the name of the person helping you.

The new XML stage is meant to replace the older XML Input and Output stages. As you've seen, it is a completely different architecture under the covers and is strictly xsd driven. Ernie can spell out the advantages (speed, file size, ??) and why there are times when you may need to use the older ones.

First off do not use a Sequential File stage to read your XML, use the External Source Stage as noted here. I'd also be curious if you marked one element as the 'repetition key' by noting it as a key column? If not try making one of the lowest level elements as the key, say "Directie". Onc...

bhasds - I really don't understand your fascination with the field() function, which practically all of your suggestions include. The input example posted has eight columns in it, there's absolutely no need to read it as a single string and manually parse them out. And actually Ray, the first four ...

It popped up here a number of years ago, don't recall who first posted it but some searching might turn it up. And I remember thinking that as a technique it was quite... cool.

And especially for something obtuse like that... I have no idea what "AVI is, it would probably have helped to spell it out.

Anyway, does this happen just to you or everyone? Basically trying to see if you've got a client problem or something else.