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.
Search found 82 matches
- Wed Dec 06, 2017 7:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date Conversion
- Replies: 3
- Views: 3507
- Sun Sep 10, 2017 5:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Populate values of next record in previous record
- Replies: 4
- Views: 4204
- Sat Sep 09, 2017 8:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Populate values of next record in previous record
- Replies: 4
- Views: 4204
Populate values of next record in previous record
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...
- Fri Mar 04, 2016 3:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Connector Warning for reading timestamp
- Replies: 8
- Views: 5861
- Fri Mar 04, 2016 6:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Connector Warning for reading timestamp
- Replies: 8
- Views: 5861
- Thu Mar 03, 2016 7:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Connector Warning for reading timestamp
- Replies: 8
- Views: 5861
DB2 Connector Warning for reading timestamp
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...
- Mon Feb 29, 2016 5:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Connector issue
- Replies: 2
- Views: 2127
DB2 Connector issue
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...
- Thu Sep 03, 2015 8:22 am
- Forum: General
- Topic: DSJS.RUNFAILED not working in custom trigger
- Replies: 9
- Views: 4868
- Thu Sep 03, 2015 7:39 am
- Forum: General
- Topic: DSJS.RUNFAILED not working in custom trigger
- Replies: 9
- Views: 4868
- Thu Sep 03, 2015 7:36 am
- Forum: General
- Topic: DSJS.RUNFAILED not working in custom trigger
- Replies: 9
- Views: 4868
- Thu Sep 03, 2015 6:37 am
- Forum: General
- Topic: DSJS.RUNFAILED not working in custom trigger
- Replies: 9
- Views: 4868
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...
- Wed Sep 02, 2015 11:14 am
- Forum: General
- Topic: DSJS.RUNFAILED not working in custom trigger
- Replies: 9
- Views: 4868
DSJS.RUNFAILED not working in custom trigger
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
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
- Tue Jun 16, 2015 7:39 am
- Forum: General
- Topic: Multi Instances not able to view in director
- Replies: 11
- Views: 4909
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 ...
- Mon Jun 15, 2015 2:15 pm
- Forum: General
- Topic: Multi Instances not able to view in director
- Replies: 11
- Views: 4909
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. ********...
- Mon Jun 15, 2015 1:43 pm
- Forum: General
- Topic: Multi Instances not able to view in director
- Replies: 11
- Views: 4909