× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Yes, I forgot. V5R4. This looks like this might be it.


Thanks,

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jack Kingsley
Sent: Tuesday, October 26, 2010 12:43 PM
To: Midrange Systems Technical Discussion
Subject: Re: RmslUnlockSpaceLoc Invalid space location unlock request.

You don't mention what OS version but I found this and others.

http://www-01.ibm.com/support/docview.wss?uid=nas3bc517dd037631a0286257738005d97ce




On Tue, Oct 26, 2010 at 11:04 AM, Schutte, Michael D <
Michael_Schutte@xxxxxxxxxxxx> wrote:

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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.