DSXchange

I have a user defined SQL which I used in the db2 stage previously .
So I believe I can use the same SQL in reference SQL in odbc stage .
I haven't yet been with my system . I ll check and update if I face any issues .

Thanks ray.
But I am not able to understand why there are 2 SQL in odbc stage .
However we are having a source link or the transformer from db2 stage.
Then why we nee again source SQL in odbc stage ?
Is that optional ?

Is retuning multiple rows from db2 enterprise stage possible in server job ? By default I am getting multiple rows returned from reference warning . Do you want me to use odbc stage for extracting from db2? I just went through the odbc stage and I don't understands reference SQL and source SQL . So ...

Obviously I cannot use hashed files since there are 2 records with same key1 from reference link. .even if I use key1,key2 both as keys I want to check equality for first key and non equality for the second key2. If I use database stages directly , I am getting multiple rows returned from reference ...

Hi, I have 2 links from 2 db2 tables with data like below source: --------- key1,key2,val1,val2 ----------------------- 123,121,120,128 123,120,120,123 123,112,119,100 Reference: ------------- key1,key2,val1,val2 ----------------------- 123,120,120,123 123,112,119,100 The logic is : source.key1=Ref....

Yes. You can read by dumping, can delete , can truncate the contents of the dataset. But you can't create a new dataset from existing another dataset

That's highly impossible in unix

But i believe, there may not be any space, since his data is exactly 12 character long 000012345.00

Ask your client why MD5 algorithm and try to educate them .
Don't accept whatever client want you to do

Have you checked all the existing Posts regarding FIFO lock?

Thanks

Thanks Craig

Cool!!

Difference In terms of performance?

Hi, Can some one comment on the difference between the below 2 designs ? srctable-------->transformer------>tgtfile | | reftable srctable-------->transformer------>tgtfile | Hashed file | reftable Thanks

It will become some more complex that if the number of a are more in the string and only one pattern is matching .
So we nee to recursively apply for all the occurrence of a .
Thanks for your help all

Yes kandy. Thats the way I was also thinking about .
But when we have the pattern like %a_b%, I don't know how to match all the possible patterns .