DSXchange

What do you mean by 'how to use'? You execute orchadmin just like any other command line function, including dsjob. Do you have a more specific question?

How many nodes? What is your sequence's cache value?

Nothing, more than likely. All that tells you is what it is for that session, which is typically controlled by the application you are using. For example, Toad allows you to set dates and timestamps to display in whatever format you desire. Best to check the NLS_DATE_FORMAT in the database itself.

Make the SQL Type for that column a known value - Char or Varchar, I would guess.

As noted, any return value other than zero is considered a failure. Check the docs for that 'Automatically handle' option or search here for 'Unhandled failure' for discussions on how to 'handle' it yourself.

If you are referring to the 'Backup' option available in the Sequential File and Hashed File stages (perhaps others) from what I recall it creates a directory called DSBackup at the same level as the object in question and 'backs it up' by copying it into there when the job starts. What's nice about...

You have a Windows license, not a "32bit Windows" license.

Then it's locked.

If you haven't done so already, go to Kim Duke's site and download the XML Best Practices doc from his Tips section. Lots of great information in there.

It really depends on what you need to do. One check in a constraint or stage variable tells you if it succeeded or failed. After that, sure, you may need to refer to it for each of the three fields if each is used in a derivation and you need to know there (at the field level) if the lookup failed o...

I'm a little lost as to what is going on. Been testing this myself tonight and it works fine for me in a Server job / transformer but is being cantakerous in a PX job. :? I can use the job parameter directly in a Server transformer derivation ($envVAR) and it works fine. While the ellipsis will also...

Someone else was using the table, that's all that error means by 'busy'.

Let's see if we can get a clearer answer. Is this an issue just for you or does it happen to everyone? The answer will give us a better idea if this is a Client or a Server issue.

So in the derivation column, if I code '$envVAR' will the target value be $envVAR or \home ?? You should be picking this up from the ellipsis (...) Parameter Helper rather than 'coding' it yourself as it knows what syntax to use when. You've said it's a job parameter, what do you get when you popul...

That's got nothing to do with 32b v. 64bit, that just a limit configured into your O/S. You need to ensure that you have LFS or 'Large File Support' capabilities and there's no ulimit getting in your way.