DSXchange

Hi,
When you load NZ tables with Load Method = ET, then it creates External Tables which you have to clean manually. Please use Load Method - nzload and you will solve the issue.
M.

Have you tried single quotes as '2012-01-31' ?

Good. But how will you control the data partitioning? The data will go on various nodes??

Please use URL/File path instead of XML Document in Input tab - XML Source. You are using ls command in external stage and giving the file path to your xml file... so you have to provide the file path to your sample.xml And.. also check your output tab -> transformation setting: if you have included...

Hi Ernie, Criag and Sura,
Thanks a lot for your replies. I am going to open a pmr today. It seems that I can view the whole message (formatted correctly) in DS Director Log but when DS Writes the RejectQ, its messing and missing the error log.
Thanks again.
Mobashshar

Hi Sura,
What do you mean? Please elaborate.
Thanks

DS Realtime Gurus.....
Please help

One thing I missed to mention.. DTS is writing message of length 615 only even after I increased the size of Q to 1 mb.

Why not move the data to WorkQ in source? It is required by DTS. Also you can choose the option to use a RejectQ, so the data will be cleared from WorkQ and written to rejectQ

Hi, I am using DTS Stage to Insert/Delete in DB2. All the settings are correct in DTS such as Reject Failing Units = Yes and Prepend Rejects = Yes. When the row is rejected because of SQL error in DB2 like -803, the the DTS is not writing the full message in RejectQ. Its truncating the SQL error mes...

Hi, One option I can think of is as follows: Make sure the input field are defined as Varchar. In Transformer create a extra column as flagcol for each input column. So it will be like flagcol1, flagcol2,.... etc. In transformer use this logic to set the flag flagcol1 = IF (Len(trimleadingtrailing(l...

Or..
You can use Before Job Subroutine and use SED or AWK to replace the | with |"

except

just make sure to hash partition and sort DATE field also with personnumber. Time field will be sort only.

rest is looking fine

Hi Craig, As far as I know.. you can use the link ordering in parallel transformer but it will not give you desired result.. During my previous project I had to redesign the job by splitting it into Upsert and Delete jobs because after using link ordering in transformer stage.. the delete was not ha...

Sure.. Then what you do is strip out Date and Time from your input timestamp field using TimestampToDate and TimestampToTime function. Now you will have three fields as personnumber, date and time.. Now use Remove Duplicate Stage and keep the last row and SORT and PARTITION on PERSONNUMBER and DATE ...