DSXchange

Hi, I have a MQ job and it is failing in production with below error. And there is no pattern for job failure. Sometimes job runs for 2 days without failing and some days it fails 3 to 4 times in an hour. I have similiar job running against other 4 non-prod regions and they have no issues and are ru...

Thanks Craig. It worked.

Basically I want to dynamically read data from Table A.

My MQ job will be running continuously so if a record is inserted in table A, then my job should read that new record immediately in job.

Hi, I have an MQ Job which reads data from Queue and then does a LKP on table A and then writes into table B. Table A is being populated by some other system in real-time. Table A | | | MQ ------------------ LKP ------------------ Table B Question: System will put message in MQ and other system will...

Hi Andy, Actually I found a logic on dsxchange, but I have to still test it. http://www.dsxchange.com/viewtopic.php?p=425333 And the reason for putting delay is that application sends data to 2 different systems (Java and DataStage). And I depend on getting some data from Java and datastage is proce...

Hi,

I have a requirement where I am reading MQ. And after I read message, I want the job to hold the message for 30 secs before dumping into oracle table.

MQ Read -------------> Transformer -------------> Oracle table

Hi, DataStage was working fine but I mistakenly saved uvconfig file in vi editor(No change was made on the file). And then immediately no one was able to log in. So I tried re-starting dataStage after re-generating uvconfig file. And I am getting below error. Sorry, this version of DataStage server ...

i have a requirement for server job. But if there is a solution with parallel job, then i can make a parallel job also. And below is an example. It is tough to put down the requirement in words. So i will explain with an example. For example, Table 1 is the source and table 2 is reference table. For...

I found the issue.... The issue was that on one of the link in the job had Range Look up check box clicked but the key expression was missing. Same job was running fine in DataStage 8.5, but with DS 9.1 release they have tightened the rule and now it is looking for key expression if range look up ch...

Nope. Most of them are for older version of datastage.

Yeah I know.... I tried searching the web but all of them are asking to make changes to RCP. But, we have same setting on both DS version. So I dont know if that will make any thing different.

I will open a PMR with IBM today and keep you posted.

Hi,

I am getting below error....

main_program: Fatal Error: Added field has duplicate identifier(): X

The job was created in DataStage 8.5 and it was running fine. But when I moved the job to DataStage 9.1... I started getting error and the job is aborting.

Hi.....

I am trying to install fix pack-1 on my new machine. But I am getting some weird error.
Earlier I had the same fix pack installed on my 32 bit machine. But now I got a new 64 bit machine.
So do I need to download 64 bit version of fix pack-1?

The source cannot be changed to Zoned Decimal as it is a fixed length file. So I have to break down the input record. Solution: I created a table and then I do a look up on last character. And then get the correct value. And today I noticed that when I use StringToDecimal function then it issues war...

Chulett - It is an implicit conversion. I did not write any conversion function to convert from String To Decimal.

Source - VARCHAR
Target - Decimal