DSXchange

You didn't try the Server stage? It would not require any modifications when / if the file changes.

Ok.... we're using the xmlOutput Stage here, so xsd's aren't employed, so we can take that one off the table for now. I realize they're out of a job directly in the stage itself but you could use the xsd to generate / save the output metadata and then import those XPath Expressions into the stage.....

Have you tried searching? Found several references to that message including this one. Could be the same person that is deleting projects.

vinu1103sharma wrote:What are the way to create XSD in datastage or other tool?

As noted - DataStage? No. Other tool? Yes, of course.

Why did you feel the need to post this exact same question again?

ecclesr wrote:database columns that are prefixed with number

In my experience, this generally falls into the Bad Idea camp - even when allowed. Right up there with spaces in the name or names that start with a space or underscore.

Or the Department of Redundancy Department.

Can you not ask whomever created the file for you what encoding it is using?

Sounds like an IBM / Official Support Provide question to me...

If my tnsnames.ora file is not correct the i can't connect in ODBC stage also. Not true... ODBC uses the .odbc.ini config file. Fix your tnsnames.ora file accordingly. From what I recall it uses the config file to point to the tns entry to use, if one is using the thick drivers. Thin... not so much...

Oh, we understand. :wink: It's all about the tnsnames.ora file as the errors note, there's no "server side Oracle setting" other than that. And ODBC may be working because you are using the thin client. [shrug] I think you have a DNS or /etc/hosts issue since "all you did" was re...

Never mind the fact that whomever that XML file is destined for should have provided one. Generating one from XML can be a little... hit and miss. And understand that I'm not saying it is a requirement to solve your problem, it was just a simple question as it can help with getting the proper metada...

Do you have an xsd for this file?

Why not use the IP address?

Any chance of when two invocations of the job go after the same "security file" at the same time, one would block the other?

:? Your post noted that it failed, not that it failed to run. They are not the same thing, hence my questions. So... which way did it go? 1. The Sequence job starts and fails to to start something inside it, which fails the Sequence? 2. The Sequence job starts and runs something inside it, which fai...