DSXchange

Cool... thanks guys

Hello friends, We have DataStage 7.5.x installed on Linux server. All these days we were using the following driver (as defined in .odbc.ini file) to connect to Oracle 9i database 'Driver=/opt/Ascential/DataStage/branded_odbc/lib/VMor820.so' Recently we upgraded our database to 10g. Do we need to ch...

Great... thanks guys
I will inform the Infrastructure team that we don't need any patches to be applied to the MQ plug-in for Daylight Saving Time

Hello friends, We have DataStage 7.5.x installed on Linux along with Websphere MQ plug-in. I got an email from IBM about the new Daylight Saving Time starting next month As per the IBM website there is no need to patch up DataStage application as it derives the date from the OS I am a little confuse...

Craig, The sequence is in another schema but a synonym has been defined. I have defined 2 columns in the stage and double checked the sequence name I could see the insert statement in the logs (DataStage Director). The following are the statements from the logs 1) Insert into Table123(A,B,C) VALUES ...

friends, I am getting the error in the 'Transformer' stage. Also, I have double checked the table name and the permissions and everything looks fine. I am using the sequence in 'User Define Sql' portion so that the stage can use the sequence to insert records to the table. Whats interesting is even ...

Hello friends, I have a unique problem. I have a job which transfers data from a table in db A to a table in db B . While populating the target table the job gets the maximum of primary key and then appends 1 to it for every input record I was trying to change the job to use an Oracle sequence inste...

I have cleared the file and also modified the job settings to abort after encountering certain number (10) of warnings

Yamini

Ray,

The start time of the sequence is 01:34PM and that of the job is 1:39PM

Kumar,
Same thing happens when I trigger the job manually. The sequence triggers only one job

Yamini

Ray, The following is the information from the log Sequence log: Starting Job MMI002PSeq. $PR_DSN = XXXXXXX $PR_USERID = XXXXXXXX $PR_PASSWORD = ******** $MM_DSN_ORA = XXXXXX [$PROJDEF] $MM_DSN = XXXXXX [$PROJDEF] $MM_USERID = [$PROJDEF] $MM_PASSWORD = [$PROJDEF] $NLS_LANG = AMERICAN_AMERICA.AL32UTF...

Ray, We use Espresso to trigger our jobs (about 100.) All jobs run without any issues except the one in question. Job A is triggered sequentially by three different sequences passing different parameters When I check Director logs there is a difference of atleast 5 mins between Sequence and the actu...

Hello friends, We have a unique problem. We have a job A which is triggered by seqA and we use a triggering tool to trigger all our jobs The problem is, job A is not getting triggered immediatley after the tool triggers seqA job. Somehow job A is waiting for few minutes before starting Did anyone no...

I have been using ODBC to connect to SQL Sever for a year now and did not run into any kind of issues

Craig,

I was mistaken. I thought that passwords would be displayed in clear in the scheduling tool
Anyway, I have encrypted all the passwords in environment variables

Thanks
Yamini

Thanks for the info Ray
One more question: How can I mask the DataStage userid who is running the job

Thanks
Yamini