Re: MIDRANGE-L Digest, Vol 4, Issue 905

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