DSXchange

Hi, I am using the DB2 API stage for writing a user - defined SQL that will insert some values into the table using a left outer join between two tables. But when I am doing so, I am getting an error :- "This SQL statement did not contain the same number of parameters as columns on this link. T...

Hi We're trying to execute a db2 command from within a sript while calling via the Before Subroutine ExecSh This is the error thats being trapped as a result of which the job aborts exec(): 0509-036 Cannot load program db2 because of the following errors: 0509-022 Cannot load module /usr/opt/db2_08...

ArndW wrote:Where are you doing your "select"? Are you selecting the job in the Designer while making a sequence, or in the display screen of the Director or Manager?

In the Designer of both PC's......I am unware if we could select this from Director/Manager

Hi, We are facing avery peculiar issue while using sequencers. In our team we have only one PC from which we can select jobs which have can be sequenced. from all othe PC's we can select jobs upto a particular level of hierarchy in our project. What I mean to say is that suppose we have one job lyin...

We are having the same problem today. Unfortunately, I don't have a solution for you. The only thing I can suggest is to check if you can ssh or rsh between your servers. I believe that DataStage uses one or both of these utilities as part of its communication. Right now, we cannot manually rsh or ...

Hi all We had a h/w problem as a result of which we had to reinstall our partitioned Db2 Database again. We are/were using SSH for connectivity b/w the etl server and the db2 server Now after reinstallation of partitioned db2 we are facing a problem that we are able to read from db2 in our job but a...

Hi
I am a new developer in datastage and want info on the following

1. In the sceduler if we want to restart from the point one of the stage in scheduler aborts does the "Resatrt, if required then run" solve the purpose for it and if no how to do it.