[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    Re: oracle to sas resource problem
From:       Mauro Morandin <mauro.morandin () MATRIX-ONLINE ! IT>
Date:       2001-03-30 21:17:04
[Download RAW message or body]

Hi Niels,

if you ask help on problems like this you should also include the SAS log,
otherwise we can only guess what might have happened to your SAS session.

I would test the "tables" macro variable and look what's inside.

Then I would run the program in interactive mode and see if it works.

Then I would take the
X setenv ORACLE_SID oracle;
out of the program. Place it in the shell program which invokes SAS.

It might well be that the X command doesn't work correctly in batch mode if
the process is launched from a scheduler.... because .... look at the log.

ciao
mauro.



Niels Stout wrote:

> Hi,
>
> At my current project we are are running sas81 in batchmode on a hpux
> (ux-11).
>
> One of the sas programs copies oracle tables from an oracle database to sas
> using the oracle libname engine.
>
> When i run this program the standard sheduling tool on this unix box goes
> down, something the people at the sheduling department aren't very happy
> about.
>
> I guess it must be some sort of resources problem? Has anyone experienced
> similar problems?
>
> Thanks,
>
> Niels

>

--
mauro morandin
SAS consultant
red hat certified engineer
--
matrix srl                           linux solution provider
via postioma di salvarosa 25b        tel +39-0423-724620
31033 castelfranco veneto (tv)       fax +39-0423-770798
http://www.matrix-online.it          info@matrix-online.it

[prev in list] [next in list] [prev in thread] [next in thread]