DSXchange

Understand that we haven't even gotten to any datatype issue. The problem here is a derivation change, made to the .dsx and then re-imported, that allegedly does not "stick" - i.e. show up as changed in the edited job.

Which I didn't mention because of this, so just addressed the "all projects" part:

sreenu443 wrote:I am able to get the Project wide log.

So... it's not really resolved, is it?

No clue. While I'm sure there's a limit to the number the widget can support, I doubt it's anything you'll ever run into.

What database? Oracle wouldn't do that, but from what I've read here, DB2 does. Check with your DBA to see if there's some way to suppress this informational message.

Welcome. Sure, you can get logs for all projects - one project at a time. And "dsjob -lprojects" will list all projects on the server.

From what I understand, that function can only be used if you've used the Surrogate Key Generator stage somewhere and created a 'state' file for the sequence. Have you?

What "does make a difference"? Can you expand on your comment, please?

The latter. These 'SET' commands need to either be in the sql you are executing or something standard you execute in your sqlplus interface before you execute the sql. You can also investigate the use of "login.sql" or "glogin.sql" files, they are like "rc" files for sqlplus. ps. Found a nice FAQ he...

If that is what is happening, you'd need to work with someone else - a SysAdmin - to see what your options are.

Run the query outside of DataStage so you know how long it will take. I suspect you have a network/firewall "inactivity timeout" issue here, but you need to know how long it will appear to be idle to have it addressed.

Google. For example:

http://www.michelhollands.com/blog/?p=24

There really isn't one.

Best to open a case with your official Support provider, I would think.

The distinct clause adds the sorting/grouping I was asking about. When it "works fine on sql server" how long does it take to start returning rows with a "large" volume?