DSXchange

Hi I designed a Job Sequence , i used seqence between two Job activity stages and i had take two links "success" & "Warning", i ran the job . Job is working Fine. But i am getting some Warning like did not finish OK, status = 'Finish with warnings' I am thinking these warning...

Thank you I am getting this error, when i am opened the sequencer job. once i click the OK or Cancel button, the running Designer window is closed immideately. I am not understand weather it is Datastage problem or my Desktop problem. The instruction at "0x7c911982" referenced memory at &q...

Hi

I am getting this error when i opend the Notification Stage.

The instruction at "0x7c911982" referenced memory at "0x00000004.The memory could not



Regards
surendro

Hi I designed a job using change capture. The design is like this DB2API----| |==ODBC | | |==Change Capture==Transformer==| DB2API----| |==ODBC==ODBC In the Transformer i put the link constraint Lnk_Capture.change_code=3 or Lnk_Capture.change_code=1 for update and insert , Lnk_Capture.change_code=2 ...

Thank you Hulett

My Target database is DB2.

Hi I have a job that is delete the records in the target table. I am deleting two column records. Table Name -- It is a Primary Key Table SRKey -- It is a index key. When i ran the job it is through warning. No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. SQ...

This issue is resolved... Array size. The input array size. The default is 50 rows that are cached before being written to the database. The array size value should be an integer greater than or equal to 1. Note: If a table that is being updated is also being used for reference lookups, the Array si...

Hi

When i am load the records using Update existing or insert new rows.

Job is finished successfully. But i am getting warning.

This update action 'update or insert' is not compatible with parameter array binding. Array Size property will be set to 1.

Hi The existing job is designed like this. Force source sequential files are club using Funel stage and insert in to target table. it is through warnings. That is why i was modifed the jobs after Funel stage i used change capture and insert the records to the target table. Sequential files -- Funel ...

Thank you Ray

I had set Preserve Partition as Clear in 2nd stage in my job.
When i validate job, it shows Validate OK

Hi When i design a job my source Advanced Tab details are Excutable Mode: default(sequential) Combinability Mode: Auto Preserve partition: Default(Propagate) ---------------------------------------------- Next Stage Advanced Tab details are Excutable Mode: default(Parallel) Combinability Mode: Auto ...

If i used Truncate we are loosing monthly updated purchase order data.
that is why he is not interested for Truncate and load.

If i used Truncate we are loosing monthly updated purchase order data.
that is why he is not interested for Truncate and load.

Thank you every one.

I am thinking to redesign job using change capture.

Insert / Update. with this method no need to delete or truncate the records.

please drop your suggestions.

Hi I am reading source data and write in to target table using DB2 API stage. While writing data in to target table , deleting existing records from target table. It is a daily process. When i ask my lead why do not we truncate and load the data at traget table. They are not accepting. The existing ...