Re: SPOOL command in same script for Windows & UNIX clients
From: Stephen Haunch <smhaunch_at_mac.com>
Date: Sat, 17 May 2003 00:12:40 +0100
Message-ID: <BAEB2EF8.1BB%smhaunch_at_mac.com>
>> Hi,
>>
>> I have SQL*Plus scripts which run primarily through the Windows SQL*Plus
>> client, these scripts contain SPOOL commands like this: -
>>
>> SPOOL Output\uunl-135-&reportdate..txt
>>
>> If I were to run this script using a UNIX SQL*Plus client the SPOOL command
>> shown above would cause problems because it should be: -
>>
>> SPOOL Output/uunl-135-&reportdate..txt
>>
>> Is there a way to make SQL*Plus figure out which type of directory delimiter
>> to use, i.e. \ for Windows and / for UNIX?
>>
>> Any help would be appreciated!
>>
>> Steve
Date: Sat, 17 May 2003 00:12:40 +0100
Message-ID: <BAEB2EF8.1BB%smhaunch_at_mac.com>
And neither will you find \adirectory\asubdirectory\ on a Windows machine which is precisely the point of my question.
[Quoted] I have scripts which need to be run by both UNIX and Windows SQL&Plus clients, using a common directory directory structure under their respective [Quoted] "home" directories and the difference between \ and / on the respective file systems is the issue.
Another poster has suggested passing the output directory as a parameter which is a good idea as this can be determined by the application that starts SQL&Plus in each environment.
On 16/5/03 4:45 pm, in article 3EC507AB.4A9287F1_at_exxesolutions.com, "Daniel Morgan" <damorgan_at_exxesolutions.com> wrote:
> Stephen Haunch wrote: >
>> Hi,
>>
>> I have SQL*Plus scripts which run primarily through the Windows SQL*Plus
>> client, these scripts contain SPOOL commands like this: -
>>
>> SPOOL Output\uunl-135-&reportdate..txt
>>
>> If I were to run this script using a UNIX SQL*Plus client the SPOOL command
>> shown above would cause problems because it should be: -
>>
>> SPOOL Output/uunl-135-&reportdate..txt
>>
>> Is there a way to make SQL*Plus figure out which type of directory delimiter
>> to use, i.e. \ for Windows and / for UNIX?
>>
>> Any help would be appreciated!
>>
>> Steve
> > No. > > And it would be meaningless to do so as you won't find c:\ anything on a UNIX > machine. > -- > Daniel Morgan > http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp > damorgan_at_x.washington.edu > (replace 'x' with a 'u' to reply) > >Received on Sat May 17 2003 - 01:12:40 CEST