DSXchange

No such thing as duplicates in a hash file. No such thing as a hash file with no keys.

Threw the whole phrase into Google and quite a bit came up. Seems to be related to AS/400 platforms and DB2/UDB databases. CCSID stands for 'Coded Character Set Identifier', btw, so I think you are on the right track Arnd.

Can you let us know what was the response from Ascential? Wow... I'd forgotten all about this. I never did open a support case and this error hasn't happened again. For us it had nothing to do with privledges because a single generic userid is (and always has been) used to run all jobs. No UV table...

With the example above, would the hash file (or at least the DS Engine) be clever enough to know it has an input and an output and therefore refuse to open the output until the input has given it relevant instructions? Basically, yes. It is 'clever enough' to understand the dependancies between the...

Yes, several of the plug-in stages are optional and must be specifically selected during server installation for them to be accessable. Rather than take the dspackinst (or the export/import) route, I've found it easiest and best to repeat the Server installation. It will determine it is in 'maintena...

Michael, you should seriously consider putting together a FAQ on this subject for the FAQs Forum. Save you repeating yourself whenever the topic comes up.

That's an... interesting requirement. About the only advice I have off the top of my head would be to sort your input file on ColB descending so that you can take the first X rows that match the looked up value rather than the last. Last is generally a pain and involves reading ahead and also knowin...

user defined Sql query is one of the performance tunning techique in DS. It is always a better option that generated one. you can use all type of oracle or any database inbuilt functions to the max extent thereby reducing the complexity of the job :D I'm with Vince and of the personal opinion that ...

How to explain this ?

Hmm... can't.

Why it will be re-run automatically when the system resource is free.

It doesn't. At least not usually.

Can we adjust the value of "Timeout" more longer?

Nope. Hard-coded down in the Engine.

There are specific syntax examples in the post I linked to above.

Should mean that something got clobbered that DS was reliant on, usually a dll, perhaps by another recent software install. Reloading the Client can straighten things back out.

Glad you got it sorted.

It's a bug in the Client, some sort of .NET issue I assume. We see these once in a great while. The best you can do is clean up the mess when it crashes and start over again from your last saved session. Unless you are seeing this on a more frequent basis? If it is reproducible, you may need to rein...

Read the help that comes with the Oracle plugin stage. Your option for any sort of 'transaction control' comes via the Transaction Handling tab in the OCI stage. As long as multiple links come from the same transformer, you can 'enable transaction grouping'.

nkln@you wrote:Is there any difference in these approaches like transaction control, number of oracle sessions.

Of course.

1. One session, allows transaction control.

2. Two sessions, no transaction control, can block each other.

One good place to start would be the home page right here. There is a link to a forum post there with information and a webinar you can check out.