DSXchange

I have a problem to extract XMLTYPE data from Oracle 9i to text file, using Server job. the length of this field is 400 I get the error said "internal error code, arguments:[], [], [], [], []' I did go back to the old post in this form but none of the post can help me to solve this problem. I'd...

Could someone show me how to convert Char 20 to Bigint using
Transform and Modify
Thanks a lot

Can someone please post all the convertion functions that we can use in Modify stage please.
Thanks

If I try the code on 7.1 then it works without warning. but Try on version 7.5 then we get the error
Warning:--Input_file,0: Conversion error calling conversion routine timestamp_from_string data may have been lost
do you know why? thanks

If the input is
Char 14 (20060911150001) but it's represent of GMT time.
How do I convert it to Central time? at this point I don't care about Daylight Savings.

What I did is I take I convert to (StringToTimeStamp - 5) but it didn't work.

Please help.
Thanks

ArndW wrote:tini - I used a fixed length CHAR instead of VarChar and the message went away. Or just deprecate the warning message in the log. ...

I tried this way too but the warning still there

ok, I don't want use transform,
but I still want to extract ABCDFGFDR123 only. Can I do it in Modify state?

can I do this in modify state?
If I can then how is the code?

I try to learn the modify state.
thanks

So what should I do?
I even convert the varchar 15 to char 15
and substring 14 but I still have same warning?
what is going on?

tini - did you use 13 instead of 14 as the string end position? How did you declare this new column in your metadata? Somewhere you have specified this as unbounded, which is where the warning is comi ... the input column is varchar 15 and I declared the new column as char 14. I tried targetfield:s...

targetfield:string[14]=substring[0,14](sourcefield) or targetfield:nullable string[14]=substring[0,14](sourcefield) ... I tried the code but I still have same error msg. Conversion; from source type "string[max=15]" to result type "string[14]": Taking substring of variable-lengt...

targetfield:string[14]=substring[0,14](sourcefield) or targetfield:nullable string[14]=substring[0,14](sourcefield) ... I tried the code but I still have same error msg. Conversion; from source type "string[max=15]" to result type "string[14]": Taking substring of variable-lengt...

I want to use the modify state to convert varchar 15 to char 14 and convert char 14 to timestampe But I got warning when convert varchar 15 to 14. Here is the warning Conversion; from source type "string[max=15]" to result type "string": Taking substring of variable-length source...

Thanks ray.wurload.
Sorry Iam asking so much

Thank you for all your help but I really don't get it. :oops: :oops: :oops: so I should take GMT - 6 right? and then how do I handle Daylight saving time? like Chulett said? Hi, ray.wurlod. What do you mean by GMT +09:30 (which is actually correct at the moment).? Could you explain more please :( :(...