DSXchange

Hi,

Using the Routine activity u can get status with full details of the job information.

Reddy.

Hi Suresh,

I am using DRS stage, How to do i this stage.Could you please explain it clearly.

Regards,
Reddy.

Thanks for your reply.I want to do permenent fix.

Is there any solution to load the records from 3001 onwards.
As Chuck Reid said we can do start from the begining but i want to start where the job failed.

Regards,
Reddy.

Hi, I have 4 jobs in a sequencer.While it was running the third job has been aborted.when it was aborted it has been loaded the records 3000 records into target.I resolved that job and again i restarted the sequencer.I want to load the record number 3001 onwards not from starting.I enabled the check...

Once I changed Date to Timestamp now its working in both File and DRS stage also.I want to know is there other way without changing the Date to Timestamp.

Regards,
REDDY.

Thanks to all for reply.

Actually i am using DB2 database and the source is DRS stage and Target also DRS.I changed Date to Timestamp its working fine.
I checked Sequential file its not loading in that also.
Is there other way to load the load without changing to Timestamp.

Regards,
Reddy.

Hi,

When i am trying with DB2 satge its working properly.But when i am trying with DRS stage its not loading Date values into Target.

Reagrds,
Reddy.

Hi, My Source is DRS stage and Target also same.But data is not peoperly loaded into target. My source having Date filed and its having data also.After the run the job the data in Date field is not loading into target.Its showing the empty values.How to solve this one.Please help on this. Regards, R...

Thanks for the reply

Hi, When i am compiling simple sequencer it has been giving the following compilation error. <JobSeqGenError> <Code>2017</Code> <Desc>XML parser error on input line 0: source='', reason='The system cannot locate the resource specified. '</Desc> <LineNum>0</LineNum> <Line></Line> <Ref></Ref> <Version...

Could you please tell what option i have to select in the target DB2 stage.

Regards,
Reddy.

Hi Ray,

when i am trying to use two DB2 stages as Target, one for delete and for Insert it has been giving the Deadlock error.

Reddy.

Hi, Thanks for immediate reply. The scenario is In the constraints part of the Transform stage I mentined as If A_ACT='A' or 'U' then it should be Insert in the Target and If A_ACT='D' or 'B' it should be Delete in the Target Means if source side record Inserts or update it should be insert and if s...

Hi,

How to Insert and Delete the rows in the same Table within a single job.
Please clarify the issue.

For example let assume SRC as source table and TRG as Target Table. I want to Insert and Delete in the TRG table according the SRC table changes.

Advanced Thanks,

Reddy.

Hi,

How to Insert and Delete the rows in the same Table within a single job.
Please clarify the issue.

For example let assume SRC as source table and TRG as Target Table. I want to Insert and Delete in the TRG table according the SRC table changes.

Advanced Thanks,

Reddy.