DSXchange

Dear All, I would like to handle the job not to be aborted.Is there any idea???Can we handle that kind of situation? Now I am trying to reject the records those will be rejected by database while inserting so that I can avoid the job to be aborted.But I can't capture the error message from the datab...

I got it.

Thank u so much......

ray.wurlod wrote:Include the duplicates with UNION ALL instead of UNION - should remove your objection to UNION.

Don't you have the other way like using DS statages??? Thanks, Alternatively, you may consider a full outer join. An inner join will provide only records that match, a left join will provide all records in the left table and matching records in the right table, a right join will provide all records ...

(not exactly the same record.Some fields from those records are not the same but required fields are same) Looks like you are talking about a Join (for that use user defined sql query). Please provide some more information about what do you want to do? Hi, Actually I want to extract all the data fr...

Dear All, Could u pls suggest me how to extract the data from 2 or more tables??? I have 3 tables.I want 3 fileds from table A,2 fields from table B and 1 field from table C.But I want all the data from those 3 tables(A,B,C).I mean it's not like a lookup. There is some data from A(A.id) may not be i...

I c...

Thank u so much.........

Dear All,

May I have a question please???
I am confusing that DS odbc is seperate working with our usual odbc???
If yes,how to configure the DS job to use the usual Odbc like DB2 odbc???


Thanks in advance,

Ray, Thank u so much for your help. Now,i see very clearly. : :D Thanks, It's not static in the sense of a static variable in C. It's static in the sense that it does not perform automatic space management. Dynamic hashed files do automatically grow and shrink in response to the total volume of data...

Thanks,ArndW.Here some more questions come. So,the other file types except dynamic type 30 are static??? I always use dynamic type 30.So I always use dynamic hash files??? Then when should we use the static hash files. Before this,I always thought static hash file as whenever I create the hash file ...

Dear All, I have being confused with hash files.I have been used hash files in some my jobs for performance matter.But still I don't see the static hash file.I don't know how to create static hash file.May I know what is the difference between static and dynamic hash files?Is it like in other progra...