DSXchange

Thanks to all.
Hi Ray,

The Timestamp datatype represents the number of characters.

Actully data type that field in the database is DATE(10).

Regards,
Reddy.

Hi,

Actually The scenario is

DRS stage-->Transformer-> DRS

I am changing filed date(10) to Timestamp(10) in the Transformer stage.

Regards,
Reddy.

Hi,

While i am running the job I am getting following warnings.

TRNAddSubRecVal: [IBM][CLI Driver][DB2] SQL0181N The string representation of a datetime value is out of range. SQLSTATE=22007.

Please provide how to resolve the above one.

Advanced thanks.

Regards,
PReddy.

Thanks, I got it.

Regards,
Reddy.

Hi, I am using the following scenario DRS--->Trans------>DRS In the job i have changed all Date fileds to Timestamp. while i am running it has been giving the following warnings......... Serv_hr89_epm89_job_jr_ins_after_upd..TRNAddSubRecVal: [IBM][CLI Driver] CLI0114E Datetime field overflow. SQLSTA...

Hi Ray,

Thanks for your reply.Please tell me how to resolve those warnings.

Regards,
MPR.

Hi, When i was running the job it ran fine.But i has given the following Warnings.......please tell me what is problem. brchdm_file,0: Import consumed only 7bytes of the record's 9 bytes (no further warnings will be generated from this partition) NullHandling_AppSumm: Input dataset 0 has a partition...

Thanks for reply.
I have used the mail routine in after job routine in job.Its working fine.can we use that routine in sequencer instead of job or we can use anything?

Regards,
Reddy.

Hi,

What is difference calling the email routine in after-job-routine in job and creating routine activity in Sequencer?

Is there any differnece? Could please tell me?

Thanks in advance.

Reagrds,
Reddy.

Hi,

Thanks to all.I resolved it.
we can use Either two ways.

DSJobStartDate : " 00:00:00"

(OR)

ICONV(DSJobStartDate,"D-YMD")

Regards,
Reddy.

I already mentioned,ok no problem..
here i am sending the warning........

Serv_hr89_epm89_dep_ben_eff_ins_after_upd..TRNAddSubRecVal: [IBM][CLI Driver] CLI0114E Datetime field overflow. SQLSTATE=22008

Regards,
Reddy.

I changed to Timestamp.Actual the Datatype in DB2 is DATE.Even i tried using DSJOBSTARTDATE also,not work out.

Hi,

Target database is DB2(DRS stage).

I have changed to date to timestap datatype and i have given the DSJOBSTARTTIMESTAP as default value.But it is not working.

regards,
Reddy.

Hi Ajit,

Thanks for your reply.But i am not getting solution.In source generated query for Timestamp it has used as
TO_CHAR(source fieldname, 'YYYY-MM-DD HH24:MI:SS').
But in this case how to keep the conversion for that default DSJOBTIMESTAMP value.

Regards,
Reddy.

Hi, I have been using the following scenario. DRS stage(source)---->Trans Stage---->DRS stage(target) In Target table i have one filed as Maritus_DT and data type is Date.I have changed that filed data type to Timestamp.But that field not exists in the Source.so i have given the default value as &qu...