DSXchange

And what do you classify as "special" characters?

There was more data in the record than the metadata indicated there should be.

Because there is no such option. Why would you care that they are included, are they causing some kind of issue for you?

Googled around and perhaps this might help. Otherwise it seems like it could be network related.

Any way other than automatically? Something wrong with what was posted? Have you tried it and then checked in SQL Server outside of DataStage?

Before we go too far afield, could you clarify exactly what it is you need to do with these "insert scripts"? You need to break them down and store them as scripts in Oracle or somehow turn them into Oracle DML and execute them? Best to show us not only what your input would look like but ...

It's run from the command line, just like the dsexport utility you posted. Are you looking for a client-based solution or a server-based one? What are you using these exports for?

Tried to import the metadata? So, did you? What happened? If you have (or can get) an xsd for this, it would be a better source to import metadata from, by the way.

That utility requires three values when called, from what I recall... key number or some such seems to be missing. Add that and see if it helps.

I honestly don't believe there is an option for this, strange as that sounds. Perhaps there is using the new istool function?

Excellent. Please mark the post as Resolved using the button at the top of the page.

Please start your own post in the Enterprise Edition forum. We frown on "hijacking" other people's posts, one should always create a new post unless you are attempting to help with an existing one.

Thanks.

Honestly, I don't recall having to do anything 'special' for this. If you take the service's WSDL metadata and import that into the WS Client it should handle all of that for you. And I would suggest using an XML Transformer rather than an XML Output stage to generate the XML. Have you tried anythin...

Ernie's on vacation at the moment, so you're stuck with us poor substitutes for stuff like this. It's been several years since I did this myself and I have no DataStage access but let me ponder this and see if I can dredge up anything constructive later tonight.