DSXchange

Again, to me this really isn't an issue about "mimicking the SQL Server client" as it's got nothing to do with the client. It "works" there because you are doing a more of a "bulk" select and insert, nothing at all like the singleton inserts that DataStage is doing via ...

The second log entry for any job shows all environment variables in place at the time the job ran - what does it show there for NLS_LANG?

OK, I'll throw you a BCI bone since you seem to be having search issues. :? An example of the syntax here. Regarding documentation here. More examples here and here. Lastly, many of the posts mention the reasons why this is a less than ideal approach, like this one for example... many more exist. Yo...

Sure... a couple of ways off the top of my head. You could grep for "dsapi", the process that is created by a connected client: ps -ef |grep dsapi That should show all current. You can also get information from netstat, something like: netstat -a |grep dsr May need to refine that some, but...

And "the character set specified by NLS_LANG" is.... ?

Ah... gotcha. No, there isn't.

I have absolutely no idea what you mean by "subversion" here. Are you asking about interfacing with external SCCS systems, something other than Version Control?

Warning? What warning?

"Latest version" of 7.x, meaning upgrading to 7.5.3? Or latest version as in going to 8.1 with its completely different architecture? Big difference there.

Ah... was thinking the Sequence itself may not be the issue here, but missed the part where it allegedly works outside the Sequence rather than 'works on old server not on new server'. Mea Culpa.

So yes, that should mean exactly what you posted.

Same question with the same answer... "yes". And all the ways to do that are listed here.

Or a difference in the ODBC or Oracle client / tnsnames setup.

Ah, yes... so basically just a ".dbf" file, if I recall correctly?

Gopalraja wrote:Anybody know how to use the XML file as a source...

Yes, of course. However, you need to learn patience - you bumped your post again after what - 30 minutes? Give me a break. You're lucky John was able to respond as quickly as he did, don't come to expect it though.

Don't simply uncheck anything, rather take the time to understand your issue. A search here for "did not finish OK" will reveal all - the fact that routines that do not return 0 are considered to have failed in certain circumstances and how best to handle that.