DSXchange

I was running a job (which has run successfully before) & it aborted with the message 'Unexpected termination by Unix signal 14(SIGALRM)'.

Does anyone know what this means?

I re-ran the job this morning (no changes - just submitted it) and it ran to completion wihtout any problem.

Thanks!

I loaded a sequential data set into a db2 table. Three of the records did not load since a date field had invalid data ('**********'). I have corrected the date problem. My concern is that the job did not abort, but had a successful completion. The director did say that the job had a binary load err...

I am trying to concatenate smallInt MO,DAY & YR into a date field. The MO & DAY are 2 bytes & YR is 4. The date field will be yyyy-mm-dd format (type DATE). The code I'm using is YR:"-":MO:"-":DA This works if the MO & DA are > 9 (no leading zeros) MO = 10 DAY=15 ...

Rich - Thank you for your help & also the documentation.

Rich - I decided to try your suggestion on using the transformer to cause an abort & it seems to work. I couldn't find any documentation on the 'abort after rows' option, but I think it evaluates the constraint & if it's TRUE, the job will abort after the number of rows where the condition i...

Thank you for your suggestions. I also found that I can do it from the switch. I check for case = C (continue) but not case 'A' (abort). Then set the 'If not found' option to FAIL.
I only have one record at this point & it will be either 'C' or 'A'.

Thanks again for your help.

Is there a good way to force a job to abort? I am doing balancing where the final result has to be zero. I have a field called total_difference which is a decimal (15,2). If it's zero, I set a field called abort_sw to 'C' for continue, else I set it to spaces. Abort_sw is a 1 char field. I found tha...

Just like Sandy, I am also a penny off on some of the amounts that I sum with the aggregator. It's not the same field all the time. After I load my DB2 table & do sums with SQL, the amounts are correct. These are decimal (13,2) fields.

Does anyone have any idea what causes this.