DSXchange

Not sure Arnd....

i am getting the result with in the service as "2008-12-15T06:00:00.000Z" I have defined the WISD output datatype as 25,5

Somebody plz help me in resolving this issue...

I didnt make any conversion and tried but i gave me the same result...

I tried "TimestamptoString(DSLink12.usg_begin_dt, "%yyyy-%mm-%dd %hh-%nn-%ss.5")" ...when i try to a flat file it worked but with in a service it didnt....

I am not sure how to solve this problem

my target is a webservice...Let me check what happens if i declare it as vchar thanks

Thanks a lot for the information Chulett .

My input field is timestamp field - "12/15/2008 10:11:12 AM" and my target is timestamp .

Can you please tell me how to resolve this issue

Hi Gurus, I have timestamp field coming from informix database (12/15/2008 10:11:12 AM) and when i am using the data type for the target as Timestamp i am getting "2008-12-15T16:11:12.000Z" Not sure why i am getting this junk values "T" and "Z"...can anyone help me out....

thanks for you reply.....so when you mean create table definition...all that i need is to import the table definitions of both the tables into the stage right?

Hi , I am new to datastage.....Just a small or may be foolish question... Can we use a regular SQL statement in ODBC connector stage...When i mean regular SQl.....like if i am getting 3 fields form tabel A and 6 fields form table B....how to import the table definitions. Or should i just join stage ...

dats funny....any ways thanks for your help..mostly ray and ArnldW .....

plz help me out

Chulett, I have one more requirement ...is to pass a null field to validate a field. So as mentioned in the previous issue if i passing field1 it is give as "30 " and for the requirement 2 if i pass null value in i/p it is taking as whitespace...not sure whats wrong with it..... Can you le...

thanks again for the instace answer...

in the lookup they look like "30" and from input i am getting "30 " .

thanks for the reply...My lookup is also char(3)

Hi Gurus, I have a input field coming all char data types and when i do a lookup against char datatype fields the lookup is failing becoz the values are coming along with spaces. ex. char (3) input field - "30" when i do a look up for this field the data is getting rejected and the if i se...

Thanks a lot for your help...I could solve it out...I made APT_STRING_PADCHAR....as 0x20 and used the trim function - Trim(<Col name>,Char(0),'A')