Re: MIDRANGE-L Digest, Vol 2, Issue 22

----- 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
> *****************************************