DSXchange

Using Windows Servers, and DataStage version 7.1 We are using parameters to change things like dates and such throughout our jobs. The one place we're having a problem getting the parameter to work is within the e-mail notification stage we use within DataStage Sequencer jobs. We have some e-mail no...

We are using DataStage 7.1 on Windows Servers. When we have certain stages going directly to each other (in this case, a Link Collector directly to a Transform stage), we get an error saying that the stage does not support in-process active-to-active inputs or outputs. In the past, we simply put a f...

Eric, OK, I jumped the gun and thought that you were getting IDs mixed up. In that case, the User/Password that you enter in scheduling the job should be that which runs it, just as you did (correctly) state in your original post. So if the job isn't even getting started then either you have a type...

The userid/password you enter in this location is to tell the scheduler which userid/password to run under and isn't related to the database connection at all. You should put your database User and Password information into job parameters; and either use the default values at runtime (by not explic...

Sainath.Srinivasan wrote:Did you check the permissions for that user?

What kind of permissions are you referring to? That user has permission to the SQL Server table. If I actually log on and just run the job, it works just fine. It's when the scheduler tries to run it that nothing happens.

We are using DataStage v 7.1 for Windows Server. We have some jobs using SQL Server tables. When we schedule them to run, they blow up, because when the Scheduler runs them, it does not have the valid userid/password needed to access the tables. I found a spot in the DataStage Administrator where we...

DataStage version 7.1 I am reading in a TimeStamp field, and in the Transform Stage need to check the date portion to see if it is more than 6 days old. I am going thru DataStage help to find out how to do this, but it hasn't been all that "helpful" so far. I'm going to keep trying that ro...

Try HELP at the > prompt. I would do this from a telnet or ssh connection versus Administrator Window. It maybe easier. There are some really good posts on this topic. Try to search for them. DS.TOOLS is a menu that will do a lot of the work for you. Try it. Thanks, Kim. I will check that out! :>

We are using DataStage 7.1 on Windows servers. I am one of the DataStage Admins. We have had no training on this. I skim thru the DataStage Admin documentation, and I don't see a list of "commands" available anywhere. Is there a place where the commands are listed that can be executed in D...

Sainath.Srinivasan wrote:It will be beneficial if you have more than one processor in your system.

Yep, Windows Server with 8 processors.

I am using DataStage version 7.1. I am starting to use the InterProcess stage for the first time, and am looking for any helpful advice in its usage. I do have some general questions concerning it. For example, is this stage at all beneficial when taking 4 files and using a link collector and mergin...

Your 'better/easier way' is to upgrade to 7.5. :wink: Pretty sure that functionality doesn't come until 7.5 but it might be 7.1. :? I'm currently on 7.0.1 so can't check myself. They added a check box in the stage to have it 'also handle job errors' or something along those lines. Double-check what...

From the Developer's Guide: An exception activity can only have a single unconditional output trigger, so does not require a Triggers page. It has no input triggers. So, in other words, it is triggered by a failure in the Sequencer itself - a job cannot be reset, you reference a parameter that no l...

I have numerous Sequencer jobs, DataStage v 7.1, Windows server. The Sequencer jobs have many jobs inside of them. On each one, I have a link go one way if it works (1 or 2 return code), and another way if it fails (3 or higher return code). I saw the Exception_Handler stage, and was hoping I could ...

1.) You can schedule a sequencer and include your jobs in the sequencer 2.) You need to define the schedule user-id and pass in the DS Admin. Thanks! :> So, #1... I'm thinking we'll still have the problem with most of the users not being able to schedule a Sequencer, either. #2... cool beans. Can y...