DSXchange

seshikumar

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 ...

seshikumar

hi Kumar,

Thanks for your response.

The tables are not same database.

seshikumar

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...

seshikumar

Hi,

I want to schedule the job for every one hour is it possible to DS Dirctor.

please help on this issue.

Thanks

seshikumar

Thanks for your quick response. its work.

seshikumar

thanks for your quick response.

i got solution.

seshikumar

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

seshikumar

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...

seshikumar

i have done same requiremnt by passing the parameters throw shell scripts....i

seshikumar

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

seshikumar

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.

seshikumar

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

seshikumar

Hi Sachin1,

thanks for your help.

its working fine.

seshikumar

hi Sachin1,

i have tried like this but i am not geting...........

Oconv(Iconv(DSLink22.ATS270_CARD_EXPIRY,"D2 MY"),"D-DMY[2,A3,4]")

plz help ...........

seshikumar

hi Sachin1,

i have tried like this but i am not geting...........

Oconv(Iconv(DSLink22.ATS270_CARD_EXPIRY,"D2 MY"),"D-DMY[2,A3,4]")

plz help ...........

DSXchange

Search found 41 matches

insert into new row with max of effdate

Job Abort

How to do the Scheduling for every 1 hour

Job is locked

date format issue

Re: Date and time setup for sequential file stageYYYYMMDDHH2

thanks Romy ..........

i want to add a date column with 180 days

When we login the DataStage Director for checking job status