RE: Normalization was Left AS/400 and Returned

Been there, done that.  However, how does the user get the results into 
their Excel spreadsheet?  Add cell formula to call a stored procedure?

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 10:34 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






I'm pretty sure you return results sets as MODS, Rob.  If I remember
correctly, "Who Knew You Could Do That In RPG" (SG24-5402-00) has an
example in it.

Joe

> From: rob@xxxxxxxxx
> 
> Good points.
> 
> Many of the calculations would be better served by a nice SQL view
that
> includes UDF's to do things like calculating BPCS on hand.
> 
> How would a user, using an Excel spreadsheet say give me all the
shipping
> going out today using 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.