DSXchange

Hai,

I have a question regarding the DSX file imports, infact two questions.

1). Can I import a 7.1 DSX into 7.5 ?

2). Can I import a 7.5 DSX into 7.1 ?

Thanks

Thank you ... The problem is 2-fold. 1) wrong function, and 2) wrong format for function call. The function you need is timestamp_from_string, not StringToTimestamp. I believe the latter is used in Transforms, not Modify Stages. The format is as follows: newfield:timestamp[microseconds] = timestamp_...

I am trying to use modify stage to convert the string to timestamp and I have specified in the modify stage like this
inputDate [:timestamp] = StringToTimestamp(string(OpenDate)[%YYYY-%mm-%dd-%hh.%nn.%ss.6](OpenDate))
can anyone tell me what's wrong in this expression.

Thanks

Thank you Brad

Hi,
I am having a situation where I am getting the hexadecimal values in my data. Is there any way where I can get rid of them in my target data using a datastage job.

thanks

Thanks a lot Brad !!!!!!!!

Hi kirtikumar, you can find the list of functions which can be used in your C code for you buildops in the documentation of the parallel extender like asString(),null(),isValid() etc .. You check this example ,which can give some idea of how to use these functions in your code. 1 -->out.outputcolumn...

hi brad, my input is coming as a datetime datatype which is like this 2001-02-07-00.00.00.000000 and then in datastage job I am reading it as a varchar and according to the transformations I need to convert that varchar column to timestamp. Thanks.. te="bcarlson"] Hi Brad, Can you please c...

Hi Brad,
Can you please confirm me that this function will convert the varchar (input column )datatype to timestamp(output column)
out.outdate.set(in.CloseDate, "%yyyy-%mm-%dd %hh:%nn:%ss.000000");

Thanks

Hi can anyone let me know what does this error means and how can I correct this error.

I encountered this while running a parallel job.

main_program: When preparing operator: When setting up transfer for "amt _type_cd ":Source and destination have differing nullability

Thanks

Thanks a lot Brad, its working fine now. here my input column is CloseDate(in the varchar datatype) and output column(which is in timestamp datatype ) is outdate out.outdate= in.CloseDate ; out. myTmsp .set(in.CloseDate, "%yyyy-%mm-%dd %hh:%nn:%ss.000000"); I think you had some typos (see ...

Hi Brad, I have written like this in my code, but my operator is not generated. can you please tell me what else I need to add. how should I specify the header file declarations. here my input column is CloseDate(in the varchar datatype) and output column(which is in timestamp datatype ) is outdate ...

Hi Brad, Thanks for the information, but can you please tell me how to use to the set function, and also can you please let me know where to find these functions. My requirement is I have the data coming in a string format (datetime datatype )and I need to convert that to timestamp. If you want to d...

Thanks Ray,Madhav,the bird,sudarshan for the information.

Hi Sudarshan, Thanks for the help, But , I don't know whether I can use the one you mentioned in the buildop or do I need to write the c++ coding for this conversion. If so, can you please throw some suggestions on how to proceed with this. Hi, since you r converting date to timestamp I will assume ...