|
midrange.com
I'll be out of the office Monday May 9, 2005 and Tuesday May 10, 2005. If this
is urgent please contact the helpdesk.
Helpdesk@xxxxxxxx
Lonnie
>>> midrange-l 05/06/05 17:24 >>>
Send MIDRANGE-L mailing list submissions to
midrange-l@xxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/midrange-l
or, via email, send a message with subject or body 'help' to
midrange-l-request@xxxxxxxxxxxx
You can reach the person managing the list at
midrange-l-owner@xxxxxxxxxxxx
When replying, please edit your Subject line so it is more specific
than "Re: Contents of MIDRANGE-L digest..."
Today's Topics:
1. RE: Normalization was Left AS/400 and Returned (rob@xxxxxxxxx)
2. RE: UDF problems in STRSQL (rob@xxxxxxxxx)
3. Re: Nested /copy in SQL RPG (rob@xxxxxxxxx)
4. Gumbo users (jns)
5. RE: Nested /copy in SQL RPG (Goodbar, Loyd (ETS - Water Valley))
6. firmware code on your 3582 tape drives (rob@xxxxxxxxx)
7. Control panel battery for a B20? (James H H Lampert)
8. Re: Control panel battery for a B20? (Scott Swaim)
9. Re: Control panel battery for a B20? (Keith Carpenter)
10. RE: Encapsulating external data access (was Normalization)
(Joe Pluta)
----------------------------------------------------------------------
message: 1
date: Fri, 6 May 2005 15:00:18 -0500
from: rob@xxxxxxxxx
subject: RE: Normalization was Left AS/400 and Returned
>From Excel, select the Data drop down, then select Transfer Data from
iSeries, providing they have the hook installed.
Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
"Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
05/06/2005 11:25 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
To
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
cc
Subject
RE: Normalization was Left AS/400 and Returned
How do they do it with ODBC?
Joe
> From: rob@xxxxxxxxx
>
> Been there, done that. However, how does the user get the results
into
> their Excel spreadsheet? Add cell formula to call a stored procedure?
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
------------------------------
message: 2
date: Fri, 6 May 2005 15:02:01 -0500
from: rob@xxxxxxxxx
subject: RE: UDF problems in STRSQL
I was going to suggest a QSQLSRC or some such animal. But your idea has a
lot of merit.
Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
"Mackie, Roger L. (Precision Press)" <RLMackie@xxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
05/06/2005 11:28 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc
Subject
RE: UDF problems in STRSQL
Your suggestion is definitely better than my initial thoughts. The
script can be named like the service program module source (perhaps
using a U suffix) in the same source file so it will be easier for more
people to find and use--definitely a winner.
Thanks,
Roger Mackie
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Friday, May 06, 2005 10:55
To: Midrange Systems Technical Discussion
Subject: RE: UDF problems in STRSQL
May I suggest storing the script used in a source physical file member
so that you retain a copy of it, and, can use RUNSQLSTM to recreate it?
Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
"Mackie, Roger L. (Precision Press)" <RLMackie@xxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
05/06/2005 10:24 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc
Subject
RE: UDF problems in STRSQL
For the archives:
I finally got a result set from both the production file and the test
file when I added PARAMETER STYLE GENERAL (the default is PARAMETER
STYLE SQL) to the CREATE FUNCTION script. Unfortunately, I don't see a
way to set that value on the parameter tab in the iSeries Navigator New
External Function window. Guess I'll just have to get used to building
the CREATE FUNCTION script myself. Or maybe I could 1) use the window,
2) create the UDF, 3) generate the SQL, 4) change the parameter, 5)
delete the UDF, and 6) run the script. Or even better, save a template
script that I change as necessary.
Thank you everyone. Hope this helps someone save two days + of
experimentation!
Roger Mackie
<snip>
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
------------------------------
message: 3
date: Fri, 6 May 2005 15:04:28 -0500
from: rob@xxxxxxxxx
subject: Re: Nested /copy in SQL RPG
Yes.
The workaround in earlier releases is to use /include. In fact the only
reason the RPG compiler people came up with /include was to get around the
SQL precompiler limitation.
Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
"Goodbar, Loyd (ETS - Water Valley)" <LGoodbar@xxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
05/06/2005 01:35 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc
Subject
Nested /copy in SQL RPG
Has the nested /copy limitation for SQLRPGLE programs been fixed in V5R3?
It's a d**ned annoying limitation, being that the precompiler already
changes the source in QTEMP.
Loyd Goodbar
Senior programmer/analyst
BorgWarner
E/TS Water Valley
662-473-5713
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
------------------------------
message: 4
date: Fri, 6 May 2005 13:25:28 -0700 (PDT)
from: jns <JNS@xxxxxxxxxx>
subject: Gumbo users
Hello, I know there are alot of shops using Gumbo products. We use Report
Manager extensively. If there is anyone who wants to share tips and techniques
used in programming, please contact.
------------------------------
message: 5
date: Fri, 6 May 2005 15:24:33 -0500
from: "Goodbar, Loyd (ETS - Water Valley)" <LGoodbar@xxxxxxxxxxxxxx>
subject: RE: Nested /copy in SQL RPG
Barbara, Rob, thanks! The only part of the RPG manual I've looked at
recently is the bifs and opcodes for freeform. Didn't even look at the front
of the book where /copy and /include are described.
Loyd Goodbar
Senior programmer/analyst
BorgWarner
E/TS Water Valley
662-473-5713
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Friday, May 06, 2005 15:04
To: Midrange Systems Technical Discussion
Subject: Re: Nested /copy in SQL RPG
Yes.
The workaround in earlier releases is to use /include. In fact the only
reason the RPG compiler people came up with /include was to get around the
SQL precompiler limitation.
Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
"Goodbar, Loyd (ETS - Water Valley)" <LGoodbar@xxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
05/06/2005 01:35 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc
Subject
Nested /copy in SQL RPG
Has the nested /copy limitation for SQLRPGLE programs been fixed in V5R3?
It's a d**ned annoying limitation, being that the precompiler already
changes the source in QTEMP.
Loyd Goodbar
Senior programmer/analyst
BorgWarner
E/TS Water Valley
662-473-5713
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
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) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
------------------------------
message: 6
date: Fri, 6 May 2005 15:43:40 -0500
from: rob@xxxxxxxxx
subject: firmware code on your 3582 tape drives
If you have nothing better to do, you could update your firmware code on
your 3582 tape drives. This is not done via ptf's from your host machine.
There are three area's to update:
- Library firmware
- Drive firmware
- RMU firmware
Library firmware is equivalent to pushing these sequence of buttons on
your 3582: Status, Firmware, Application.
The other two are in the same area, but they don't rename them like
Library vs Application does.
http://www-1.ibm.com/support/docview.wss?rs=590&context=STCB7FE&dc=D420&q1=ssg1*&uid=ssg1S4000152&loc=en_US&cs=utf-8&lang=en
Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
------------------------------
message: 7
date: Fri, 06 May 2005 14:05:19 -0700
from: "James H H Lampert" <jamesl@xxxxxxxxxxx>
subject: Control panel battery for a B20?
Does anybody know the specs for a B20 control panel
battery?
We've fired up and cleaned out our old B20, in hopes that
somebody will give it a good home, and remarkably, the
only thing that's gone bad in it is the control panel
battery. (does the phrase, "built like a tank" mean
anything to you?)Obviously, anybody who actually intends
to put the thing back into service (rather than use it as
a "hangar queen") will need to replace it.
It's apparently a NiCad, and it's the kind that has the
cells in a heatshrink tube, with a short cable coming out
the end.
--
JHHL
------------------------------
message: 8
date: Fri, 6 May 2005 16:12:09 -0500
from: "Scott Swaim" <scott@xxxxxxxxxxxxxxxx>
subject: Re: Control panel battery for a B20?
Here in TX we have a store called Batteries Plus. I took the same control
panel batter to them and they custom built me one for around $50. that was
approx 5 yrs ago. if you have the same kind of store where you are located
you can do the same thing.
Scott Swaim
Quality Corps, Inc.
----- Original Message -----
From: "James H H Lampert" <jamesl@xxxxxxxxxxx>
To: <midrange-l@xxxxxxxxxxxx>
Sent: Friday, May 06, 2005 4:05 PM
Subject: Control panel battery for a B20?
> Does anybody know the specs for a B20 control panel battery?
>
> We've fired up and cleaned out our old B20, in hopes that somebody will
> give it a good home, and remarkably, the only thing that's gone bad in it
> is the control panel battery. (does the phrase, "built like a tank" mean
> anything to you?)Obviously, anybody who actually intends to put the thing
> back into service (rather than use it as a "hangar queen") will need to
> replace it.
>
> It's apparently a NiCad, and it's the kind that has the cells in a
> heatshrink tube, with a short cable coming out the end.
>
> --
> JHHL
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
------------------------------
message: 9
date: Fri, 06 May 2005 16:14:53 -0700
from: Keith Carpenter <carpcon@xxxxxxx>
subject: Re: Control panel battery for a B20?
3.6volt nicad
The 3 cells are just "short" length AA nicad batteries.
You can find them online or possibly a local electronics store.
You might try using standard size AA or AAA cells in a 3 cell battery
holder. It will be cheaper and also easier the next time if you ever
have to replace them again.
Keith
> Does anybody know the specs for a B20 control panel battery?
>
> We've fired up and cleaned out our old B20, in hopes that somebody will
> give it a good home, and remarkably, the only thing that's gone bad in
> it is the control panel battery. (does the phrase, "built like a tank"
> mean anything to you?)Obviously, anybody who actually intends to put the
> thing back into service (rather than use it as a "hangar queen") will
> need to replace it.
>
> It's apparently a NiCad, and it's the kind that has the cells in a
> heatshrink tube, with a short cable coming out the end.
>
> --
> JHHL
------------------------------
message: 10
date: Fri, 6 May 2005 18:26:57 -0500
from: "Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>
subject: RE: Encapsulating external data access (was Normalization)
Sorry, I thought you were familiar with ODBC access from Excel. ODBC is
after all the MS standard; you can access ODBC tables from Excel, and
you can also access Excel spreadsheets as ODBC data.
To learn about importing data, just use the help documentation for
Excel. Go into the Contents, select "Importing Data" and then "Setting
up Microsoft Query and Data Sources". This chapter deals with reading
ODBC data into Excel. I haven't done much with this, but I think you're
looking for an "external data range".
Joe
> From: rob@xxxxxxxxx
>
> >From Excel, select the Data drop down, then select Transfer Data from
> iSeries, providing they have the hook installed.
------------------------------
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) digest list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
End of MIDRANGE-L Digest, Vol 4, Issue 905
******************************************
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.
