DSXchange

Hi All, I am working on DataStage 8.0 Server job. I am trying to run my DS job using UNIX script. the command which I am using to run the job is - dsjob -server dsserver -user dsusername -password dspassword ProjectName JobName. Script si sthrwing error as "syntax error". When I run the sc...

Hi All, We are in process of building a DataStage job which would call a ALSB web service to update the salesforce instance. Potentially Salesforce.com would accept 200 records in a single request. Is this something that can easily be accomplished using DataStage? For instance, if the process extra...

Hi All, We are in process of building a DataStage job which would call a ALSB web service to update the salesforce instance. Potentially Salesforce.com would accept 200 records in a single request. Is this something that can easily be accomplished using DataStage? For instance, if the process extrac...

Hi, In version 7.5 I always used BAT files like this to execute DS jobs. I just tried the same in version 8(we recently upgraded) and I get the error below. I'm not sure what I am missing. Thanks - - John Contents of BAT file D: CD D:\IBM\InformationServer\Server\DSEngine\bin dsjob -user Z8TDSTG ^ ...

Hi All, I have developed a DataStage job to call the web service operation. My job was running fine till yeasterday fine. But when I tried running job today I am getting following errors- "http://schemas.xmlsoap.org/soap/envelope/"> <faultcode>soapenv:Server.userException</faultcode> <faul...

The WSTransformer is not able to handle complex SOAP bodies, nor attachments. SF.com could be doing many creative things to send back this "dataset"...perhaps as a set of rows in a sub-node within the SOAP body, or in some other fashion. If it's in the SOAP body, then you can easily get i...

Hi,

Can anybody tell me how to generate sequence in datastage server job?

Have you tested SF.com with something else? Maybe it simply does not deliver the information you want. ... Yeh Ray, In normal configuration it returns only true and false and not the respective dataset. But I just wanted to know that in any way it is possible to configure dataset as well as part of...

There are at least two patches for 8.0 that you'll need... one is informal...look thru threads here for various things about javapack and/or WSPack and settings you need for DATASTAGE_JVM and DATASTAGE_JRE (you'll know if you need it if you get 'unable to initialize jvm' errors), and the other, if ...

Hi, we are using web service operation for some critical salesforce integration. We are able to make the updation in SF.com using web services but the return we are not getting the way we wanted. My requirement is something like this-- There are three rows in source named as A,B and C that we are ge...

Hi All,

Can we user WSTransformer stage and WS Client stage in DS8.0 Parallel jobs?


Thanks
Santosh rai

The failure code (assuming that the call to sf.com worked) should be in the response body......parse out the body in a downstream transformer, and then send your logical rejects to an appropriate location. Ernie Thanks a lot Erine. One doubt about parsing. Do we need to use XML input stage only to ...

Hi All, I have a XMLoutput file which contains the data returned from a web service operation. Now my requirement is to parse XMl data in tabular record and insert into a sequential file. I tried implementing this using XMLinput Stage but I am getting following errors- "The name '{0}' is not a ...

Hi All, Does anybody has any idea how to handle reject rows in WSTransformer stage. My job is something like this- SQLserver database will be source to WStransformer stage and based on the input it will call WSDL operation and WSDL will update Salesforce.com internally. Lets suppose there are 10 row...

Hi All, I am inprocess of building a DataStage job which can consume web services. For normal logic I have checked and web service is working fine. Now my requirement is- The record of any failed update should be written to flat file, mean let suppose there are 10 records coming from source and only...