DSXchange

Hi All,

I have a column in DB which is integer and has date values as yymmdd and ymmdd, I need to compare whether it is valid date format in datastage.

Craig,

I am not getting you, please explain.

Hello all, I have 5 records as below Id Date End date 1234 2017-08-09 2017-08-10 1234 2017-08-10 2017-08-11 1234 2017-08-11 2017-08-12 1234 2017-08-12 2017-08-13 1234 2017-08-13 2099-12-31 I need to pick next record date value and populate in end date of old record as above, please help on how to im...

I tried with 22,10 and 12,10 also but still I am getting error.

Yes Ray precision and scale are set to 12 and 10 which are defined as per table definition

Hi, I am using DB2 Connector to read data from DB2 table. there is column with timestamp (12,10) in table when I am reading this field using DB2 Connector stage I am getting below error. When reading database column DATETIME(fraction=10) into column DATETIME(fraction=0), truncation, loss of precisio...

Hi, I am using DB2 Connector stage to update and insert records. I am getting The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation. But same id is working fine when I use API stage, I am able to update and insert records usi...

Yes Agreed, But i want both failed and warning in second link so i am using custom and providing RUNFAILED and RUNWARN.

I have 2 output links both have custom trigger as below

1) Jb_Step01.$JobStatus = DSJS.RUNOK OR Jb_Step01.$JobStatus = DSJS.RUNWARN

2) Jb_Step01.$JobStatus <> DSJS.RUNOK

Jb_Step01.$JobStatus <> DSJS.RUNOK

Thanks for response. Below are the details present in Director with exit status JOB1 has finished, status = 3 (Aborted) JOB1 did not finish OK, status = 'Aborted' Controller problem: Unhandled abort encountered in job Seq S1 JobControl (@Coordinator): Summary of sequence run Sequence started (checkp...

Hi All,

I have job (J1) which will fail and next job J2 should be triggered which is present in seqeunce. I have custom trigger as below

Activity name.$JobStatus = DSJS.RUNFAILED OR Activity name.$JobStatus = DSJS.RUNWARN,

But Job 2 is not triggered and it is not saying any error. Please help

Hi Ray, I found one more option, in clear log in director where i can set to Auto Purge to older than a day or 2, I tested this and it worked fine. I have couple of questions on this 1) Does this option will be retained if i compile this job 2) If i migrate this job into other env, will this option ...

Hi Paul, I found below info from IBM website, Does below fix will resolve my issue. Problem summary **************************************************************** USERS AFFECTED: Customers using Auto-Purging that require failed jobs to not be purged so that the status can be investigated. ********...

Hi Paul,

But i see issue when i running this in production, If i have monthly or weekly jobs then i cannot see logs for other jobs if this is set to 2 or 3 days.