|
A search on this just brings up another person asking the same question but
they didn't get an answer. So I was wondering if anyone here knows what's
going on.
I've created the same function twice that both return a table. The first
one you can pass company, restaurant and week ending date to return all
items that were purchased on during the week. The second definition of the
function you can pass in item number and a table of that item will be
returned. I've also done this with other functions, item adjustments,
transfers, etc. I've done this because the same query was being used over
and over again and I wanted put the query in one place and every other
program can call this function.
I'm calling this function by doing the following.
Exec SQL
SELECT ITEM, PURCHASESQTY, PAIDOUTSQTY
INTO :PURCHASEQTY, :PAIDOUTQTY
FROM TABLE (
GETIMSPURCHASES(:INVCONO,:INVSTK,:pWEDate,:INVITM))
AS X;
OR (without item number)
Exec SQL
SELECT ITEM, PURCHASESQTY, PAIDOUTSQTY
INTO :PURCHASEQTY, :PAIDOUTQTY
FROM TABLE (
GETIMSPURCHASES(:INVCONO,:INVSTK,:pWEDate))
AS X;
Anyway, this is working I'm getting everything I need. However, when the
program finishes, I'm getting QPSRVDMP spool file for each of the functions
that I'm doing this with and this program RmslUnlockSpaceLoc producing this
error Invalid space location unlock request.
I suppose I could have just created a view instead of a function. I don't
know if I have any good reason as to create a function rather than a view.
Does a view save the access path used to query the files involved? The
thought is to allow a .net application to call the same function.
Michael Schutte
Programmer Analyst
(w) 614-492-7419
[emailimage]
Join BE Mail now and receive a coupon for a BOGO Breakfast in your Inbox!
You can also look forward to exclusive monthly offers from Bob Evans as well
as insider news about our restaurants, grocery food products, recipes, chefs
and local community activities. For more information, visit
www.bobevans.com/bemail<http://www.bobevans.com/bemail>
--
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.
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.
midrange.com
