Search found 41 matches
- Sat Oct 31, 2009 8:23 am
- Forum: Data Integration
- Topic: insert into new row with max of effdate
- Replies: 1
- Views: 18602
insert into new row with max of effdate
Suppose an employee has 3 Effective dated rows in xx table JOB.EFFDATEs: 1/1/2007 1/1/2008 1/1/2009 And the last_sal_change_date is 5/1/2008. So in this case the last_sal_change_date does not match to any of the JOB.EFFDT. So we need to fetch the Max JOB.EFFDT that is <= last_sal_change_date and in ...
- Wed Sep 30, 2009 6:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: range between values
- Replies: 3
- Views: 2517
- Fri Aug 28, 2009 1:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job Abort
- Replies: 2
- Views: 2584
Job Abort
While Running a sequence which runs every one hour, One of the Job in the sequence is getting aborted with the following error message: Controller Problem:Error calling DSRunJob(Job1), code =-99(...) ..JobControl (fatal error from @Coordinator): Sequence job will abort due to unrecoverable errors Pl...
- Wed Jul 22, 2009 12:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to do the Scheduling for every 1 hour
- Replies: 6
- Views: 3336
How to do the Scheduling for every 1 hour
Hi,
I want to schedule the job for every one hour is it possible to DS Dirctor.
please help on this issue.
Thanks
I want to schedule the job for every one hour is it possible to DS Dirctor.
please help on this issue.
Thanks
- Wed Jul 08, 2009 7:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Data conversion problem
- Replies: 1
- Views: 2174
- Mon Jul 06, 2009 11:59 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: update the target table with max date
- Replies: 5
- Views: 3632
- Tue May 26, 2009 5:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job is locked
- Replies: 9
- Views: 8950
Job is locked
i have complex job using more than 20 stages, when i ran the job and it is locked .after that i have try to kill the job but still its showing job is accessed by another user my i know root cause of this broblem.plz help
- Mon May 25, 2009 7:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: date format issue
- Replies: 1
- Views: 1981
date format issue
i am getting 2 source colums JOB_EFFECTIVE_DATE,EMP_STATUS_EFFECTIVE_DATE(timestamp) from sequential file. format like 2007-08-17 00:00:00 so i need to compare the dates if JOB_EFFECTIVE_DATE >=EMP_STATUS_EFFECTIVE_DATE then JOB_EFFECTIVE_DATE else EMP_STATUS_EFFECTIVE_DATE my target is oracle times...
- Tue Dec 16, 2008 7:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date and time setup for sequential file stageYYYYMMDDHH24
- Replies: 4
- Views: 2737
Re: Date and time setup for sequential file stageYYYYMMDDHH2
i have done same requiremnt by passing the parameters throw shell scripts....i
- Fri Nov 14, 2008 5:37 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: i want to add a date column with 180 days
- Replies: 3
- Views: 2862
thanks Romy ..........
Romy wrote:Hi,
First convert the input date column to internal date using the iconv function. It will return a number. Then add 180 to this internal date and using oconv function convert it to the external date format.
Hope this will help you.
Thanks.
Romy
- Fri Nov 14, 2008 1:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: i want to add a date column with 180 days
- Replies: 3
- Views: 2862
i want to add a date column with 180 days
I have a date column in source table, I am using 7.5 A server jobs - i want to add 180 days to the source date.
Please advise me how to use it for my requirement.
Please advise me how to use it for my requirement.
- Tue Aug 05, 2008 3:06 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: When we login the DataStage Director for checking job status
- Replies: 3
- Views: 2479
When we login the DataStage Director for checking job status
When we login the DataStage Director for checking the job status, we got the following error message. Also, we got the same message when try to open the project with the DataStage Designer. project psb_prod is not setup for data stage use cant open file DSR_JOBS please help on this issue.thanks
- Sun May 18, 2008 11:58 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date Conversion problem
- Replies: 10
- Views: 4237
- Fri May 16, 2008 6:41 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date Conversion problem
- Replies: 10
- Views: 4237
- Fri May 16, 2008 6:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date Conversion problem
- Replies: 10
- Views: 4237