DSXchange

Hey Successful....Thank you so much for the help.The code
StringToTimestamp(inputlink:'00:00:00','%yyyy%mm%dd %hh:%nn:%ss')
has worked

Yes i am expecting it to be 00:00:00 So, the code below should work StringToTimestamp(inputlink:'00:00:00','%yyyy%mm%dd %hh:%nn:%ss') But, i am getting the same error Transformer:Conversion error calling conversion routine timestamp_from_string data may have been lost And then a Fatal Error saying :...

Yes, i have tried that way..But as i mentioned whenever you change a target datatype it in turn changes the preceeding stage datatype in our scenario. Also, for the code you mentioned StringToTimestamp(inputlink:'00:00:00','%yyyy-%mm-%dd %hh:%nn:%ss') It won't work as the in this function, we are me...

Whenever you change the Datatype in target oracle stage it automatically reflects back in Transformer stage.
FYI:Timestamp in oracle table is as follows
03-NOV-11 12.00.00.000000000 AM

Is this something i need to concern about

I have put a peek stage to verify if its a data issue..But the field has value as YYYYMMDD. FYI:After the conversion from StringtoTimestamp is done in transformer.The value should be inserted into Oracle table Also, I have tried the code you have suggested. Now, i have some warnings saying:: Transfo...

Hey, I am trying to convert a varchar(8) field to Timestamp in Transformer Input Data for that field:20111113(yyyymmdd) So, i had StringToTimestamp(<Field-name>,"%yyyy%mm%dd") During Runtime, I have the following Fatal error:::: Caught exception from runLocally(): APT_ParseError: Parsing p...

Hey, i think the description field just helps you out to distinguish between columns that you define, and it will have no impact on functionality.

Is it possible to use a value returned by a DSMacro and update a Env Variable dynamically, without using shellscript??

what i want to do exactly is, get the DSJobStartTimestamp and use next time job runs and extract data greater than that timestamp.

Come on now... help us help you fix it . Give us some details as to what the heck your job is doing, stages used, etc. i am using a webservices trf stage, input and output are sequential stages , i am passing all the required inputs to the webservice trf and when i run the job its giving me this er...

has anyone encountered this type of error??? please help me fix this APT_CombinedOperatorController,0: Fatal Error: Fatal: 0026`:`com.ascentialsoftware.wsclient.ServiceInvocationException: Service invocation exception: <ns1:Fault xmlns:ns1="http://schemas.xmlsoap.org/soap/envelope/"> <faul...

How can i use REST with Datastage , i can use wsdl which is SOAP bound in the webservices transformer stage , but how about REST ???

does java transformer perform webservices operations?? that is if i pass a wsdl class file will it perform webservices operation and return the output???

Can anyone please explain why i am getting the below error while i am running a job with two sequential staes and a webservices trf stage in between. APT_CombinedOperatorController,0: Fatal Error: Fatal: 0026`:`com.ascentialsoftware.wsclient.ServiceInvocationException: Service invocation exception: ...

ray.wurlod wrote:What "SOAP version 1.2 problem" would that be?

datastage is not supporting the soap 1.2 version , it only supports 1.1 , i am able to import into the web services transformer but it dosent give the desired output.

Anyone knows how to create a Java class to overcome the SOAP 1.2 version problem in Datastage ?? any help is appreciated