Date:         Tue, 19 Feb 2002 09:19:47 -0500
Reply-To:     Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Subject:      Re: AF Problem still

On Tue, 19 Feb 2002 10:36:48 +0000, Graeme Kirton <gkirton@FILCS.COM> wrote:

>---------------------- Forwarded by Graeme Kirton/Filcs on 19/02/2002 10:32
>---------------------------
>
>
>"Richard A. DeVenezia" <radevenz@IX.NETCOM.COM> on 18/02/2002 18:40:10
>
>Please respond to "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
>
>To:   SAS-L@LISTSERV.UGA.EDU
>cc:    (bcc: Graeme Kirton/Filcs)
>
>Subject:  Re: AF Problem still
>
>
>
>
>gkirton@FILCS.COM (Graeme Kirton) wrote in message
>news:<80256B64.00564F81.00@fil-notes01.filcs.com>...
>> My passing the parms now works, thanks ALL.  Symget did the trick.  Now
my
>code
>> only WORKS locally.  I need to rsubmit it, but when I do I get
>this............
>> Bold is line.  Any ideas, we've not got AF licenced on the server, its
local
>> could this be it. If so Im gunna have to do loads of extra work.......
>>
>> NOTE: Remote submit to SERVER commencing.
>> 2807     %Let checkfile = Testrun;
>> 2808     %Let access = U;
>> 2809     %let typeaccess = 2;
>> 2810      proc display cat=getad3.development.check_base.SCL /*batch*/;
>> 2811      run;
>>
>> *** Line 38: [ERROR:  #64]  Calling function WHERE.  Invalid dataset id
>> Arguments passed to WHERE:
>>   1 lockingid = 0
>>   2 (Character Expression $T4) = 'DATASET="Testrun" AND LEVEL IN
("U","R")'
>> Program returning prematurely at line 38
>> AF Program: GETAD3.DEVELOPMENT.CHECK_BASE.SCL
>> NOTE: PROCEDURE DISPLAY used:
>>       real time           0.00 seconds
>>       cpu time            0.00 seconds
>>
>> /*****************************************
>> CODE
>>
>> RDATESET:
>>
>>
>>       lockingid=open("SHRadmin.locking(write=&a)",'U');
>>
>>
>>... snip ...
>
>>The table did not open because lockingid was assigned zero.
>>The table did not open because the write password is the value of the
>>macro variable A at compile-time.
>>If that macro variable does not exist or has a value that is an
>>invalid write password for table SHRadmin.locking, then you will never
>>be able to open the table.
>>
>>If the value of macro variable A at run-time is supposed to be the
>>right (pun intended) write password, then your open statement should
>>look like:
>>
>>lockingid = open ("SHRadmin.locking(write=" || symget("A") || ")",
>>'U');
>>
>
>I changed this like you said Richard and did what others say but it still
>doesn't seem to open the dataset, when I Rsubmit ONLY.  The library
SHRADMIN is
>setup with RLS through the share server SHR1, if I do properties on the
>shradmin.locking dataset general, it says the DATASET is REMOTE accessed
through
>SERVER.SHR1.  Doesn't seem to see it correctly.... stuck.
>
>Thanx GK
>
>
>
>___________________________________________________________________________
_________________________________
>
>Disclaimer
>
>This email may contain privileged/confidential information and/or copyright
>material.  It is intended only for the use of the person(s) to whom it is
>addressed and any unauthorised use may be unlawful.  If you receive this
email
>by mistake, please advise the sender immediately by using the reply
facility on
>your email software and delete the material from your computer.
>
>Opinions, conclusions and other information in this email that do not
relate to
>the official business of this organisation shall be understood as neither
given
>nor endorsed by it.
>
>If this message forms part of a quotation, the quotation is an invitation
to
>treat only.  No contract subsists until Filtronic Plc (or its subsidiary
>companies) accepts your order.  Acceptance of your order is made subject
to our
>standard Terms and Conditions.
>
>Website Address http://www.filtronic.com


Ok, the problem is the following: you allocate the library SERVER from PC
with RLS. Then you come on another way (via RSUBMIT) and want to open that
library (or a member in that library) in update mode. That seem to be not
possible.
I do not know the logic of you programs. Is it really necessary to use RLS
to allocate that library? Taht is only necessary if you are working on PC
and want to use that library as if it is a local PC library. If you do not
work on PC (rsubmit means: execution on the remote system, NOT in local
environment), why don't you allocate the library with the libname function
on the remote system?

If you have to work in both modes for some reasons, don't mix them! E.g.
you could allocate it  on the remote system, make your updates and
deallocate it afterwords (libname clear) . Then you allocate it on PC with
RLS and continue working on PC.
Maybe you can do all what you want on the PC: Your Library is allocated on
PC. So start the SCL to do whatever ... ON PC (!!!) NOT BY RSUB, but only
with SUBMIT!!!!! Why is it necessary to RSUB it? For what reason? And if
you must RSUB something, why you allocate it by RLS? Just allocate it
remote by RSUBMIT and do all the rest also on your remote system!