DSXchange

ArndW wrote:If you output the strings to a sequential file after reading them are they already incorrect?

Good to hear. Not sure on this, let me check...

Sorry, but I'll need some clarification on what you mean by 'conversion in DS is none' and what the 'correct ENV settings for Oracle' would be.

Ok, I'll be the first to admit I'm an NLS virgin - I understand the concept but haven't had a need yet to work outside of the default, non-NLS-enabled character set. I'm not even sure how to check what the character set is when NLS is not enabled. So, I have a question... Both source and target data...

The 'File Name' would need to be the complete path to the pipe. Don't forget you need something to write to the pipe as well, assuming this job is the 'reader' job.

Do you mean that you've enabled the 'Validate Output XML' option in the stage? In the documentation, it states that you need to reference the schema to check against in your doucment using the schemaLocation attribute, did you do that as well?

Have you considered doing the equivalent in the job before sending it off to the DRS stage?

As Arnd notes, your example doesn't help illustrate your situation at all. And there isn't a question in your post unless "which will go to first field" is really "which will go to first field?"? You should probably look at the Field function to bring the individual fields out, but we need a better ...

The original subject, "Condition lookup", means that the second lookup is only attempted should the first lookup meet a condition. All lookups in a single tranformer are always attempted. Constraints have no impact whether a reference SQL is fired or a hash reference read is made. Never said that t...

Exactly.

It will be the current default for any new jobs created in the project post change.

If you want to change it for your multi-instance job, change it for that one. You can override the default, ya know.

Welcome aboard, Sandy. :D Rather than rush down the Yellow Brick Road and pursue a function that may or may not help or even exist, how about expanding on this for us: I am unable to compare zero values. How are you unable to do this? What have you tried and what kind of problems or errors have you ...

When I am trying to save or compile jobs, I am getting this eeror - Unable to write record <Job Name> to file RT_CONFIG 1342 This has been happening frequently now, and has been hampering my developmnet a lot. An someone please tell me what this error is, or how this can be dealt with. Once this co...

You should be able to search for the key words in the error as it has been discussed here before - this being one such example.

Or just have it do both lookups and check them in the proper order. No need for stage variables or extra links, really. For something as simple as this I don't see a need to go to the trouble of Link Collectors and all that, but it should be kept in mind for the future. Your post has almost the exac...

Welcome Aboard. :D Have you read the 'XML Pack Designer Guide' pdf? It will help with the process of using the various stages, but a lot comes from experimentation - and it *is* a lot to absorb. You should be able to get what you need from the XML Output stage. More information would help here. What...

How to notify the job? You mean, how to have the job notify you? That would be through the use of the Notification Activity stage, oddly enough. It is used to send an email, typically when something goes wrong but could be for any purpose where notification is required. Suggest you read the Designer...