DSXchange

Hi, I have used below solution, I have created a serial number for each record from source. such as ID, COUNTER A, 1 B, 2 C, 3 D, 4 E, 5 F, 6 G,7 H,8 I,9 J,10 K,11 L,12 M,13 N,14 O,15 F,16 Now, I because I want to make set of 5 records , I have divided COUNTER with 5. When I divide , the integer of ...

Hi, I have n number of records in source database. Now for every 500 records extracted from source, I should be able to assign a unique value for the whole set, and for next 500 records , I should be able to assign another unique value and so on. here , we are not given source count. How can I achie...

Hi , the issue got resolved. I am creating a XML file. I changed regrouping and it did not throw me error...

Ohh!! Missed to type actual question. How to resolve this error. Any solution ? Not able to understand where to look to resolve this issue.

Hi, I am using Hierarchiel stage to group records based on some grouping definitions. When I am runninng this job, the job is failing with the following error, Hierarchical_Data_86,0: 2016-03-07 11:28:20,671 Error [XML_Composer] [] com.ibm.e2.core.exceptions.E2IllegalStateException: CallAfterLastIte...

Hi, Finally the job finished and I am able to Post the XML file to Webservices. Thank you eostic , Criag , ray for your valuable suggestions. Job 1 :- DB2 --> Transformer --> Hierarchical stage (XML File creation with groups) Used Hierarchical stage to do grouping. Job 2 :- Folder stage --> Transfor...

Hi, I created Soap Project with wsdl in Soap UI. I opened method and clicked on Request. I got below information with Soap Envelop. In the below text , which one is Soap Header ? <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:acc="http://www.accentur...

Any idea, How to resolve this issue.

Hi, I used Hierarchiel transformer to do regrouping. And I got an XML file with desired output. Currently my Job design is as below : Oracle DB --> Transformer --> Hierarchical Data --> WS Client Now I am getting te below error : TGT_WBS_LISTEDVALUES,0: Info: JOB_INT_LISTEDVALUES_JDE_CAS_FinalStep_T...

Ernie, Can I use WS transformer for complex XMLs? I have a complex one. I just created a sample one for illustrating example. Also, the purpose is to avoid file storage on any disk before sending these files to Webservice. I believe you are asking me to work using XML Output stage for testing purpose.

Hi Ernie,

Thank you, I will try the method you explained.

Hi , I am sending messages to Webservices through Webservices client Stage. Output is XML message. Input records : ID , Code 1 , 123 2 , 345 Output to Webservices - two records are creating two seperate XML Objects as show below, <Header> <IntegrationObjectID>ListedValues</IntegrationObjectID> </Hea...

Hi All,

The issue is resolved. I changed fatal errors to Info, then job finished and posted data to webservices.

Hi Erine,

I did all the steps mentioned in my previous posts in SOAP UI , and it worked fine.

In datastage I used webservices client and did job in both server as well as parallel.

Hi craig,

Noted. Sorry, I was not aware of the trouble you are facing.