DSXchange

I never worked with DB2 before so I am not sure whether you are trying to store Timestamp(26) into Date (10 bytes). I might be wrong too, but if you are doing this than use Timestamp to date function. Let me know if this helped.

You should be fine doing this join in DS. I suggest you to use correct partitioning and sort data if possible in DB before it gets to DS. Test your job with less data and see how it works before running it against full set.

AND B.FULL_DATE >= "#Start_Date#")

Try putting double quotes around the parameter.

AND B.FULL_DATE >= "#Start_Date#")

Try putting double quotes around the parameter.

Hi Tanay,

If you have a solution for this please let me know, I'm also having same problem.

Thanks in advance.

Shawn

I would suggest you to look at Duke's Xml Best Practices document.

Hi All, I need your help in making a design decision. My requirement is to first query SQL Server and get ID & Code. Use this ID to do a lookup on Sybase table to get other information. Problem here is Sybase table is huge (about 300,000 records) and it's except to grow rapidly in couple of year...