|
You can use XLS to convert the XML file to a CSV or fixed-width text format in the IFS. Then use the CL command CPYFRMIMPF to upload the CSV or fixed-width file into the DB2 file. Thanks, Kelly -----Original Message----- From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]On Behalf Of Robin.Li@xxxxxxxxxxxxxxxxxxxxx Sent: Tuesday, April 06, 2004 11:40 AM To: wdsci-l@xxxxxxxxxxxx Subject: [WDSCI-L] XML question 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.