DSXchange

Hi ,., Can someone help me how can I get rid of a space that is present in a char field..??? I used the conversion: if trim(DSLink3.SWLNID) = '' then @NULL else trim(DSLink3.SWLNID) But the problem is that the field is not nullable..so when it finds a '' it tries to put Null there and that is not ac...

Hi ,
I have tried using :
DateGenericToTimeStamp(SourceLink)[1,8]
but i get the error message as :
"nput value not long enough for date format"

the input value is actually the julian date : 94070...
can someone help ..
thanks,

Thanks Bryan,,
Let me try if this thing works,,
Thanks..

Hi,,
Can someone help me by telling, how can we convert julian dates to regular dates..
Thanks in advance..

Hi all,, I am loading data from an oracle table to another oracle table... For date , i am using the derivation as: If Trim(DSLink21.WORK_ORDER_CRE_DT) = '' Then @NULL Else oconv(Iconv(DSLink21.WORK_ORDER_CRE_DT,"D"),"D-YMD[4,2,2]") : " " : " " It gives me the...

Hi,
I am trying to load data from oracle table to another oracle table and I am getting an error " OCI has fetched truncated data" Why is that so??
can somebody help..
Thanks...