DSXchange

Posted: **Wed Dec 03, 2014 8:08 am**

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

Posted: **Wed Dec 03, 2014 8:44 am**

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.

Posted: **Fri Dec 05, 2014 6:24 am**

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 ?

Posted: **Fri Dec 05, 2014 12:59 pm**

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.

Posted: **Mon Dec 08, 2014 6:36 am**

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 ?

Posted: **Mon Dec 08, 2014 3:55 pm**

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.

DSXchange

hierarchical query as web service input

hierarchical query as web service input

Re: hierarchical query as web service input

Re: hierarchical query as web service input