DSXchange

Hello, I am having a problem checking for Nulls in a transformer stage using Datastage 8.1 I have a field called FieldOne that comes in from the source. I have a stage variable (svRejFieldOne) defined to create a flag if FieldOne is Not Null AND the length is not 6 or 7: If IsNotNull(inFromSrc.Field...

You can also try exporting the job, deleting it from Designer then re-importing.

ray.wurlod wrote:The IBM website contains up to date information about operating system compatibility. ...

IBM website only has minimum requirements. It does not containt information about compatibility with service packs.

We are running Datastage server 7.5.1.A on Windows 2003 R1 SP1. We would like to know:

Is Datastage Server 7.5.1.A compatible with Windows server 2003 R1 Service Pack 2?

Error calling subroutine: DSR_EXECJOB (Action=5); check DataStage is set up correctly in project AHAKORPROD (Subroutine failed to complete successfully (30107)) I was having a similar error and it seemed the job was corrupted. I made a copy of the job, made sure it worked then deleted the old one a...

I am looking for some ideas/suggestions concerning an issue with being notified if the Daily ETL job in Datastage has a problem. We have used the notification activity stages to send an email when the job fails, and it works great. But, in the past we have had a problem where the server running data...

Hi, I am having a very frustrating problem: We have a sequence job that runs various server jobs and other sequence jobs. This job is set up to give an email notification if it fails. Sometimes the job will not fail but not complete. For example mainSequencejob runs various server jobs then runs seq...

Can you look at JOB.1021461082.DT.1448842784.TRANS5 in RT_BP2814 around line 558, in particular you are looking for anything that looks like a "close" or end of loop. Also look for the name of the st ... I had other jobs in the sequence that failed with the same error. I looked in each JO...

After the job aborts, reset it using Director. Does a message "from previous run" appear in the job log? If so, what does it say? If nothing has changed in the system (and you are 100% certain of ... 100% sure? The Infrastructure people say nothing has changed. Should I believe them? I do...

What does the Transformer do? In particular does it invoke any routines? Have you re-compiled the job? And, most importantly, what has changed on the system since the job ran successfully? ... The transformer does some look-ups and some transformation (multiplying columns etc). I would think that i...

I have a job that has been running successfully for over a year. Suddenly this week it fails everytime it is run. The job log shows 1 warning but no errors yet the job status is aborted. It also seems to stop after about the same amount of records are processed. The warning says: Attempting to Clean...

Has anyone ever used CVS version control system with Datastage server edition?

We have found a work around for this issue. After trying difference test we narrowed the problem to the user defined SQL statement. It was: Select ..... Where Date1 > LastRunDate Union Select..... Where Date2 > LastRunDate If we ran the select before the "UNION" it complteed in 16 seconds....

Nothing wrong with either size, though they do seem small. Had to hit the road, but yes the next suggestion is to pursue the 'split the jobs' suggestion and see if that changes the behaviour. Land the file in the first job to a flat file and then load from there. As suggested I split the job into 2...

the next suggestion is to pursue the 'split the jobs' suggestion and see if that changes the behaviour. Land the file in the first job to a flat file and then load from there. I split the job into 2 parts part one pulls from the AS/400 and writes to a sequential file. The second job pulls from the ...