Originally posted by: Kepa_Screen

Hello.

I'm working with DSTX 6.7.1 in a system with a map listening an oracle AQ.
The output we want to produce is an XML file.

We are triggering the map that builds the output from another map, passing commands to run function to override output commands.

At first time we used FILE adapter for this, but we are thinking that would be better to use XML Data Adapter...So we changed from -OF3+ 'somefilename.xml' to -OAXMLDAT3+ 'FILE://somefilename.xml'

We are getting Error 145 at Run function at managment console, but could not find where this error is documented.

Could any body give some light ?

also tried to use -OAXMLDAT3 'somefilename.xml' , and also -OAXMLDATA instead of -OAXMLDAT, but same errors were returned.

Thanks in advance.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: jvanboga

Usually that means "override card failure"

What does you log file say?

Are you executing the card differnetly than it is defined in the map?
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: Kepa_Screen

Hi, thanks for your reply.

First, we defined the output card as File.
Our input Type Tree was imported from a DTD, so, xml tags are well-formed, and we get a valid xml File using this adapter (FIle for output).

Then, we began getting errors , when some fields have special characters '<, >, etc ' that make the file not valid for xml specifications.

So we tried to use XML Data Adapter instead of FILE.

We saw at Documentation that Command line for this XML Data output is "-OAXMLDATCard_NO"

This is the unique thing we changed, the output adapter, and the command.
We changed from

-OF3B+ 'filename.xml' to -OAXMLDAT3+ 'filename.xml'

We have no trace file with this error, because the map has not run ( it was called from another map, with RUN functions, overwriting original card commands hardcoded at the map with values passed from caller map. )

Another test was to use XML Data adapter at design studio, compile and execute in local mode, and this execution clompeted well.

The problem only occurs when we execute this map in our AIX box.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: jvanboga

not sure your override statement is formated correctly. Here's some information that might help. I don't do a lot with XML though.

Target Overrides:
Application (-OA)
Override, Database (-OD)
Override, Echo (-OE)
Override, File (-OF)
Override, Message (-OM)
Override – Application
-OAaliascard_numRc:i{target-adptr-cmd|.}

Override – File
-OFcard_num!+X0Rc:i{target|.}Name Syntax

X = delete on success
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: Kepa_Screen

Override – Application
-OAaliascard_numRc:i{target-adptr-cmd|.}

This is what we are using:

alias=XMLDATA
card =3
file must append records=+

-OAXMLDAT3+'filename.xml'

so cannot understand where the problem is.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: Kepa_Screen

Some part of the problem is resolved.

We are using -OAXMLDATA3+ 'filename.xml' and now is working ok.
The problem that we are getting is that the output file is overwritten, and can not append.

We thing that the '+' flag is not working.
Does "XML Data Adapter" support "append" instead of "create" option ??
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: janhess

I think you should be using file not xmldata. I've never used that for XML.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: jvanboga

OK, you are refering to 1082.pdf. Looks like your punctuation may still be off. You might try

" -OAXMLDAT3 FILE:'" + path_filename_value +"'"

or

" -OAXMLDAT3 FILE://path/filename.xml"
This was also part of the 6.7.1 documentation (1030.pdf)....

Type Property Extensions Improve Native XML Support
Type Property extensions in Version 6.0 allow XML data to be directly validated
and constructed without using the XML Data adapter. Eliminating the necessity to
use the XML Data Adapter improves performance and simplifies the use of XML
data in conjunction with another resource adapter, such as HTTP, or when passing
data to a map using memory.....

Again, though, I'm not an XML guru so... Looks like you already know more than me here.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: Kepa_Screen

Thanks again for your reply.
Finally we got XML Data adapter working, yes, you were correct and it was the syntax what was not typed correctly.

Althought this, we are going to use FILE because cannot use XML Data with append option, and we need this in order to collect several records into an unique file.
We know that this can be done with another map listening to a folder where single record files and collecting all individual files into our final file...

But if this is true:
"Type Property extensions in Version 6.0 allow XML data to be directly validated
and constructed without using the XML Data adapter."

then probably we are going to the correct way if we use FILE adapter ( we are using yet Type Tree that validates XML, created via DTD import ).
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: Kepa_Screen

> jvanboga wrote:
> OK, you are refering to 1082.pdf. Looks like your punctuation may still be off. You might try
>
> " -OAXMLDAT3 FILE:'" + path_filename_value +"'"
>
> or
>
> " -OAXMLDAT3 FILE://path/filename.xml"
> > This was also part of the 6.7.1 documentation (1030.pdf)....
>
> Type Property Extensions Improve Native XML Support
> Type Property extensions in Version 6.0 allow XML data to be directly validated
> and constructed without using the XML Data adapter. Eliminating the necessity to
> use the XML Data Adapter improves performance and simplifies the use of XML
> data in conjunction with another resource adapter, such as HTTP, or when passing
> data to a map using memory.....
>
> Again, though, I'm not an XML guru so... Looks like you already know more than me here.
> jvanboga wrote:
> OK, you are refering to 1082.pdf. Looks like your punctuation may still be off. You might try
>
> " -OAXMLDAT3 FILE:'" + path_filename_value +"'"
>
> or
>
> " -OAXMLDAT3 FILE://path/filename.xml"
> > This was also part of the 6.7.1 documentation (1030.pdf)....
>
> Type Property Extensions Improve Native XML Support
> Type Property extensions in Version 6.0 allow XML data to be directly validated
> and constructed without using the XML Data adapter. Eliminating the necessity to
> use the XML Data Adapter improves performance and simplifies the use of XML
> data in conjunction with another resource adapter, such as HTTP, or when passing
> data to a map using memory.....
>
> Again, though, I'm not an XML guru so... Looks like you already know more than me here.
Hello:

Now, we are getting same errors.
We changed Type Tree Document Property an set it to XML ( DTD , but we didnt put anything at this edit box ), for each item in the type Tree.

If we use FILE Adapter and get some Text Data with characters like '<'>', or '&'
then the XML file is not valid, because they are not converted to &gt;, &lt; &amp; etc....they still remain the same '<'>', and so on. So this is not a correct behaviour for FILE Adapter + "imported from DTD" Type Trees.

If we use -OAXMLDATA adaptor, we get > converted to &gt;, but the problem is that we can not use "Append", only "Create" can be used with this adapter, so we can not get a unique file with all records, only get one record. We could do something at our system to resolve this ( like using another map to collect all records in another file, and change our maps to write at unique files each instance they are executed ).
But this is no a good solution for us.

Is there something we are forgetting ?

Message was edited by: Kepa

Message was edited by: Kepa
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange