DSXchange

Then put a semi-colon between the commands.

First thing I'd suggest is get your Client upgraded to a matching (or at least more recent) version. I have vague memories of early versions of the 9i client being... buggy... as hard as that is to imagine with Oracle software.

Give that a shot.

Bond, James Bond. 007.

That was the 'James' reference...

Sorry James, but it's 009 for a tab.

Zero rows out? Meaning nothing is selected? You've got something majorly evil at work here... Let's start with specifics: versions. Exact versions of DataStage, Oracle and what version of the Oracle client is installed on your DataStage server? Is your source database co-resident with DataStage or r...

That stage may be here sooner than you think!

We have source as Excel format and i converted the source excel file to test.csv format Ok, based on the garbage you are seeing, let's not make any assumptions here. Please explain how you 'converted' the excel file. Also, what does the .csv file look like if you open it in something simple like No...

Ok, I asked about Row Buffering because I've seen it cause problems as well as solve them... including goofy things like you are seeing. That being said, 99% of the jobs we own that source from Oracle do so with an Array Size set to something other than 1 - typically much greater than 1. I don't rec...

As noted, these 'X-Stages' are additional products in the tool suite, not simply new stages. Without any help from your reseller, I'd suggest you start at the official website - here.

What exact version of DataStage? You do not link to it from any object, but rather it stands alone and waits for Something Bad to happen. In earlier versions, that 'something bad' was exceptions in the Sequence job itself - job wasn't runnable, bad parameter names, etc. In 7.5.x it can handle all ex...

Regardless. I'd shoot my DBAs if all they cared about were production environments.

P.S The default NLS is set to ISO8859-1 Whose default NLS is set to that? The DataStage client or your database? I'm suspecting the former. It would be best to let us know details like which database you are using and what its NLS setting is, also if your DataStage installation is NLS enabled or not.

Perhaps because it's not a DataStage feature, but rather a database feature?

Welcome aboard. :D These are really questions for your DBA and possibly your Data Modeler or Architect. You have all kinds of ways to create and/or refresh materialized views nowadays and 'automatic query rewrite' adds more wrinkles to that. Depending on how the MVs are created, you could incrementa...

Yes.