|
----- Original Message ----- From: <midrange-l-request@midrange.com> To: <midrange-l@midrange.com> Sent: Thursday, January 23, 2003 3:13 PM Subject: MIDRANGE-L Digest, Vol 2, Issue 22 > Send MIDRANGE-L mailing list submissions to > midrange-l@midrange.com > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.midrange.com/mailman/listinfo.cgi/midrange-l > or, via email, send a message with subject or body 'help' to > midrange-l-request@midrange.com > > You can reach the person managing the list at > midrange-l-owner@midrange.com > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of MIDRANGE-L digest..." > > > Today's Topics: > > 1. Re: 2664 Fax adapter at V5R1/2 > 2. Re: iSeries Reporting Tools > 3. RE: Supporting Previous Page / Next Page in SQL? > 4. Re: 2664 Fax adapter at V5R1/2 > 5. Re: iSeries Reporting Tools > 6. > 7. Another CPYTOIMPF question - Someone please put me out of my > misery! > 8. CPF5090 on CPYF > 9. Re: CPF5090: "Unique access path problems prevent updates to > member > > > ---------------------------------------------------------------------- > > > Message: 1 > Date: Thu, 23 Jan 2003 15:37:57 -0500 > From: rob@dekko.com > Subject: Re: 2664 Fax adapter at V5R1/2 > > Yes you can fax through Domino. No, you do not want to fax your iSeries > generated stuff that way. Unless you don't mind these steps: > http://www-1.ibm.com/servers/eserver/iseries/domino/related/fxd/snddomfax.ht m > > Faxing Domino stuff is fine. And if you have a supported attachment it > will even open that up on the fax. > > It even has a Lotus print-to-fax driver that's ok for sending your pc > printouts out via fax. > http://www-1.ibm.com/servers/eserver/iseries/domino/related/fxd/printtofax.h tm > > Now, the Domino fax will probably require special iSeries hardware also. > For inbound we use a regular V.24 comm port with a DID modem from > MultiTech that IBM is pushing. That's ok. For outbound we use the 2805 > card. The 2805 has 4 ports. You could spread them out between Domino and > Fax for iSeries. We have four 2805's. Two cards (8 ports) are for > outbound iSeries faxing. Two cards (8 ports) are for outbound Domino Fax > for iSeries faxing. > http://www-1.ibm.com/servers/eserver/iseries/domino/related/fxd/faxreqs.htm > > We are using a Cisco phone system. It does a lousy job of handling analog > extensions for modems. Bad enough to the point that we are using an > Adtran FXS unit to bypass the Cisco equipment. Solved some issues with > ECS, EDI, faxing, etc. > > General Domino Fax for iSeries information: > http://www-1.ibm.com/servers/eserver/iseries/domino/related/fxd > > > Rob Berendt > -- > "They that can give up essential liberty to obtain a little temporary > safety deserve neither liberty nor safety." > Benjamin Franklin > > > > > Martin Rowe <martin@dbg400.net> > Sent by: midrange-l-bounces@midrange.com > 01/23/2003 03:03 PM > Please respond to Midrange Systems Technical Discussion > > To: Midrange Systems Technical Discussion > <midrange-l@midrange.com> > cc: > Fax to: > Subject: Re: 2664 Fax adapter at V5R1/2 > > > On Thursday 23 January 2003 5:45 pm, rob@dekko.com wrote: > > Granted, not supported and not functional are two different things, > > however the 'word' is > > http://www-1.ibm.com/servers/eserver/iseries/support/planning/v5r1hardw > >are.html > > I was reading that this afternoon and obviously missed the 2664 reference > :( > > > Now the V5R1 documentation recommended the 2761. However the V5R2 > > documentation yanks the 2761 and pushes the 2805 or 2806, (depending on > > your country). We have the 2805, and it does have a nasty tendency to > > fail, port by individual port. IBM hasn't given up yet and has sent me > > some testing equipment. > > http://www-1.ibm.com/servers/eserver/iseries/support/planning/v5r2hardw > >are.html > > We don't use it that heavily, in fact I think it languished there for a > year or so before a use was found for it, so we might be able to push it > off to another platform. We've got Zetafax running (*most* of the time) > on a W2k server, and I presume faxing can be done through Domino, so it > gives me some other options. It's probably cheaper than getting a new > card, and I guess we'd need to reconfigure our software to accomodate it > anyway. > > Cheers > > Regards, Martin > -- > martin@dbg400.net AIM/Gaim: DBG400dotNet http://www.dbg400.net /"\ > DBG/400 - DataBase Generation utilities - AS/400 / iSeries Open \ / > Source free test environment tools and others (file/spool/misc) X > Debian GNU/Linux | ASCII Ribbon Campaign against HTML mail & news / \ > > _______________________________________________ > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing > list > To post a message email: MIDRANGE-L@midrange.com > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l > or email: MIDRANGE-L-request@midrange.com > Before posting, please take a moment to review the archives > at http://archive.midrange.com/midrange-l. > > > > > ------------------------------ > > > Message: 2 > Date: Thu, 23 Jan 2003 14:37:05 -0600 > From: Vern Hamberg <vhamberg@centerfieldtechnology.com> > Subject: Re: iSeries Reporting Tools > > Are Excel, MS Access, or OpsNav in the running? Also, there is Surveyor > from Linoma Software. MS Query in an Excel setting gives you some good SQL > stuff, so does the CAE addin for Excel. > > HTH > > Vern > > At 09:33 AM 1/23/2003 -0800, you wrote: > >Folks - > > > >Would any of you have anecdotes/suggestions/etc. regarding the > >implementation of simplified reporting tools? > > > >More specifically, we are considering NGS-IQ, SEQUEL and BCD (ProGen > >Plus), and are very interested in ad-hoc inquiry clients. > > > > > ------------------------------ > > > Message: 3 > Date: Thu, 23 Jan 2003 14:38:43 -0600 > From: Vern Hamberg <vhamberg@centerfieldtechnology.com> > Subject: RE: Supporting Previous Page / Next Page in SQL? > > Right on, and the cursor has to be scrollable. There's a keyword on the > DECLARE CURSOR statement. > > Vern > > At 01:37 PM 1/23/2003 -0500, you wrote: > >I believe what you are looking for is a cursor. The SQL Programming with > >Host Languages book will give you all the gory details for the language of > >your choice, as long as it's one they included. > > > > > -----Original Message----- > > > From: Nathan M. Andelin [mailto:nandelin@RELATIONAL-DATA.COM] > > > Sent: Thursday, January 23, 2003 12:45 PM > > > To: midrange-l@midrange.com > > > Subject: Supporting Previous Page / Next Page in SQL? > > > > > > > > > When using SQL for database access, how does one support > > > "Previous Page" and > > > "Next Page" user interface controls while browsing a lengthy list of > > > records? Building some type of record level access logic > > > over the top of > > > SQL? If so, how are multiple users supported over the > > > Internet? Having a > > > separate result-set object for each user? > > > > > > Thanks, > > > > > > Nathan M. Andelin > > > www.relational-data.com > > > > > ------------------------------ > > > Message: 4 > Date: Thu, 23 Jan 2003 15:56:54 -0500 > From: "William A.\(Tony\) Corbett" <corbett@ASRESOURCES.COM> > Subject: Re: 2664 Fax adapter at V5R1/2 > > Martin, > I'm doing an upgrade next weekend for a customer who does use the 2664 cards > heavily. I've been trying to get the same questions answered, a couple > posts to this list. So, I called Supportline. I was told "it is not > supported, but it will work". Not 100% "feel good", but good enough for me. > > Luckily, after b*&@#ing for about a year, I got approval to order a 2761 > this morning. So, I may not have to worry about it. I will have to > reconfigure facsimile/400 though. > > In short, I think it'll work...... I'll sure be happy to see the 2664 go > anyway, it was not a good piece of hardware when it was new, much less now. > > Good luck. > > AS/Resources, Inc. > William A.(Tony) Corbett > IBM Certified Specialist - AS/400 Developer > http://www.asresources.com > corbett@asresources.com > 770-587-4812 (office) > 678-935-5006 (mobile) > fax: 404-663-4737 > > > > > > > ------------------------------ > > > Message: 5 > Date: Thu, 23 Jan 2003 16:11:45 -0500 > From: rob@dekko.com > Subject: Re: iSeries Reporting Tools > > Is anything truly a user based tool? > > Most of the battle is understanding the database. Think 3rd normal form > vs data access. Basically this is handled one of several ways. > - A set of join logical files, or SQL views are created to make this all > easy to access. > - Data is replicated in one big cluster, or data warehouse. > - All tools are manipulated by someone in IS who sets them up and locks > the user out of changing them. > - All tools are manipulated by someone in IS who sets them up. If they > want to make changes they copy and modify. > - Intelligent users are empowered, and trained, on how to query the data > directly. > > Classic example. Tie these BPCS files together: > ECH - order header > ECL - order line > ESN - order notes > IIM - Item master > RCM - customer master > and the list goes on and on... > > I tend to push the join logical, or view, to make this easier. > > If you don't solve this issue, how will the tool help you? > > Rob Berendt > -- > "They that can give up essential liberty to obtain a little temporary > safety deserve neither liberty nor safety." > Benjamin Franklin From rob@dekko.com Thu Jan 23 15:23:04 2003 > Received: from INTERNOTES2.dekko-1 (notes.dekko.com [208.16.99.7] (may be > forged)) > by linux.midrange.com (8.12.5/8.12.5) with ESMTP id h0NLMeon018543 > for <midrange-l@midrange.com>; Thu, 23 Jan 2003 15:23:00 -0600 > In-Reply-To: <PJEIJNHDPPHOBHCMMAANGELNDMAA.corbett@asresources.com> > To: Midrange Systems Technical Discussion <midrange-l@midrange.com> > MIME-Version: 1.0 > X-Mailer: Lotus Notes Release 6.0 September 26, 2002 > Message-ID: <OF06756E4A.2FBF6E84-ON05256CB7.00747B08-05256CB7.00756D2A@dekko-1> > From: rob@dekko.com > Date: Thu, 23 Jan 2003 16:23:28 -0500 > X-MIMETrack: Serialize by Router on INTERNOTES2/DEKKO(Release 5.0.10 |March > 22, 2002) at 01/23/2003 04:23:12 PM, > Serialize complete at 01/23/2003 04:23:12 PM > X-MailScanner: Found to be clean > Content-Type: text/plain; charset="US-ASCII" > X-Content-Filtered-By: Mailman/MimeDel 2.1 > Subject: Re: 2664 Fax adapter at V5R1/2 > X-BeenThere: midrange-l@midrange.com > X-Mailman-Version: 2.1 > Precedence: list > Reply-To: Midrange Systems Technical Discussion <midrange-l@midrange.com> > List-Id: Midrange Systems Technical Discussion <midrange-l.midrange.com> > List-Unsubscribe: <http://lists.midrange.com/mailman/listinfo.cgi/midrange-l>, > <mailto:midrange-l-request@midrange.com?subject=unsubscribe> > List-Archive: <http://archive.midrange.com/midrange-l> > List-Post: <mailto:midrange-l@midrange.com> > List-Help: <mailto:midrange-l-request@midrange.com?subject=help> > List-Subscribe: <http://lists.midrange.com/mailman/listinfo.cgi/midrange-l>, > <mailto:midrange-l-request@midrange.com?subject=subscribe> > > DO NOT ORDER THAT 2761!!!!!!!!!!!!!!!! > > http://www-1.ibm.com/servers/eserver/iseries/support/planning/v5r2hardware.h tml > The following hardware products or features that were previously supported > on the iSeries - AS/400 servers will not be supported on V5R2: > Non-Fax functions on #2761 / #4761 PCI Integrated Analog Modem. Replace > with #2805 PCI Quad Modem IOA or #2806 PCI Quad Modem IOA in Australia or > New Zealand > > http://www-1.ibm.com/servers/eserver/iseries/support/planning/futurehdwr.htm l > PCI Integrated Analog Modem, June 2002 > IBM plans for V5R2 to be the final release to support the #2761 and #4761 > PCI Integrated Analog Modem adapters for fax functions. IBM previously > announced that V5R1 was the final OS/400 release to support the use of the > #2761 and #4761 PCI Integrated Analog Modem adapters for non-fax > functions. > > Suggested Replacements: Replace with #2805 or #2806 (Australia / New > Zealand) PCI Quad Modem IOA. > > > Rob Berendt > -- > "They that can give up essential liberty to obtain a little temporary > safety deserve neither liberty nor safety." > Benjamin Franklin > > > > > "William A.\(Tony\) Corbett" <corbett@ASRESOURCES.COM> > Sent by: midrange-l-bounces@midrange.com > 01/23/2003 03:56 PM > Please respond to Midrange Systems Technical Discussion > > To: "MIDRANGE-L@midrange. com" <MIDRANGE-L@midrange.com> > cc: > Fax to: > Subject: Re: 2664 Fax adapter at V5R1/2 > > > Martin, > I'm doing an upgrade next weekend for a customer who does use the 2664 > cards > heavily. I've been trying to get the same questions answered, a couple > posts to this list. So, I called Supportline. I was told "it is not > supported, but it will work". Not 100% "feel good", but good enough for > me. > > Luckily, after b*&@#ing for about a year, I got approval to order a 2761 > this morning. So, I may not have to worry about it. I will have to > reconfigure facsimile/400 though. > > In short, I think it'll work...... I'll sure be happy to see the 2664 go > anyway, it was not a good piece of hardware when it was new, much less > now. > > Good luck. > > AS/Resources, Inc. > William A.(Tony) Corbett > IBM Certified Specialist - AS/400 Developer > http://www.asresources.com > corbett@asresources.com > 770-587-4812 (office) > 678-935-5006 (mobile) > fax: 404-663-4737 > > > > > _______________________________________________ > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing > list > To post a message email: MIDRANGE-L@midrange.com > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l > or email: MIDRANGE-L-request@midrange.com > Before posting, please take a moment to review the archives > at http://archive.midrange.com/midrange-l. > > > > > ------------------------------ > > > Message: 6 > Date: Thu, 23 Jan 2003 16:51:53 -0500 > From: "Metz, Zak" <Zak_Metz@G1.com> > > I'm getting CPF5090: "Unique access path problems prevent updates to member G1CMST." > > I understand why I'm getting this message, that the access path has not finished being rebuilt on this PF that was just restored that I'm trying to copy data into. What I don't understand is how I can wait. Anything besides DLYJOB and try, try again? > > Zak Metz > Group 1 Software > AS/400, iSeries 400 Platform Specialist > IBM Certified Specialist - IBM eServer iSeries 400 Technical Solutions Implementer > > > > ------------------------------ > > > Message: 7 > Date: Thu, 23 Jan 2003 16:00:20 -0600 > From: "Steve Landess" <steve_landess@hotmail.com> > Subject: Another CPYTOIMPF question - Someone please put me out of my > misery! > > Folks -This is driving me nuts! I have been playing around with the CPYTOIMPF command, trying to familiarize myself with its use. > > My AS/400 system is a 170, V5R1M0, TL02134. The CCSID of the system (QCCSID) is 37. The CCSID of the CUSMST file is 37. The CCSID of all character fields within CUSMST is 37. > > I have been trying to use the CPYTOIMPF command to copy the CUSMST file directly to a folder on my W2K server, like this: > > CPYTOIMPF FROMFILE(SJL001/CUSMST) TOSTMF('/QNTC/w2kserver/w2ksvr/Downloads/BUBBA/CUSMST') STMFCODPAG(*PCASCII) RCDDLM(*CRLF) > > This fails.... > > Here are the mesages in the job log: > > Ownership of object QCPEXTEMPS in QTEMP type *USRSPC changed. > File QACP007985 created in library QTEMP. > Member QACP007985 added to file QACP007985 in QTEMP. > Ownership of object QACP007985 in QTEMP type *USRSPC changed. > Ownership of object QACEXFLD12 in QTEMP type *USRSPC changed. > CCSID conversion could not be performed. > No records copied from file CUSMST in SJL001. > Object QACP007985 in QTEMP type *FILE deleted. > Copy command ended because of error. > > > If I do this: > > CPYTOIMPF FROMFILE(SJL001/CUSMST) TOSTMF('/SERVERS/CUSMST') MBROPT(*REPLACE) > RCDDLM(*CRLF) > > (where /SERVERS is a folder in the IFS) > > Then do this: > > CPY OBJ('/SERVERS/CUSMST') TODIR('/QNTC/w2kserver/w2ksvr/Downloads/BUBBA') FROMCCSID(1252) > TOCCSID(*CALC) REPLACE(*YES) > > It copies the file to the target directory, but when I view it (at least from the AS/400 by browsing it thru the IFS) it looks like garbage... > > What am I doing wrong? Can I _not_ copy the file directly from the AS/400 to the Windows folder? > > I have spent way too much time trying to figure this out...and I have searched both on Google and in Midrange-L, but haven't found any solutions... > > Steve Landess > Austin, Texas > (512) 423-0935 > > > ------------------------------ > > > Message: 8 > Date: Thu, 23 Jan 2003 17:01:46 -0500 > From: "Metz, Zak" <Zak_Metz@G1.com> > Subject: CPF5090 on CPYF > > I'm getting CPF5090: "Unique access path problems prevent updates to member G1CMST." > > I understand why I'm getting this message, that the access path has not finished being rebuilt on this PF that was just restored that I'm trying to copy data into. What I don't understand is how I can wait. Anything besides DLYJOB and try, try again? > > Zak Metz > Group 1 Software > AS/400, iSeries 400 Platform Specialist > IBM Certified Specialist - IBM eServer iSeries 400 Technical Solutions Implementer > > > > ------------------------------ > > > Message: 9 > Date: Thu, 23 Jan 2003 17:10:57 -0500 > From: rob@dekko.com > Subject: Re: CPF5090: "Unique access path problems prevent updates to > member > > No. > > You can write a program to copy monmsg and wait. > > I suggest that you save your access paths when you do your save. After > having to wait a week for our access paths to finish rebuilding, (many > years and processors ago), we started saving our access paths ever since. > Worth the time and additional tape. Versus being locked out of production > for a week. Luckily it was a development machine. > > Rob Berendt > -- > "They that can give up essential liberty to obtain a little temporary > safety deserve neither liberty nor safety." > Benjamin Franklin > > > > > "Metz, Zak" <Zak_Metz@G1.com> > Sent by: midrange-l-bounces@midrange.com > 01/23/2003 04:51 PM > Please respond to Midrange Systems Technical Discussion > > To: "Midrange Systems Technical Discussion" > <midrange-l@midrange.com> > cc: > Fax to: > Subject: > > > I'm getting CPF5090: "Unique access path problems prevent updates to > member G1CMST." > > I understand why I'm getting this message, that the access path has not > finished being rebuilt on this PF that was just restored that I'm trying > to copy data into. What I don't understand is how I can wait. Anything > besides DLYJOB and try, try again? > > Zak Metz > Group 1 Software > AS/400, iSeries 400 Platform Specialist > IBM Certified Specialist - IBM eServer iSeries 400 Technical Solutions > Implementer > > _______________________________________________ > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing > list > To post a message email: MIDRANGE-L@midrange.com > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l > or email: MIDRANGE-L-request@midrange.com > Before posting, please take a moment to review the archives > at http://archive.midrange.com/midrange-l. > > > > > ------------------------------ > > _______________________________________________ > This is the Midrange Systems Technical Discussion (MIDRANGE-L) digest list > To post a message email: MIDRANGE-L@midrange.com > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l > or email: MIDRANGE-L-request@midrange.com > Before posting, please take a moment to review the archives > at http://archive.midrange.com/midrange-l. > > > > End of MIDRANGE-L Digest, Vol 2, Issue 22 > *****************************************
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.