DSXchange

I have a job which extracts IDOCS and load into DAtasets. the job is in production from last 3 yrs, but from friday getting error. job is running for more than 5-6 hrs. and failing with below error:- Operator terminated abnormally: received signal SIGSEGV [processmgr/rtpexecutil.C:199] I used $APT_D...

Can you please elaborate it more

ArndW wrote:It is trivial code, you create your Before-Job or After-Job routine, and within the routine do something like:

Code: Select all

   JobHandle = DSAttachJob('MyJob',DSJ.ERRFATAL)
   IF NOT(JobHan ...[/quote]

hi, I have one reuirement that I have one Table which contains information about all job LOGS. Jobnam, Status, startdate, enddate I want to develop reusable component in such a way that, In the starting of the job I will call that shared container. It will insert one row for that Job like:- Job1,Sta...

I tried to load that column as varchar, Now data is getting loaded and I am not getting any warnings. But I want to load it in datetime dattype only.

Column Type in Target SQL server is Datetime and SOURCe Datatype is DB2 - Timestamp

After Removing .0 also I am getting the same error. Do I need to change the lenght of this column in Transformer Output Stream?

Hi Sura, First I took one stage variable STG1 and dump the Timestamp column into it. like below left(timestamp_column,19) --> stg1 and the in transformer output link, In the output Timestamp column I did:- StringToTimestamp(STG1,"%yyyy-%mm-%dd %hh:%nn:%ss.0") --> Output_timestamp_column Ge...

I am trying to Load data From DB2 to SQL Server, I am getting datetime overflow error. I tried to just load timestamp without microseconds but still getting the same error. Please help! The job is in production and I am getting the error.

Thanks, I will try this

Can you please just give eample for fork join. How to design it?

hi, My input is (db2 tables after joins) MATERIAL_No PLANT VENDOR_CD FLAG 1009417 FR02 40010458 N 1009417 FR02 40020110 Y 1009417 FR02 40002482 N I need output like- For same MaterialNumber and same plant Where Flag =y, I want to populate its respective Vendor code in FIX_VENDOR column for all rows ...