DSXchange

This surprises me, as the schedule information seems to be stored separately from the job. At least, that's how I recall it working from a UNIX server - the schedules are in crontab and looked for by the Director each time you check the 'Schedule' view based on the current user.

Are you on Windows?

Peter, the log for job number 148 has been corrupted. Did you have any space issues with the partition where DataStage is installed? If you throw part of your error into Search here and look for an Exact Match, you should see some specific advice, things to try. I tried searching with 'Internal file...

Q. Where are the dsconfig parameters located ? Sorry, most "uv" things have been renamed to "ds" things in recent releases. This isn't one of them. If you look in your $DSHOME directory, you'll find the uvconfig text configuration file. Compare what they look like in the two environments. If I writ...

CHAR(9).

Before attempting to use Environment Variables as Rich mentions, make sure you are running at least the 7.1 version. From what I recall, the original 7.0 release added the capability to use them, but you had to recompile the job to get it to notice a value change.

Welcome aboard. Generally, you can use UNC format to reference mapped network drives, as long as your permissions are correct. There are several posts here on the subject, a search for UNC should turn them up. Like most things, there are probably other ways to do this, but I believe that this would ...

Well, the -jobstatus option does a wait, much like the plain -wait and the -userstatus options do. Not sure why they would run differently in your two environments, but if they are I'd suggest something system level rather than DataStage level. Unless... is your DataStage configuration "out of the b...

There's not enough information here to help you. Please post your script (and O/S) so we can verify the "sequentialness" of your jobs. You may also want to launch an investigation into exactly what is different between your two servers - assuming it's not in the versions of your jobs or your script.

Thankfully, the 'trick' needed to get to a Version Control project named something other than VERSION isn't needed once you upgrade to 7.x. They show you the current 'default' project and then give you an extra button which brings up the normal connection dialogue, much like flubbing the login in yo...

Whenever you end up upgrading to 7.5, you'll have access to the new Stored Procedure stage. Should eliminate all the goofy stuff like this.

Custom SQL? Usually the only way to get something like this, hence the question...

Good to know. Have you opened a case with Support for this? Perhaps they can work a fix for this into a future release...

So i was just thinking is there could be a way to work using client version instead of installing server version in all the machines. Please let me know if the question is confusing. Um... yes. What makes you think you need to install the server on every developer's machine? Yikes... Install the se...

Another way is to fully qualify the field name. Is that possible? In the Server's version of the OCI stage you can check off a box that 'enables case sensitive' queries, which will automatically quote all of the objects referenced. That might be another option for you, but I don't have PX, so...

Just out of curiousity - have you used this plotter before? Done something like this (A4 -> A0) before but from another tool? Wondering if it's really a DataStage issue or more of a plotter / plotter driver issue.