DSXchange

Hi I am trying to assign a null value to a date based on a certain condition in the transformer. If the score is 1 then the data shld be assigned else the date shld be null in DB. I am using something like If score=1 then DSJOB start date else ' ' But its failing. How to handle this scenarios? thanks

Hi Ernie,

The webservices group came back to us asking if there are any ways to pass the authentication(windows authentication) through datastage or webservices stage..Any Idea on how to pass the aunthentication to the webservices..

Thanks

Hi Ernie,

OUR DS Server is on Linux.They have the webservices and sharepoint on the same box.so it is asking for windows password for auntentication which I dont know how to pass it through datastage or webservices.

Thanks

Hi, I opened a PMR with IBM on this Time format and they said that "24:00:00" is a valid db2 time format. So dont know how to handle this in datastage as I need to convert this into the next day date. for example if it is 2010-05-12 24:00:00 then it needs be converted into 2010-05-13 00:00...

Hi All, we have a requirement where we need to build an xml based on a certain logic which is based on the input data file. Input data file: Feild1 Field2 Field3 1 2238681 AA 1 2566855 AA 1 3321605 AA 2 3049616 11 2 3321609 11 2 3321616 11 2 3321610 11 Business Logic: If the field1 value= 1 then fil...

Hi Ernie,

We got this resolved..It was a windows authentication issue on the websevices end, which got resolved after they have disabled the authentication.
Thanks for your inputs.


Thanks

Hi,

Used CHAR(xxx) in your Convert() function and it worked.

Thanks everyone for the inputs.

Hi, Thanks for your reply. To be more specific I am creating XML file and handling the reserved characters in the XML Output stage. But when the target side tried to use the XML file for their process they got the following error ABCDE.xml: Loader is throwing errors due to invalid XML character 0x1e...

Hi, I have a requirement to convert one special character("") to empty (Need to drop this character when encountered).The sequence of keys to generate the special character is:CTRL + Shift +6. I have used the convert function as Convert("","",lnk_db_xfm_po_part_dimensio...

Hi Ernie, I got the information for the userid/pwd. Now I got new error which is.. APT_CombinedOperatorController(1),0: Fatal Error: Fatal: 0026`:`com.ascentialsoftware.wsclient.ServiceInvocationException: Service invocation exception: <ns1:Fault xmlns:ns1="http://schemas.xmlsoap.org/soap/envel...

Hi Ernie,

I tried to send the data using SOAPUI. I just sent blanks and got response on that.But it is not working through datastage.

Any suggestions on that.


Thanks

Hi All, Iam trying to send records(requests) using webservices transformer stage in DS 8.0 version. Iam getting the following error. Web_Services_Transformer_60,0: Fatal Error: Fatal: 0026`:`com.ascentialsoftware.wsclient.ServiceInvocationException: Service invocation exception: <ns1:Fault xmlns:ns1...

Hi Craig,

I tried your method and it worked...Thanks!!!

Thanks.

Hi, My requirement is to pass two sets of dates(as parameters) into the given sql queries. I have created two jobs, one for each set of dates. Iam trying call these two jobs thru a sqeunce job and pass the dates in the loops as list. Here is my sequence flow. execute stage1-->UserVariable1-->StartLo...

Hi Ernie,

Thanks for the response.

I wanted to find out... how to convert the XML as a base64 binary..?

Any inputs would be of great help.

Regards.