DSXchange

@Pandeesh
If I dont use the Change Apply stage then I guess I have to use the lookup/join with the change dataset?
Also can I achieve this through SCD stage?

That's according to your requirement.

Thats why I told it in the start itself. I want to load the insert/update records only. My source and target is DB2 table.

Change apply is not need when you are dealing with tables

So only change capture can load my insert/update records ??

So in order to develop this job do I need to take both the stages ?

I know this topic(or related topics) has been discussed many times, even then I really wanted to know the experts advice. :) My requirement is simple I have the source and target both as DB2 tables, and I want to capture only insert and update records(we dont have delete records). In order to accomp...

Yeah, I guess

mohdtausifsh Since you are using rowid partitioning so the connector calculates the rowid range for each processing node and runs a SELECT statement on each node. For each node, the SELECT statement specifies the rowid range that is assigned to that node. The SELECT statements are similar to the ori...

kjaouhari
I think your records might be rejecting when u get thos warning.
Please test your data too. I got the same problem.
Do you have a reject file and whats your Array Size/Records Count at the target stage?

@HendrikB
Yes, as I told I am using TIMESTAMPs so I am using single quotes for my input parameters but still it is giving me the same error.
You didnt tell where hould I keep this query?

@Craig. I am having DB2 database. Actually I have run this procedure successfully for no input parameters . But now, due to some other requirement I have to include two input parameters(which are basically TIMESTAMPs) and it has to come from job parameters. The output parameter is a INTEGER which wi...

Thanks for your input.
Yes I am calling a DB2 procedure via stored procedure stage.
Can you tell me where I should keep this query?
Also please tell me that why you kept double quotes for some input arguments and single quotes for other?
Does it depend upon the data type of my input argument?

Hi, How/Where can I pass the job parameters as one of my input in a SP stage? My procedure has two inputs and one output. I want those inputs to come from job paramters. I have tried lot of things and searched here too but got no luck. I am getting the following error StrProc_LD_INGT,0: Error: The p...

chulett wrote:If everything works other than the 'test connection' option, that smacks of a bug to me and something you should report to your official support provider.

Thanks everyone...

I will open a PMR for the same.

Thanks

Additional comments:

db2 connector to file jobs also working fine. Only Connection Test option is not working.Showing the above error .

We are having datastage 8.1.(AIX5.3)

we have set the LIB path only.We are able to view the data also using db2 connector stage.

Thnaks.

Dear All, We have done the new setup on DR site and we are performing the db2 connector stage with native connectivity. I am getting below error while testing the connection: An exception occurred while trying to obtain the handler object: An exception occurred because no handler object was found Ki...