hierarchical query as web service input

Dedicated to DataStage and DataStage TX editions featuring IBM<sup>®</sup> Service-Oriented Architectures.

Moderators: chulett, rschirm

Post Reply
Matarase
Participant
Posts: 5
Joined: Wed Dec 03, 2014 2:49 am

hierarchical query as web service input

Post by Matarase »

Hi,
First i must say , i am beginner on Datastage and trying to learn as much as i can about infrastructure between XML and Web Services.
I spend my whole week searching forum and other websites and i could not find any simple example. there were an example .dsx but it was for old version 8.0

i do the requirements as :
* imported wsdl url and related services to Table Definition\Web Services
* imported .xsd file from wsdl url to Schema Library Manager

What i am trying to do is this structure :
(1) ODBC_Connector -> (2) Hierarchical Data -> (?) Web Services Transformer

1) First is a hierarchical query for SoapUI request and hierarchy is like this :

Code: Select all

element_1
element_2
list_1
    list_1_element_1
    list_1_element_2
and the query result data is (ID is primary key):
  • "ID" "DESC" "KOD1" "101"
    "ID" "DESC" "KOD2" "102"
2) In XML stage (Assembly Editor)
a) added regroup step from palette (configured parent/child relation and keys)
b) added XML Composer Step for create xml file

3) Last step i dont know how to configure Web service
I need to give this input to web service as header + body

I can provide any information for flow.
Can anyone try this flow or any similar flow ?
any example will do ( or .dsx file for 11.x )

thank you
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Re: hierarchical query as web service input

Post by chulett »

Welcome.
Matarase wrote:there were an example .dsx but it was for old version 8.0
Just wanted to note that your 'old version' dsx should import just fine into any higher version repository. You don't need to match versions as they are backwards compatible.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Matarase
Participant
Posts: 5
Joined: Wed Dec 03, 2014 2:49 am

Re: hierarchical query as web service input

Post by Matarase »

When I try to import .dsx file it gives these two errors :

1) ... .dsx can only be imported when the client code page is 1252 - it is currently 1254
well i try to change CharacterSet "ENGLISH" to CharacterSet "CP1252"
but nothing changed.

2) ... .dsx does not appear to be a valid DataStage export file or is from an incompatible realase.A valid DataStage export file is expected to be in Windows format.(i.e. using CRLF line terminators)

so i guess you cannot able to import this file ? i took the files from Ernie Ostic blog "Calling a Web Service that supports Arrays for input and output".

i hope i would get an update about the files ?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Try changing the character set at the top of the DSX file to the same that your Windows system uses then attempt the import again.

You may also need to convert the UNIX linefeeds to Windows line terminators using a utility such as unix2dos.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Matarase
Participant
Posts: 5
Joined: Wed Dec 03, 2014 2:49 am

Post by Matarase »

That worked , I mean i can able to import the example.
After i build my flow as same structure as example it compiled but after i run it , gave me this error:

"Abnormal termination of stage xxx detected"

i made a search on this error and it seem a bug ?
i really did not understand what the error means , any idea ?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Were there any other error messages reported? This is a really generic report, indicating that stage xxx returned a non-success exit status. And nothing more.

Perhaps you could enable some of the reporting environment variable job parameters to try to get a better handle on what's happening when the stage fails.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply