Re: XML tools with WDSC 6 Generate iseries data

Manual,

You are way ahead of me! I just changed companies 7 weeks ago, we just
upgraded to Iseries 570 V5R3.  I am new to all this client stuff,
Websphere and 
Whatever else there is. I have been a RPG programmer for over 20 years.
This company has never setup Websphere,DB2 or any client tools yet. My
biggest problem is that I don't know what components go with what. Is
the XML extender intended to be used with Websphere Studio or what. I
have installed the Websphere Studio on my PC and can see all my AS400
programs and files. The Websphere Application Server has not been setup
here yet, I don't know if I need it for my XML project. I am in the
process of trying to setup DB2 'Universal Database Express on my PC
right now. Again, I don't understand where it fits in either. So far
when I try to Attach my test project to our AS400
It blows up. Not for sure if I have all the settings right. Hosts,
Imhost are questionable for me. DB2 Client verses Application server??
Maybe I'm making this too hard but I have no clue what I really need to
accomplish my XML project.

All I want to do is to receive an XML document from Holland and
translate the data to the SV40 and then take a SV40 file and translate
it to XML and send it back.  This can't be all that complicated to do,
but I can't find anyone who can tell how to do it in ENGLISH.


I just received my third email from IBM checking to see if the manuals
solved my
Problems. Maybe the next response will be a phone call from them.

Any recommendations would greatly be appreciated.


Thanks,

Deby


---Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]
On Behalf Of Manuel CERDA
Sent: Thursday, October 19, 2006 8:42 AM
To: wdsci-l@xxxxxxxxxxxx
Subject: [WDSCI-L] XML tools with WDSC 6 Generate iseries data

Thanks a lot Debra,
Good to know that I am not the only one struggling with the xml
extender. I find very it very frustrating as we can read everywhere that
IBM is pushing XML with Db2 and they do not provide a simple easy
understanding documentation.
All the documentation is all to do with DAD and complex scenario, but I
thought using the wdsc wizards xml tools would simplify the process.
I found the administration wizard to install on the pc. But I think to
make it work the java toolbox needs to be installed on the pc (Jdbc
driver) first. I had a look on the version 8.2 of the db2 xml extenders
administration guide from the ibm site. 
The doc DB2 XML Extender Hints and tips seems quite good.
I am missing the C compiler on my iseries, thank a lot for the info.
Have you tried to use the rdb to xml wizards which generates dad
automatically it looks quite good if it works, I have not tried it yet.
When I generate an xsd from my xml and the sql from the xsd the deploy
the sql. I get the sql error msg SQL0204 Myusername not found in QSYS. I
do not understand why it takes my iseries server user id instead of the
default schema  I entered when I created my connection. Have you tried
that ? I can use sql in the data perspective without any problems.

Regards
Manuel