DSXchange

This query is really a good one
Did any one got some work around ..if so plz let us know


Thanks
Hameed

Can U Explain a bit more

The following code given the solution
It's working

Oconv(Iconv(Arg1, "D2/") - Oconv(Iconv(Arg1, "D2/"), "DD"),"D/DMY")

Thanks to every one

Regards

Hameed

Hello All

Is there any function in DS sever edition to get last date of the prior month .

I have searched in forum but unable to find specfic solutuion

Thanks In Advance

try to see the results in database ...if it is ok in database ..then i don't think it's an issue ...if it is ok in DB ....In DS increase the column the width(dragging the width ) where u view the data


----
Hameed

Where you are viewing the data ? in DS or in Database?

Try to remove any spaces while doing concating any strings

Or

It might be from extra size of the field


-----
Hameed

Hi Anupam

Can You explain agai wt u r trying with varaibles V1,V2


Thanks

I hope most of the DS users have the same frustrating experience with modify stage

IBM should atleast come up with some documentation for the Modify stage

drop UV,ET,Log Tables first and if sill not working then release the mload

I hope it will work

kamaldeep.kaur wrote:JOb is getting aborted due to failed in multiload process.
It is saying that failure during execution of operator logic

Hello Andrw Iam getting the date value in Varchar format i have converted it in to Date format YYYY-MM-DD Using string_to_date function i have put it in to staging varaible the Field name is DT in Transformer im Using DateFromDaysSince(%number%,[%"yyyy-mm-dd"%]) im Substituting the the val...

Hello Ray

I can't see your message completely

can you please share your knowledge by giving an example to remove trailing spaces

Thanks in Advance

Still waiting for reply

Can any one come uo with Answer



Thanks

Hello All Im trying to Trim a Varchar type field in Modify Stage with the following specification M_No = string_trim[""](M_No) here my M_No is Varchar type field but it is throwing the error msg at Run time main_program: Error parsing modify adapter: Error in binding: Parsing parameters &q...

Hello AndrW

im unable to see your reply completely

can you please share me your knowledge for this time

Thanks