DSXchange

Hi, As you said I made a join and the join type as leftouterjoin. So I am getting all the rows from input, and in the transformer stage I had written the following code. If (DSLink45.LINK_TYPE_CODE = "ERPFO" Or DSLink45.LINK_TYPE_CODE = "HSPFO") Then DSLink45.LINK_TYPE_CODE = &qu...

Hi Maveric, If I understand correctly, i think the one you suggested will not work for me. because, I need to get all the rows from PROFOTHER_FACT table and I need to update inp_ind field with "Y" if PROFOTHER_FACT.PROFOTHER_SERVICE_ID = STAY_LINK_FACT.RELATED_SERVICE_ID. and the rest. Tha...

Yes, I created a column by using column generator stage. And I placed a Trasformer stage after column generator. Here I need to compare fields from two tables one from PROFOTHER_FACT with column name as PROFOTHER_SERVICE_ID and STAY_LINK_FACT with column name as RELATED_SERVICE_ID , If both are equa...

Hi,
I am having a job in which I need to create a new column and update this with "y" or "N" based on the result of previous join. Can anybody tell how to do this? what stages to be used etc.

Thanks
Kavuri

Hi ray,
I found some information in advanced developers guide. Ok I will go ahead with it and If at all I found any difficulty I will post again.

Thanks
Kavuri

Hi ray,
I am keep on trials with C routine, at the same time I would like to know how can I make a build stage? If you can give me some hint so that I can do it or otherwise if you have some link for this material please send me I appreciate it.

Thanks
Kavuri

Hi Ray, can you tell me more specific where to write and how to compile and incorporate it to use with in Transformer stage. I think, here I need to pass a bigint value to the routine as an argument. is this somewhere in the command prompt I need to write the routine? or Can I write somewhere in dat...

Hi, I am getting some data from a lookupstage, Now I need to join this data with data coming from a DB2 table. I am using Join stage. My problem here is the column on which I need to join is named differently in DB2 table and in the lookupstage. So I was unable to provide the key name. Can you give ...

Hi, I am having some problem in Transformer stage. I am having a 64 bit integer is there in my input side. I need to derive a string from that. But the string should have a max length is 12 characters. Now what I need to do is, Plan : 1. Convert bigint into 64bit string. 2. Take 10 6-bit strings and...

Thanks Shamshad and ArndW, I made some more modifications to your ideas. Just I had taken a simple DB2/ODB enterprise stage there itself I put the query what Shamshad had given, passed it to a copy stage and passed to the target DB2 table, by using append mode and method write. This is working fine ...

Hi ArndW,

Its OK. But can you give some code hint that I need to compare rows from both tables for the same column and add any rows which are not available in the left table from the roght table.

Thanks
Kavuri

I was able to clear the errors, but still I am getting warnings. But I know that the logic what I had is wrong, because column in table "ABC" is primary key so I cannot insert duplicates, but in my present design I haven't mentioned regarding that anywhere. Do I need to insert any other st...

I tried by using join stage, but I am getting folowing error. DB2_UDB_Enterprise_3,0: Error Idx = 12; DB2 Driver Embedded SQL message: SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, uniq...

Hi, In my small job what I am having is 2 tables are there let me say "ABC" as first one and "DEF" as the second one. Let me say "ABC" main table or left table. I am having a column in both the tables with the same name. I need to find data for that particular column in...

It is there in PATH settings. "../DataStage/DSEngine/bin" is located in PATH.

Thanks
Kavuri