|
Robin, There are a couple tools in WDSc that can help you with this. They are: 1. XML and SQL Query wizard: This wizard generates code to take the results of an SQL query and create an XML document from them or take an XML document and write the results to a database (including OS/400 database) using SQL. The generated code uses standard SQL with JDBC drivers so it works with any database and there are no other requirements. This is the easier of the 2 options but not as flexible in terms of mapping columns to XML elements / attributes as the next one. 2. RDB to XML Mapping tool. This is a bit more involved than the XML and SQL query wizard but is more flexible in terms of the allowed mappings. This generates a DADX file which is used with DB2 XML Extenders (available for the iSeries.) You can find some more details in the following article: http://eservercomputing.com/iseries/articles/index.asp?id=656&dir=/iseries/articles/ Hope this helps. Don Yantzi WebSphere Development Studio Client for iSeries IBM Toronto Lab Phone: (905) 413-4476 IBM internal: IBMCA(yantzi) - Internet: yantzi@xxxxxxxxxx Robin.Li@microage solutions.com Sent by: To wdsci-l-bounces@m wdsci-l@xxxxxxxxxxxx idrange.com cc Subject 04/06/2004 12:39 [WDSCI-L] XML question PM Please respond to Websphere Development Studio Client for iSeries Good morning, Is there an easy way to convert XML file to AS/400 file format? I have an existing XML file and want to retrieve some of the info and put them into an AS/400 file by WDSCi XML. Any help is greatly appreciated! Robin wdsci-l-request@xxxxxxxxxxxx Sent by: wdsci-l-bounces@xxxxxxxxxxxx 04/06/2004 10:32 AM Please respond to wdsci-l@xxxxxxxxxxxx To wdsci-l@xxxxxxxxxxxx cc Subject WDSCI-L Digest, Vol 2, Issue 153 Send WDSCI-L mailing list submissions to wdsci-l@xxxxxxxxxxxx To subscribe or unsubscribe via the World Wide Web, visit http://lists.midrange.com/mailman/listinfo/wdsci-l or, via email, send a message with subject or body 'help' to wdsci-l-request@xxxxxxxxxxxx You can reach the person managing the list at wdsci-l-owner@xxxxxxxxxxxx When replying, please edit your Subject line so it is more specific than "Re: Contents of WDSCI-L digest..." Today's Topics: 1. WebFacing input/output parameters (Heuvel van den, Wim) 2. Re: WebFacing input/output parameters (Paul Nicolay) 3. RE: WebFacing input/output parameters (Heuvel van den, Wim) 4. Code designer does not work at all now (Darwin Gaster) 5. Uploading RPG Source (Mike Silvers) 6. Re: Uploading RPG Source (Mark Phippard) 7. Re: WebFacing input/output parameters (Paul Nicolay) 8. Re: WebFacing input/output parameters (Wolf de, Jeroen) 9. Re: Uploading RPG Source (Mike Silvers) 10. Re: Uploading RPG Source (Mark Phippard) 11. Re: Uploading RPG Source (Mike Silvers) ---------------------------------------------------------------------- message: 1 date: Tue, 6 Apr 2004 13:35:54 +0200 from: "Heuvel van den, Wim" <w.vandenHeuvel@xxxxxxxxx> subject: [WDSCI-L] WebFacing input/output parameters Hello! I want to use webfacing to build a web-interface on our existing RPG-application. The application is a 'modular' RPG/400-application, which consists of many small programs calling each other (OPM, no ILE). We have tried to build reusable components (small programs), so the possibility to create multiple entry points within a WebFaced Applicaton is of great value. One of the components is small program, containing a subfile-window. It displays our customers, and gives the opportunity to select a customer. The program 'returns' the customer number to the calling RPG. We call the program with an 'empty' parameter in its PLIST, and the calling RPG-program receives the selected customer number. We woud like to re-use this webfaced program in a Java application. Is it possible to get the (input) parameter back (output) from a webfaced application? You can define one or more input-parameters, but if the value of the parameter is changed can I get it back in the 'calling program'? Thanks for thinkin with me, Wim van den Heuvel SILVAC BV The Netherlands ------------------------------ message: 2 date: Tue, 06 Apr 2004 13:00:25 +0000 from: "Paul Nicolay" <Paul.Nicolay@xxxxxxxxxx> subject: Re: [WDSCI-L] WebFacing input/output parameters Wim, What do you mean by reusing the webfaced program in a Java application ? Do you mean you want to reuse your customer selection screen in another JSP/Servlet based application ? I guess you're trying to mix two different worlds. Kind regards, Paul >----- Oorspronkelijk bericht ----- >Van: Heuvel van den, Wim [mailto:w.vandenHeuvel@xxxxxxxxx] >Verzonden: dinsdag, april 6, 2004 11:35 AM >Aan: 'wdsci-l@xxxxxxxxxxxx' >Onderwerp: [WDSCI-L] WebFacing input/output parameters > >We woud like to re-use this webfaced program in a Java application. Is it >possible to get the (input) parameter back (output) from a webfaced >application? You can define one or more input-parameters, but if the value >of the parameter is changed can I get it back in the 'calling program'? > >Thanks for thinkin with me, > >Wim van den Heuvel >SILVAC BV >The Netherlands >_______________________________________________ ------------------------------ message: 3 date: Tue, 6 Apr 2004 15:14:23 +0200 from: "Heuvel van den, Wim" <w.vandenHeuvel@xxxxxxxxx> subject: RE: [WDSCI-L] WebFacing input/output parameters Paul, XQQ my poor explanation, but you are correct. I want to call my RPG-program from a JSP or servlet, display the 'webfaced' screen, select the customer from the list and return the the customer number to the JSP or servlet. I don't want to write a new Java-equivalent for my RPG-logic; this is an example of one of many situations. Wim -----Original Message----- From: Paul Nicolay [mailto:Paul.Nicolay@xxxxxxxxxx] Sent: Tuesday, April 06, 2004 3:00 PM To: Websphere Development Studio Client for iSeries Subject: Re: [WDSCI-L] WebFacing input/output parameters Wim, What do you mean by reusing the webfaced program in a Java application ? Do you mean you want to reuse your customer selection screen in another JSP/Servlet based application ? I guess you're trying to mix two different worlds. Kind regards, Paul >----- Oorspronkelijk bericht ----- >Van: Heuvel van den, Wim [mailto:w.vandenHeuvel@xxxxxxxxx] >Verzonden: dinsdag, april 6, 2004 11:35 AM >Aan: 'wdsci-l@xxxxxxxxxxxx' >Onderwerp: [WDSCI-L] WebFacing input/output parameters > >We woud like to re-use this webfaced program in a Java application. Is it >possible to get the (input) parameter back (output) from a webfaced >application? You can define one or more input-parameters, but if the value >of the parameter is changed can I get it back in the 'calling program'? > >Thanks for thinkin with me, > >Wim van den Heuvel >SILVAC BV >The Netherlands >_______________________________________________ _______________________________________________ This is the Websphere Development Studio Client for iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/wdsci-l or email: WDSCI-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/wdsci-l. ------------------------------ message: 4 date: Tue, 6 Apr 2004 09:20:28 -0500 from: Darwin Gaster <DarwinG@xxxxxxxxxxx> subject: [WDSCI-L] Code designer does not work at all now After installation I had the following Windows option: Start/Programs/IBM Websphere Studio/Development Studio for ISeries/complete the installation of CODE and VisualAge RPG As I said, I ran it more than once before it seemed to complete successfully. ------------------------------ message: 5 date: Tue, 6 Apr 2004 10:32:27 -0400 from: "Mike Silvers" <msilvers@xxxxxxxxxxx> subject: [WDSCI-L] Uploading RPG Source I am in the iSeries perspective. I have downloaded my source files. I have made some changes to the source, now I need to upload the source back to the 400. I have been working off-line. This is a new source member I have created. How do I upload the new/modified source member to the 400? Thanks Mike ======================================= Mike Silvers Senior Programmer/Analyst IBM Certified Expert Hainey Business Systems Main Office: (717) 718-9601 ext 237 Branch Office: (410) 397-8739 http://www.hbs-inc.com AIM: IBMJavaMan ======================================= ------------------------------ message: 6 date: Tue, 6 Apr 2004 10:37:50 -0400 from: Mark Phippard <MarkP@xxxxxxxxxxxxxxx> subject: Re: [WDSCI-L] Uploading RPG Source Right-click on project or member. Remote Actions -> Push Changes or Push Selected Mark wdsci-l-bounces@xxxxxxxxxxxx wrote on 04/06/2004 10:32:27 AM: > I am in the iSeries perspective. I have downloaded my source files. I have > made some changes to the source, now I need to upload the source back to the > 400. I have been working off-line. This is a new source member I have > created. How do I upload the new/modified source member to the 400? > > Thanks > > Mike > > ======================================= > Mike Silvers > Senior Programmer/Analyst > IBM Certified Expert > Hainey Business Systems > Main Office: (717) 718-9601 ext 237 > Branch Office: (410) 397-8739 > http://www.hbs-inc.com > AIM: IBMJavaMan > ======================================= > > > _______________________________________________ > This is the Websphere Development Studio Client for iSeries (WDSCI- > L) mailing list > To post a message email: WDSCI-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/wdsci-l > or email: WDSCI-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/wdsci-l. ------------------------------ message: 7 date: Tue, 06 Apr 2004 14:55:52 +0000 from: "Paul Nicolay" <paul.Nicolay@xxxxxxxxxx> subject: Re: [WDSCI-L] WebFacing input/output parameters Wim, I haven't tried it myself, but I don't see a clean method of passing parameters between what actually runs in a 5250 session via Webfacing and an application that runs in your application server. I can imagine that it might be possible with changing the JSP code of Webfacing and storing it in cookies or the session, but I doub't it is clean. Looking forward to other experiences... Kind regards, Paul >----- Oorspronkelijk bericht ----- >Van: Heuvel van den, Wim [mailto:w.vandenHeuvel@xxxxxxxxx] >Verzonden: dinsdag, april 6, 2004 01:14 PM >Aan: ''Websphere Development Studio Client for iSeries'' >Onderwerp: RE: [WDSCI-L] WebFacing input/output parameters > >Paul, > >XQQ my poor explanation, but you are correct. I want to call my RPG-program >from a JSP or servlet, display the 'webfaced' screen, select the customer >from the list and return the the customer number to the JSP or servlet. I >don't want to write a new Java-equivalent for my RPG-logic; this is an >example of one of many situations. > >Wim >>-----Original Message----- >From: Paul Nicolay [mailto:Paul.Nicolay@xxxxxxxxxx] >Sent: Tuesday, April 06, 2004 3:00 PM >To: Websphere Development Studio Client for iSeries >Subject: Re: [WDSCI-L] WebFacing input/output parameters > > >Wim, > >What do you mean by reusing the webfaced program in a Java application ? > >Do you mean you want to reuse your customer selection screen in another >JSP/Servlet based application ? > >I guess you're trying to mix two different worlds. > >Kind regards, >Paul ------------------------------ message: 8 date: Tue, 6 Apr 2004 17:08:26 +0200 from: "Wolf de, Jeroen" <j.dewolf@xxxxxxxxx> subject: Re: [WDSCI-L] WebFacing input/output parameters Hi, I have investigated this very same problem also and my conclusion is that it can't be done without diving into the webfacing JSPs. As far as I can see, this code is not easily available form WSDCI and is kind of 'contained' in JAR files present on the Webfacing server. Am I right here? Kind regards, Jeroen de Wolf SILVAC B.V. ------------------------------ message: 9 date: Tue, 6 Apr 2004 11:11:49 -0400 from: "Mike Silvers" <msilvers@xxxxxxxxxxx> subject: Re: [WDSCI-L] Uploading RPG Source I do not have that option -- it is grayed out. ----- Original Message ----- From: "Mark Phippard" <MarkP@xxxxxxxxxxxxxxx> To: "Websphere Development Studio Client for iSeries" <wdsci-l@xxxxxxxxxxxx> Sent: Tuesday, April 06, 2004 10:37 AM Subject: Re: [WDSCI-L] Uploading RPG Source > Right-click on project or member. > > Remote Actions -> Push Changes or Push Selected > > Mark > > wdsci-l-bounces@xxxxxxxxxxxx wrote on 04/06/2004 10:32:27 AM: > > > I am in the iSeries perspective. I have downloaded my source files. I > have > > made some changes to the source, now I need to upload the source back to > the > > 400. I have been working off-line. This is a new source member I have > > created. How do I upload the new/modified source member to the 400? > > > > Thanks > > > > Mike > > > > ======================================= > > Mike Silvers > > Senior Programmer/Analyst > > IBM Certified Expert > > Hainey Business Systems > > Main Office: (717) 718-9601 ext 237 > > Branch Office: (410) 397-8739 > > http://www.hbs-inc.com > > AIM: IBMJavaMan > > ======================================= > > > > > > _______________________________________________ > > This is the Websphere Development Studio Client for iSeries (WDSCI- > > L) mailing list > > To post a message email: WDSCI-L@xxxxxxxxxxxx > > To subscribe, unsubscribe, or change list options, > > visit: http://lists.midrange.com/mailman/listinfo/wdsci-l > > or email: WDSCI-L-request@xxxxxxxxxxxx > > Before posting, please take a moment to review the archives > > at http://archive.midrange.com/wdsci-l. > _______________________________________________ > This is the Websphere Development Studio Client for iSeries (WDSCI-L) mailing list > To post a message email: WDSCI-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/wdsci-l > or email: WDSCI-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/wdsci-l. > ------------------------------ message: 10 date: Tue, 6 Apr 2004 11:14:26 -0400 from: Mark Phippard <MarkP@xxxxxxxxxxxxxxx> subject: Re: [WDSCI-L] Uploading RPG Source Maybe you have to be connected or "On-line" or whatever terminology it uses. Sounds like it thinks you are not connected. Mark wdsci-l-bounces@xxxxxxxxxxxx wrote on 04/06/2004 11:11:49 AM: > I do not have that option -- it is grayed out. > > ----- Original Message ----- > From: "Mark Phippard" <MarkP@xxxxxxxxxxxxxxx> > To: "Websphere Development Studio Client for iSeries" <wdsci-l@xxxxxxxxxxxx> > Sent: Tuesday, April 06, 2004 10:37 AM > Subject: Re: [WDSCI-L] Uploading RPG Source > > > > Right-click on project or member. > > > > Remote Actions -> Push Changes or Push Selected > > > > Mark > > > > wdsci-l-bounces@xxxxxxxxxxxx wrote on 04/06/2004 10:32:27 AM: > > > > > I am in the iSeries perspective. I have downloaded my source files. I > > have > > > made some changes to the source, now I need to upload the source back to > > the > > > 400. I have been working off-line. This is a new source member I have > > > created. How do I upload the new/modified source member to the 400? > > > > > > Thanks > > > > > > Mike > > > > > > ======================================= > > > Mike Silvers > > > Senior Programmer/Analyst > > > IBM Certified Expert > > > Hainey Business Systems > > > Main Office: (717) 718-9601 ext 237 > > > Branch Office: (410) 397-8739 > > > http://www.hbs-inc.com > > > AIM: IBMJavaMan > > > ======================================= > > > > > > > > > _______________________________________________ > > > This is the Websphere Development Studio Client for iSeries (WDSCI- > > > L) mailing list > > > To post a message email: WDSCI-L@xxxxxxxxxxxx > > > To subscribe, unsubscribe, or change list options, > > > visit: http://lists.midrange.com/mailman/listinfo/wdsci-l > > > or email: WDSCI-L-request@xxxxxxxxxxxx > > > Before posting, please take a moment to review the archives > > > at http://archive.midrange.com/wdsci-l. > > _______________________________________________ > > This is the Websphere Development Studio Client for iSeries (WDSCI-L) > mailing list > > To post a message email: WDSCI-L@xxxxxxxxxxxx > > To subscribe, unsubscribe, or change list options, > > visit: http://lists.midrange.com/mailman/listinfo/wdsci-l > > or email: WDSCI-L-request@xxxxxxxxxxxx > > Before posting, please take a moment to review the archives > > at http://archive.midrange.com/wdsci-l. > > > > > _______________________________________________ > This is the Websphere Development Studio Client for iSeries (WDSCI- > L) mailing list > To post a message email: WDSCI-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/wdsci-l > or email: WDSCI-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/wdsci-l. ------------------------------ message: 11 date: Tue, 6 Apr 2004 12:33:51 -0400 from: "Mike Silvers" <msilvers@xxxxxxxxxxx> subject: Re: [WDSCI-L] Uploading RPG Source ok -- how do I do that? ----- Original Message ----- From: "Mark Phippard" <MarkP@xxxxxxxxxxxxxxx> To: "Websphere Development Studio Client for iSeries" <wdsci-l@xxxxxxxxxxxx> Sent: Tuesday, April 06, 2004 11:14 AM Subject: Re: [WDSCI-L] Uploading RPG Source > Maybe you have to be connected or "On-line" or whatever terminology it > uses. Sounds like it thinks you are not connected. > > Mark > > > > wdsci-l-bounces@xxxxxxxxxxxx wrote on 04/06/2004 11:11:49 AM: > > > I do not have that option -- it is grayed out. > > > > ----- Original Message ----- > > From: "Mark Phippard" <MarkP@xxxxxxxxxxxxxxx> > > To: "Websphere Development Studio Client for iSeries" > <wdsci-l@xxxxxxxxxxxx> > > Sent: Tuesday, April 06, 2004 10:37 AM > > Subject: Re: [WDSCI-L] Uploading RPG Source > > > > > > > Right-click on project or member. > > > > > > Remote Actions -> Push Changes or Push Selected > > > > > > Mark > > > > > > wdsci-l-bounces@xxxxxxxxxxxx wrote on 04/06/2004 10:32:27 AM: > > > > > > > I am in the iSeries perspective. I have downloaded my source files. > I > > > have > > > > made some changes to the source, now I need to upload the source > back to > > > the > > > > 400. I have been working off-line. This is a new source member I > have > > > > created. How do I upload the new/modified source member to the 400? > > > > > > > > Thanks > > > > > > > > Mike > > > > > > > > ======================================= > > > > Mike Silvers > > > > Senior Programmer/Analyst > > > > IBM Certified Expert > > > > Hainey Business Systems > > > > Main Office: (717) 718-9601 ext 237 > > > > Branch Office: (410) 397-8739 > > > > http://www.hbs-inc.com > > > > AIM: IBMJavaMan > > > > ======================================= > > > > > > > > > > > > _______________________________________________ > > > > This is the Websphere Development Studio Client for iSeries (WDSCI- > > > > L) mailing list > > > > To post a message email: WDSCI-L@xxxxxxxxxxxx > > > > To subscribe, unsubscribe, or change list options, > > > > visit: http://lists.midrange.com/mailman/listinfo/wdsci-l > > > > or email: WDSCI-L-request@xxxxxxxxxxxx > > > > Before posting, please take a moment to review the archives > > > > at http://archive.midrange.com/wdsci-l. > > > _______________________________________________ > > > This is the Websphere Development Studio Client for iSeries (WDSCI-L) > > mailing list > > > To post a message email: WDSCI-L@xxxxxxxxxxxx > > > To subscribe, unsubscribe, or change list options, > > > visit: http://lists.midrange.com/mailman/listinfo/wdsci-l > > > or email: WDSCI-L-request@xxxxxxxxxxxx > > > Before posting, please take a moment to review the archives > > > at http://archive.midrange.com/wdsci-l. > > > > > > > > > _______________________________________________ > > This is the Websphere Development Studio Client for iSeries (WDSCI- > > L) mailing list > > To post a message email: WDSCI-L@xxxxxxxxxxxx > > To subscribe, unsubscribe, or change list options, > > visit: http://lists.midrange.com/mailman/listinfo/wdsci-l > > or email: WDSCI-L-request@xxxxxxxxxxxx > > Before posting, please take a moment to review the archives > > at http://archive.midrange.com/wdsci-l. > _______________________________________________ > This is the Websphere Development Studio Client for iSeries (WDSCI-L) mailing list > To post a message email: WDSCI-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/wdsci-l > or email: WDSCI-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/wdsci-l. > ------------------------------ _______________________________________________ This is the Websphere Development Studio Client for iSeries (WDSCI-L) digest list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/wdsci-l or email: WDSCI-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/wdsci-l. End of WDSCI-L Digest, Vol 2, Issue 153 *************************************** BEGIN-CANIT-VOTING-LINKS ------------------------------------------------------ NOTE: This message was auto-learned as non-spam. If this is wrong, please correct the training as soon as possible. Teach CanIt if this mail (ID 102662) is spam: Spam: http://192.168.9.225/canit/b.php?c=s&i=102662&m=222c41b2a5fb ------------------------------------------------------ END-CANIT-VOTING-LINKS _______________________________________________ This is the Websphere Development Studio Client for iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/wdsci-l or email: WDSCI-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/wdsci-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
