Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Simple isql question

3 posts in General Discussion Last posting was on 2004-07-28 14:53:00.0Z
Jelly_boy Posted on 2004-07-27 13:57:17.0Z
Sender: 2bbe.41065e92.1804289383@sybase.com
From: Jelly_boy
Newsgroups: ianywhere.public.general
Subject: Simple isql question
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41065f3d.2bce.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 27 Jul 2004 06:57:17 -0700
X-Trace: forums-1-dub 1090936637 10.22.241.41 (27 Jul 2004 06:57:17 -0700)
X-Original-Trace: 27 Jul 2004 06:57:17 -0700, 10.22.241.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3321
Article PK: 7229

OK. This seems simple but I can't find a solution. All I
want to do is start up isql and be able to set a home path
for the session. So, lets say I start isql from c:\cpdb but
I want to be able to issue some type of statement that would
change my default home directory to c:\bin. So, now anytime
I issue a statement like "output to customers.txt", this
file would be created at c:\bin\customers.txt. Not
c:\cpdb\customers.txt

Thanks,
Jelly_boy


Stephen Rice Posted on 2004-07-27 21:19:25.0Z
Newsgroups: ianywhere.public.general
Subject: Re: Simple isql question
From: Stephen Rice <srice_nospam@ianywhere.com>
References: <41065f3d.2bce.1681692777@sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns9533AEFFF43F9sricenospamianywhere@10.22.241.106>
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: srice-pc1.sybase.com
X-Original-NNTP-Posting-Host: srice-pc1.sybase.com
Date: 27 Jul 2004 14:19:25 -0700
X-Trace: forums-1-dub 1090963165 10.25.100.134 (27 Jul 2004 14:19:25 -0700)
X-Original-Trace: 27 Jul 2004 14:19:25 -0700, srice-pc1.sybase.com
Lines: 29
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3333
Article PK: 7241


Jelly_boy wrote in news:41065f3d.2bce.1681692777@sybase.com:

> OK. This seems simple but I can't find a solution. All I
> want to do is start up isql and be able to set a home path
> for the session. So, lets say I start isql from c:\cpdb but
> I want to be able to issue some type of statement that would
> change my default home directory to c:\bin. So, now anytime
> I issue a statement like "output to customers.txt", this
> file would be created at c:\bin\customers.txt. Not
> c:\cpdb\customers.txt
>
> Thanks,
> Jelly_boy
>

AFAIK there is no way to do this after you have started dbisql

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

- Please Post-
Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
Developer Community at www.ianywhere.com/developer


Rick Blythe Posted on 2004-07-28 14:53:00.0Z
Reply-To: "Rick Blythe" <nospam__rickb@ianywhere.com>
From: "Rick Blythe" <nospam__rickb@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <41065f3d.2bce.1681692777@sybase.com>
Subject: Re: Simple isql question
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: rickb-pc.sybase.com
X-Original-NNTP-Posting-Host: rickb-pc.sybase.com
Message-ID: <4107bdcc$1@forums-1-dub>
Date: 28 Jul 2004 07:53:00 -0700
X-Trace: forums-1-dub 1091026380 10.25.100.215 (28 Jul 2004 07:53:00 -0700)
X-Original-Trace: 28 Jul 2004 07:53:00 -0700, rickb-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3336
Article PK: 7250

I just tried changing the "Start in" directory for my dbisql shortcut and
that seemed to work.

Of course, YMMV

Rick


<Jelly_boy> wrote in message news:41065f3d.2bce.1681692777@sybase.com...
OK. This seems simple but I can't find a solution. All I
want to do is start up isql and be able to set a home path
for the session. So, lets say I start isql from c:\cpdb but
I want to be able to issue some type of statement that would
change my default home directory to c:\bin. So, now anytime
I issue a statement like "output to customers.txt", this
file would be created at c:\bin\customers.txt. Not
c:\cpdb\customers.txt

Thanks,
Jelly_boy