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.

Interactive SQL -Automation?

15 posts in General Discussion Last posting was on 2006-02-17 16:07:08.0Z
James Shan Posted on 2006-02-09 18:14:27.0Z
Sender: 647b.43eb827f.1804289383@sybase.com
From: James Shan
Newsgroups: ianywhere.public.general
Subject: Interactive SQL -Automation?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <43eb8683.6491.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Feb 2006 10:14:27 -0800
X-Trace: forums-1-dub 1139508867 10.22.241.41 (9 Feb 2006 10:14:27 -0800)
X-Original-Trace: 9 Feb 2006 10:14:27 -0800, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5176
Article PK: 1237

I am using Interactive SQL. How to automatically start a
session to run a query.

Background: I am running a large query everyday. It takes 4
hours to complete. I have to waste the whole morning before
I can do further query downstream. I hope to automaticall
start a session at 5 AM, so that when I come info the
office, the first query will be done.

Any suggestion will be helpful. Thanks in advance.


Joshua Savill Posted on 2006-02-09 18:28:53.0Z
From: "Joshua Savill" <nospam_jsavill@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <43eb8683.6491.1681692777@sybase.com>
Subject: Re: Interactive SQL -Automation?
Lines: 38
Organization: iAnywhere Solutions
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: jsavill-pc.sybase.com
X-Original-NNTP-Posting-Host: jsavill-pc.sybase.com
Message-ID: <43eb89e5$1@forums-1-dub>
Date: 9 Feb 2006 10:28:53 -0800
X-Trace: forums-1-dub 1139509733 10.25.98.205 (9 Feb 2006 10:28:53 -0800)
X-Original-Trace: 9 Feb 2006 10:28:53 -0800, jsavill-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5177
Article PK: 1238

James,

You can have this query execute in a Stored Procedure that is called from an
Event. The Event can be triggered based on the server time.

ASA SQL Reference
SQL Statements
CREATE EVENT statement

Online:
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/dbrfen9/00000361.htm

ASA SQL Reference
SQL Statements
CREATE PROCEDURE statement

Online:
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/dbrfen9/00000367.htm

Cheers,
--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

<James Shan> wrote in message news:43eb8683.6491.1681692777@sybase.com...
>I am using Interactive SQL. How to automatically start a
> session to run a query.
>
> Background: I am running a large query everyday. It takes 4
> hours to complete. I have to waste the whole morning before
> I can do further query downstream. I hope to automaticall
> start a session at 5 AM, so that when I come info the
> office, the first query will be done.
>
> Any suggestion will be helpful. Thanks in advance.


Breck Carter [TeamSybase] Posted on 2006-02-09 18:57:44.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Interactive SQL -Automation?
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <580nu1hjp7ep5ombva9bgm0t549d9gnem6@4ax.com>
References: <43eb8683.6491.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
X-Original-Trace: 9 Feb 2006 09:53:35 -0800, bcarter.sentex.ca
Lines: 28
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 9 Feb 2006 09:53:37 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 9 Feb 2006 10:57:44 -0800
X-Trace: forums-1-dub 1139511464 10.22.108.75 (9 Feb 2006 10:57:44 -0800)
X-Original-Trace: 9 Feb 2006 10:57:44 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5178
Article PK: 1239

You can also run ISQL in "batch mode" by supplying a command file
name; here is a template .BAT file

"%ASANY9%\win32\dbisql.exe" -c "..." READ whatever.sql

You can schedule *that* via Windows - System Tools - Scheduled Tasks

Breck

On 9 Feb 2006 10:14:27 -0800, James Shan wrote:

>I am using Interactive SQL. How to automatically start a
>session to run a query.
>
>Background: I am running a large query everyday. It takes 4
>hours to complete. I have to waste the whole morning before
>I can do further query downstream. I hope to automaticall
>start a session at 5 AM, so that when I come info the
>office, the first query will be done.
>
>Any suggestion will be helpful. Thanks in advance.

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com


James Shan Posted on 2006-02-15 20:22:41.0Z
Sender: 7d23.43f37d9a.1804289383@sybase.com
From: James Shan
Newsgroups: ianywhere.public.general
Subject: Re: Interactive SQL -Automation? (Additional Question)
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <43f37e64.7d28.1681692777@sybase.com>
References: <580nu1hjp7ep5ombva9bgm0t549d9gnem6@4ax.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 15 Feb 2006 11:17:56 -0800, 10.22.241.42
Lines: 41
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 15 Feb 2006 11:17:58 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 15 Feb 2006 12:22:41 -0800
X-Trace: forums-1-dub 1140034961 10.22.108.75 (15 Feb 2006 12:22:41 -0800)
X-Original-Trace: 15 Feb 2006 12:22:41 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5181
Article PK: 1240

Thanks for the suggestion. I created a BAT file and started
a session. But one more problem. Once an Interactive SQL
session starts, I usually have to manually enter userid and
password, in order to connect to the remote Sybase database.

How do I incorporate my userid and password into a BAT file?
Thanks!

> You can also run ISQL in "batch mode" by supplying a
> command file name; here is a template .BAT file
>
> "%ASANY9%\win32\dbisql.exe" -c "..." READ whatever.sql
>
> You can schedule *that* via Windows - System Tools -
> Scheduled Tasks
>
> Breck
>
> On 9 Feb 2006 10:14:27 -0800, James Shan wrote:
>
> >I am using Interactive SQL. How to automatically start
> a >session to run a query.
> >
> >Background: I am running a large query everyday. It takes
> 4 >hours to complete. I have to waste the whole morning
> before >I can do further query downstream. I hope to
> automaticall >start a session at 5 AM, so that when I come
> info the >office, the first query will be done.
> >
> >Any suggestion will be helpful. Thanks in advance.
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
>
http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com


Christopher Harn Posted on 2006-02-15 21:05:32.0Z
From: "Christopher Harn" <harncw@hotmail.com>
Newsgroups: ianywhere.public.general
References: <580nu1hjp7ep5ombva9bgm0t549d9gnem6@4ax.com> <43f37e64.7d28.1681692777@sybase.com>
Subject: Re: Interactive SQL -Automation? (Additional Question)
Lines: 87
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
X-Original-NNTP-Posting-Host: 64-191-146-59.service.qx.net
Message-ID: <43f38870@forums-2-dub>
X-Original-Trace: 15 Feb 2006 12:00:48 -0800, 64-191-146-59.service.qx.net
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 15 Feb 2006 12:00:48 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 15 Feb 2006 13:05:32 -0800
X-Trace: forums-1-dub 1140037532 10.22.108.75 (15 Feb 2006 13:05:32 -0800)
X-Original-Trace: 15 Feb 2006 13:05:32 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5182
Article PK: 1241

> How do I incorporate my userid and password into a BAT file?


ASA Database Administration Guide
Connecting to a Database
Connection parameters

http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0901/en/html/dbdaen9/00000092.htm

"%ASANY9%\win32\dbisql.exe" -c "uid=dba;pwd=sql;" READ whatever.sql

Here I take in the the dba password as a parameter to a batch script used to
copy tables from one DB to another.

@echo off
if %1. == . goto done
if %2. == . goto done
if %3. == . goto done
if %4. == . goto done
if %5. == . goto done
set dbaPassword=%~1
set oldDbDirectory=%~2
set newDbDirectory=%~3
set dbName=%~4
set tableName=%~5

echo.
@echo on
dbunload -t %tableName% -d -y -c
"uid=dba;pwd=%dbaPassword%;dbf=%oldDbDirectory%\%dbName%.db" Data
dbisql -c "uid=dba;pwd=%dbaPassword%;dbf=%newDbDirectory%\%dbName%" read
reload.sql
@echo off

rmdir /s /q data
del /q /f reload.sql

:done


Hope this helps!

<James Shan> wrote in message news:43f37e64.7d28.1681692777@sybase.com...

> Thanks for the suggestion. I created a BAT file and started
> a session. But one more problem. Once an Interactive SQL
> session starts, I usually have to manually enter userid and
> password, in order to connect to the remote Sybase database.
>
> How do I incorporate my userid and password into a BAT file?
> Thanks!
>
>
>
>> You can also run ISQL in "batch mode" by supplying a
>> command file name; here is a template .BAT file
>>
>> "%ASANY9%\win32\dbisql.exe" -c "..." READ whatever.sql
>>
>> You can schedule *that* via Windows - System Tools -
>> Scheduled Tasks
>>
>> Breck
>>
>> On 9 Feb 2006 10:14:27 -0800, James Shan wrote:
>>
>> >I am using Interactive SQL. How to automatically start
>> a >session to run a query.
>> >
>> >Background: I am running a large query everyday. It takes
>> 4 >hours to complete. I have to waste the whole morning
>> before >I can do further query downstream. I hope to
>> automaticall >start a session at 5 AM, so that when I come
>> info the >office, the first query will be done.
>> >
>> >Any suggestion will be helpful. Thanks in advance.
>>
>> --
>> SQL Anywhere Studio 9 Developer's Guide
>> Buy the book:
>>
> http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
>> bcarter@risingroad.com
>> RisingRoad SQL Anywhere and MobiLink Professional Services
>> www.risingroad.com


James Shan Posted on 2006-02-15 23:08:20.0Z
Sender: 5abf.43f39658.1804289383@sybase.com
From: James Shan
Newsgroups: ianywhere.public.general
Subject: Re: Interactive SQL -Automation? (Additional Question)
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <43f3b464.5bd3.1681692777@sybase.com>
References: <43f38870@forums-2-dub>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 15 Feb 2006 15:08:20 -0800
X-Trace: forums-1-dub 1140044900 10.22.241.41 (15 Feb 2006 15:08:20 -0800)
X-Original-Trace: 15 Feb 2006 15:08:20 -0800, 10.22.241.41
Lines: 106
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5184
Article PK: 1243

I can pass userid and password requirement automatically,
and read the sql file. BUT I could not execute it. Below
is my BAT file. Can anyone provide some suggestion?
Thanks!

In Window, my BAT file looks like
"C:\Program Files\Sybase\ASIQ-12_6\win32\dbisqlg.exe" -c
"FILEDSN=C:\Program Files\Common Files\ODBC\Data
Sources\iqax.dsn;UID=xxx;PWD=xxx" read "c:\testing.sql"

> How do I incorporate my userid and password into a BAT
> file?
>
>
> ASA Database Administration Guide
> Connecting to a Database
> Connection parameters
>
>
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0901/en/html/dbdaen9/00000092.htm
>
> "%ASANY9%\win32\dbisql.exe" -c "uid=dba;pwd=sql;" READ
> whatever.sql
>
> Here I take in the the dba password as a parameter to a
> batch script used to copy tables from one DB to another.
>
> @echo off
> if %1. == . goto done
> if %2. == . goto done
> if %3. == . goto done
> if %4. == . goto done
> if %5. == . goto done
> set dbaPassword=%~1
> set oldDbDirectory=%~2
> set newDbDirectory=%~3
> set dbName=%~4
> set tableName=%~5
>
> echo.
> @echo on
> dbunload -t %tableName% -d -y -c
> "uid=dba;pwd=ÛaPassword%
> ;dbf=%oldDbDirectory%\ÛName%.db" Data dbisql -c
"uid=dba
> ;pwd=ÛaPassword%;dbf=%newDbDirectory%\ÛName%" read
> reload.sql @echo off
>
> rmdir /s /q data
> del /q /f reload.sql
>
> :done
>
>
> Hope this helps!
>
> <James Shan> wrote in message
> news:43f37e64.7d28.1681692777@sybase.com...
>
> > Thanks for the suggestion. I created a BAT file and
> > started a session. But one more problem. Once an
> > Interactive SQL session starts, I usually have to
> > manually enter userid and password, in order to connect
> to the remote Sybase database. >
> > How do I incorporate my userid and password into a BAT
> > file? Thanks!
> >
> >
> >
> >> You can also run ISQL in "batch mode" by supplying a
> >> command file name; here is a template .BAT file
> >>
> >> "%ASANY9%\win32\dbisql.exe" -c "..." READ whatever.sql
> >>
> >> You can schedule *that* via Windows - System Tools -
> >> Scheduled Tasks
> >>
> >> Breck
> >>
> >> On 9 Feb 2006 10:14:27 -0800, James Shan wrote:
> >>
> >> >I am using Interactive SQL. How to automatically
> start >> a >session to run a query.
> >> >
> >> >Background: I am running a large query everyday. It
> takes >> 4 >hours to complete. I have to waste the whole
> morning >> before >I can do further query downstream. I
> hope to >> automaticall >start a session at 5 AM, so that
> when I come >> info the >office, the first query will be
> done. >> >
> >> >Any suggestion will be helpful. Thanks in advance.
> >>
> >> --
> >> SQL Anywhere Studio 9 Developer's Guide
> >> Buy the book:
> >>
> >
>
http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
> >> bcarter@risingroad.com
> >> RisingRoad SQL Anywhere and MobiLink Professional
> Services >> www.risingroad.com
>
>


Breck Carter [TeamSybase] Posted on 2006-02-15 23:13:06.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Interactive SQL -Automation? (Additional Question)
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <bi97v1dmdj956s604t27t3nhpu9dkdbqm9@4ax.com>
References: <43f38870@forums-2-dub> <43f3b464.5bd3.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 15 Feb 2006 15:13:06 -0800
X-Trace: forums-1-dub 1140045186 64.7.134.118 (15 Feb 2006 15:13:06 -0800)
X-Original-Trace: 15 Feb 2006 15:13:06 -0800, bcarter.sentex.ca
Lines: 117
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5186
Article PK: 1245

How do you know it did not execute?

On 15 Feb 2006 15:08:20 -0800, James Shan wrote:

>I can pass userid and password requirement automatically,
>and read the sql file. BUT I could not execute it. Below
>is my BAT file. Can anyone provide some suggestion?
>Thanks!
>
>In Window, my BAT file looks like
>"C:\Program Files\Sybase\ASIQ-12_6\win32\dbisqlg.exe" -c
>"FILEDSN=C:\Program Files\Common Files\ODBC\Data
>Sources\iqax.dsn;UID=xxx;PWD=xxx" read "c:\testing.sql"
>
>
>
> > How do I incorporate my userid and password into a BAT
>> file?
>>
>>
>> ASA Database Administration Guide
>> Connecting to a Database
>> Connection parameters
>>
>>
>http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0901/en/html/dbdaen9/00000092.htm
>>
>> "%ASANY9%\win32\dbisql.exe" -c "uid=dba;pwd=sql;" READ
>> whatever.sql
>>
>> Here I take in the the dba password as a parameter to a
>> batch script used to copy tables from one DB to another.
>>
>> @echo off
>> if %1. == . goto done
>> if %2. == . goto done
>> if %3. == . goto done
>> if %4. == . goto done
>> if %5. == . goto done
>> set dbaPassword=%~1
>> set oldDbDirectory=%~2
>> set newDbDirectory=%~3
>> set dbName=%~4
>> set tableName=%~5
>>
>> echo.
>> @echo on
>> dbunload -t %tableName% -d -y -c
>> "uid=dba;pwd=ÛaPassword%
>> ;dbf=%oldDbDirectory%\ÛName%.db" Data dbisql -c
>"uid=dba
>> ;pwd=ÛaPassword%;dbf=%newDbDirectory%\ÛName%" read
>> reload.sql @echo off
>>
>> rmdir /s /q data
>> del /q /f reload.sql
>>
>> :done
>>
>>
>> Hope this helps!
>>
>> <James Shan> wrote in message
>> news:43f37e64.7d28.1681692777@sybase.com...
>>
>> > Thanks for the suggestion. I created a BAT file and
>> > started a session. But one more problem. Once an
>> > Interactive SQL session starts, I usually have to
>> > manually enter userid and password, in order to connect
>> to the remote Sybase database. >
>> > How do I incorporate my userid and password into a BAT
>> > file? Thanks!
>> >
>> >
>> >
>> >> You can also run ISQL in "batch mode" by supplying a
>> >> command file name; here is a template .BAT file
>> >>
>> >> "%ASANY9%\win32\dbisql.exe" -c "..." READ whatever.sql
>> >>
>> >> You can schedule *that* via Windows - System Tools -
>> >> Scheduled Tasks
>> >>
>> >> Breck
>> >>
>> >> On 9 Feb 2006 10:14:27 -0800, James Shan wrote:
>> >>
>> >> >I am using Interactive SQL. How to automatically
>> start >> a >session to run a query.
>> >> >
>> >> >Background: I am running a large query everyday. It
>> takes >> 4 >hours to complete. I have to waste the whole
>> morning >> before >I can do further query downstream. I
>> hope to >> automaticall >start a session at 5 AM, so that
>> when I come >> info the >office, the first query will be
>> done. >> >
>> >> >Any suggestion will be helpful. Thanks in advance.
>> >>
>> >> --
>> >> SQL Anywhere Studio 9 Developer's Guide
>> >> Buy the book:
>> >>
>> >
>>
>http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
>> >> bcarter@risingroad.com
>> >> RisingRoad SQL Anywhere and MobiLink Professional
>> Services >> www.risingroad.com
>>
>>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com


Christopher Harn Posted on 2006-02-16 16:12:33.0Z
From: "Christopher Harn" <harncw@hotmail.com>
Newsgroups: ianywhere.public.general
References: <43f38870@forums-2-dub> <43f3b464.5bd3.1681692777@sybase.com> <bi97v1dmdj956s604t27t3nhpu9dkdbqm9@4ax.com>
Subject: Re: Interactive SQL -Automation? (Additional Question)
Lines: 148
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
X-Original-NNTP-Posting-Host: 64-191-146-59.service.qx.net
Message-ID: <43f4950d@forums-2-dub>
X-Original-Trace: 16 Feb 2006 07:06:53 -0800, 64-191-146-59.service.qx.net
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 16 Feb 2006 07:06:56 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 16 Feb 2006 08:12:33 -0800
X-Trace: forums-1-dub 1140106353 10.22.108.75 (16 Feb 2006 08:12:33 -0800)
X-Original-Trace: 16 Feb 2006 08:12:33 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5187
Article PK: 1246

Could it be that Shan is calling dbisqlg versus dbisql (note the G at the
end).
Cant seem to find documentation on what the '*G' executable is all about.
Something about fast launcher.

I noticed different behavior between the two:

C:\Documents and Settings\harncw>dbisqlg -c "UID=dba;pwd=sql" select 'Hello
World'

C:\Documents and Settings\harncw>dbisql -c "UID=dba;pwd=sql" select 'Hello
World'
Plan: DUMMY (seq)

Execution time: 0 seconds
'Hello World'
-------------
Hello World

(First 1 rows)


C:\Documents and Settings\harncw>

"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
message news:bi97v1dmdj956s604t27t3nhpu9dkdbqm9@4ax.com...
> How do you know it did not execute?
>
> On 15 Feb 2006 15:08:20 -0800, James Shan wrote:
>
>>I can pass userid and password requirement automatically,
>>and read the sql file. BUT I could not execute it. Below
>>is my BAT file. Can anyone provide some suggestion?
>>Thanks!
>>
>>In Window, my BAT file looks like
>>"C:\Program Files\Sybase\ASIQ-12_6\win32\dbisqlg.exe" -c
>>"FILEDSN=C:\Program Files\Common Files\ODBC\Data
>>Sources\iqax.dsn;UID=xxx;PWD=xxx" read "c:\testing.sql"
>>
>>
>>
>> > How do I incorporate my userid and password into a BAT
>>> file?
>>>
>>>
>>> ASA Database Administration Guide
>>> Connecting to a Database
>>> Connection parameters
>>>
>>>
>>http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0901/en/html/dbdaen9/00000092.htm
>>>
>>> "%ASANY9%\win32\dbisql.exe" -c "uid=dba;pwd=sql;" READ
>>> whatever.sql
>>>
>>> Here I take in the the dba password as a parameter to a
>>> batch script used to copy tables from one DB to another.
>>>
>>> @echo off
>>> if %1. == . goto done
>>> if %2. == . goto done
>>> if %3. == . goto done
>>> if %4. == . goto done
>>> if %5. == . goto done
>>> set dbaPassword=%~1
>>> set oldDbDirectory=%~2
>>> set newDbDirectory=%~3
>>> set dbName=%~4
>>> set tableName=%~5
>>>
>>> echo.
>>> @echo on
>>> dbunload -t %tableName% -d -y -c
>>> "uid=dba;pwd=ÛaPassword%
>>> ;dbf=%oldDbDirectory%\ÛName%.db" Data dbisql -c
>>"uid=dba
>>> ;pwd=ÛaPassword%;dbf=%newDbDirectory%\ÛName%" read
>>> reload.sql @echo off
>>>
>>> rmdir /s /q data
>>> del /q /f reload.sql
>>>
>>> :done
>>>
>>>
>>> Hope this helps!
>>>
>>> <James Shan> wrote in message
>>> news:43f37e64.7d28.1681692777@sybase.com...
>>>
>>> > Thanks for the suggestion. I created a BAT file and
>>> > started a session. But one more problem. Once an
>>> > Interactive SQL session starts, I usually have to
>>> > manually enter userid and password, in order to connect
>>> to the remote Sybase database. >
>>> > How do I incorporate my userid and password into a BAT
>>> > file? Thanks!
>>> >
>>> >
>>> >
>>> >> You can also run ISQL in "batch mode" by supplying a
>>> >> command file name; here is a template .BAT file
>>> >>
>>> >> "%ASANY9%\win32\dbisql.exe" -c "..." READ whatever.sql
>>> >>
>>> >> You can schedule *that* via Windows - System Tools -
>>> >> Scheduled Tasks
>>> >>
>>> >> Breck
>>> >>
>>> >> On 9 Feb 2006 10:14:27 -0800, James Shan wrote:
>>> >>
>>> >> >I am using Interactive SQL. How to automatically
>>> start >> a >session to run a query.
>>> >> >
>>> >> >Background: I am running a large query everyday. It
>>> takes >> 4 >hours to complete. I have to waste the whole
>>> morning >> before >I can do further query downstream. I
>>> hope to >> automaticall >start a session at 5 AM, so that
>>> when I come >> info the >office, the first query will be
>>> done. >> >
>>> >> >Any suggestion will be helpful. Thanks in advance.
>>> >>
>>> >> --
>>> >> SQL Anywhere Studio 9 Developer's Guide
>>> >> Buy the book:
>>> >>
>>> >
>>>
>>http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
>>> >> bcarter@risingroad.com
>>> >> RisingRoad SQL Anywhere and MobiLink Professional
>>> Services >> www.risingroad.com
>>>
>>>
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
> http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com


Greg Fenton Posted on 2006-02-16 16:50:54.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Interactive SQL -Automation? (Additional Question)
References: <43f38870@forums-2-dub> <43f3b464.5bd3.1681692777@sybase.com> <bi97v1dmdj956s604t27t3nhpu9dkdbqm9@4ax.com> <43f4950d@forums-2-dub>
In-Reply-To: <43f4950d@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: gfenton-t30.sybase.com
X-Original-NNTP-Posting-Host: gfenton-t30.sybase.com
Message-ID: <43f4ad6e$1@forums-1-dub>
Date: 16 Feb 2006 08:50:54 -0800
X-Trace: forums-1-dub 1140108654 10.25.98.144 (16 Feb 2006 08:50:54 -0800)
X-Original-Trace: 16 Feb 2006 08:50:54 -0800, gfenton-t30.sybase.com
Lines: 26
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5188
Article PK: 1247


Christopher Harn wrote:
> Could it be that Shan is calling dbisqlg versus dbisql (note the G at the
> end).

dbisqlg and dbisql are identical. The different one is dbisqlc.

The former two are both the latest generation technology (warmly
referred to as the "Java version" in this newsgroup). The latter one is
the old generation (the "C version"). The older one is maintained but
no new features are added. It is mainly kept for use by scripts since
it launches and begins SQL execution much faster than the fully featured
dbisql/dbisqlg version.

> Cant seem to find documentation on what the '*G' executable is all about.
> Something about fast launcher.

Fast launch is a feature of the "Java version"

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Christopher Harn Posted on 2006-02-16 18:19:29.0Z
From: "Christopher Harn" <harncw@hotmail.com>
Newsgroups: ianywhere.public.general
References: <43f38870@forums-2-dub> <43f3b464.5bd3.1681692777@sybase.com> <bi97v1dmdj956s604t27t3nhpu9dkdbqm9@4ax.com> <43f4950d@forums-2-dub> <43f4ad6e$1@forums-1-dub>
Subject: Re: Interactive SQL -Automation? (Additional Question)
Lines: 91
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
NNTP-Posting-Host: 64-191-146-59.service.qx.net
X-Original-NNTP-Posting-Host: 64-191-146-59.service.qx.net
Message-ID: <43f4c231$1@forums-1-dub>
Date: 16 Feb 2006 10:19:29 -0800
X-Trace: forums-1-dub 1140113969 64.191.146.59 (16 Feb 2006 10:19:29 -0800)
X-Original-Trace: 16 Feb 2006 10:19:29 -0800, 64-191-146-59.service.qx.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5189
Article PK: 1248

The undocument '-gui' switch maybe what the original poster was looking for.

I hate to keep stomping through someone else's post but... If dbisql.exe
and dbisqlg.exe are identical why are they different at a byte level
comparison and why do they exhibit different results, any logic on when you
are supposed to use one versus the other?

Simple test we can all try at home.

C:\Documents and Settings\harncw>dbinit test
Adaptive Server Anywhere Initialization Utility Version 9.0.2.3182
Creating system tables
Collation sequence: 1252LATIN1
Creating system views
Setting permissions on system tables and views
Setting option values
Initializing UltraLite deployment option
Database "test.db" created successfully

C:\Documents and Settings\harncw>dbisql -c "UID=dba;pwd=sql;dbf=test" select
'Hello WORLD'
Execution time: 0.015 seconds
'Hello WORLD'
-------------
Hello WORLD

(First 1 rows)


C:\Documents and Settings\harncw>dbisqlg -c "UID=dba;pwd=sql;dbf=test"
select 'Hello WORLD'

C:\Documents and Settings\harncw>

...

C:\Documents and Settings\harncw>dbisqlg -nogui -c
"UID=dba;pwd=sql;dbf=test" select 'Hello WORLD'

C:\Documents and Settings\harncw>dbisql -nogui -c "UID=dba;pwd=sql;dbf=test"
select 'Hello WORLD'
Execution time: 0 seconds
'Hello WORLD'
-------------
Hello WORLD

(First 1 rows)


C:\Documents and Settings\harncw>

...

C:\Documents and Settings\harncw>dbisql -gui -c "UID=dba;pwd=sql;dbf=test"
select 'Hello WORLD'

C:\Documents and Settings\harncw>dbisqlg -gui -c "UID=dba;pwd=sql;dbf=test"
select 'Hello WORLD'

C:\Documents and Settings\harncw>

"Greg Fenton" <greg.fenton_NOSPAM_@ianywhere.com> wrote in message
news:43f4ad6e$1@forums-1-dub...
> Christopher Harn wrote:
>> Could it be that Shan is calling dbisqlg versus dbisql (note the G at the
>> end).
>
> dbisqlg and dbisql are identical. The different one is dbisqlc.
>
> The former two are both the latest generation technology (warmly referred
> to as the "Java version" in this newsgroup). The latter one is the old
> generation (the "C version"). The older one is maintained but no new
> features are added. It is mainly kept for use by scripts since it
> launches and begins SQL execution much faster than the fully featured
> dbisql/dbisqlg version.
>
>> Cant seem to find documentation on what the '*G' executable is all about.
>> Something about fast launcher.
>
> Fast launch is a feature of the "Java version"
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/


Greg Fenton Posted on 2006-02-16 23:02:50.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Interactive SQL -Automation? (Additional Question)
References: <43f38870@forums-2-dub> <43f3b464.5bd3.1681692777@sybase.com> <bi97v1dmdj956s604t27t3nhpu9dkdbqm9@4ax.com> <43f4950d@forums-2-dub> <43f4ad6e$1@forums-1-dub> <43f4c231$1@forums-1-dub>
In-Reply-To: <43f4c231$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: gfenton-t30.sybase.com
X-Original-NNTP-Posting-Host: gfenton-t30.sybase.com
Message-ID: <43f5049a$1@forums-1-dub>
Date: 16 Feb 2006 15:02:50 -0800
X-Trace: forums-1-dub 1140130970 10.25.98.144 (16 Feb 2006 15:02:50 -0800)
X-Original-Trace: 16 Feb 2006 15:02:50 -0800, gfenton-t30.sybase.com
Lines: 21
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5190
Article PK: 1249


Christopher Harn wrote:
> I hate to keep stomping through someone else's post but... If dbisql.exe
> and dbisqlg.exe are identical why are they different at a byte level
> comparison and why do they exhibit different results, any logic on when you
> are supposed to use one versus the other?

From my understanding, the only difference is the way that the JVM is
launched. One separates itself from the current shell and the other
remains tied to it. I think this is somewhat akin to running "dbeng9
test.db" vs "dbspawn dbeng9 test.db".

Hopefully someone in engineering will correct me if I'm wrong here.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Breck Carter [TeamSybase] Posted on 2006-02-17 14:17:38.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Interactive SQL -Automation? (Additional Question)
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <1tibv15dih5ihhjf0dc5n6nkj036nd1n5p@4ax.com>
References: <43f38870@forums-2-dub> <43f3b464.5bd3.1681692777@sybase.com> <bi97v1dmdj956s604t27t3nhpu9dkdbqm9@4ax.com> <43f4950d@forums-2-dub> <43f4ad6e$1@forums-1-dub> <43f4c231$1@forums-1-dub> <43f5049a$1@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
X-Original-Trace: 17 Feb 2006 05:12:44 -0800, bcarter.sentex.ca
Lines: 29
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 17 Feb 2006 05:12:46 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 17 Feb 2006 06:17:38 -0800
X-Trace: forums-1-dub 1140185858 10.22.108.75 (17 Feb 2006 06:17:38 -0800)
X-Original-Trace: 17 Feb 2006 06:17:38 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5191
Article PK: 1250

I was once told "do not launch dbisqlg.exe, use dbisql.exe" by someone
who should know... maybe it was you :)

Breck

On 16 Feb 2006 15:02:50 -0800, Greg Fenton

<greg.fenton_NOSPAM_@ianywhere.com> wrote:

>Christopher Harn wrote:
>> I hate to keep stomping through someone else's post but... If dbisql.exe
>> and dbisqlg.exe are identical why are they different at a byte level
>> comparison and why do they exhibit different results, any logic on when you
>> are supposed to use one versus the other?
>
> From my understanding, the only difference is the way that the JVM is
>launched. One separates itself from the current shell and the other
>remains tied to it. I think this is somewhat akin to running "dbeng9
>test.db" vs "dbspawn dbeng9 test.db".
>
>Hopefully someone in engineering will correct me if I'm wrong here.
>
>greg.fenton

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com


Greg Fenton Posted on 2006-02-17 16:07:08.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Interactive SQL -Automation? (Additional Question)
References: <43f38870@forums-2-dub> <43f3b464.5bd3.1681692777@sybase.com> <bi97v1dmdj956s604t27t3nhpu9dkdbqm9@4ax.com> <43f4950d@forums-2-dub> <43f4ad6e$1@forums-1-dub> <43f4c231$1@forums-1-dub> <43f5049a$1@forums-1-dub> <1tibv15dih5ihhjf0dc5n6nkj036nd1n5p@4ax.com>
In-Reply-To: <1tibv15dih5ihhjf0dc5n6nkj036nd1n5p@4ax.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: gfenton-t30.sybase.com
Message-ID: <43f5e574$1@forums-2-dub>
X-Original-Trace: 17 Feb 2006 07:02:12 -0800, gfenton-t30.sybase.com
Lines: 24
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 17 Feb 2006 07:02:14 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 17 Feb 2006 08:07:08 -0800
X-Trace: forums-1-dub 1140192428 10.22.108.75 (17 Feb 2006 08:07:08 -0800)
X-Original-Trace: 17 Feb 2006 08:07:08 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5192
Article PK: 1251


Breck Carter [TeamSybase] wrote:
> I was once told "do not launch dbisqlg.exe, use dbisql.exe" by someone
> who should know... maybe it was you :)

I don't think it was me...but I won't put money on that. ;-)

However, the Start Menu shortcut (Start -> Programs -> SQLAnywhere ->
Adaptive Server Anywhere -> Interactive SQL) is:

C:\apps\asa9\win32\dbisqlg.exe

(or wherever %ASANY9% is). That is why I think it has to do with
separation from the current shell. When you run "dbisql.exe -nogui",
the command prompt is "busy" until the program exists. When you run
"dbisqlg.exe -nogui", the command prompt comes back immediately.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


James Shan Posted on 2006-02-15 22:55:02.0Z
Sender: 5abf.43f39658.1804289383@sybase.com
From: James Shan
Newsgroups: ianywhere.public.general
Subject: Re: Interactive SQL -Automation?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <43f3b146.5bb3.1681692777@sybase.com>
References: <580nu1hjp7ep5ombva9bgm0t549d9gnem6@4ax.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 15 Feb 2006 14:55:02 -0800
X-Trace: forums-1-dub 1140044102 10.22.241.41 (15 Feb 2006 14:55:02 -0800)
X-Original-Trace: 15 Feb 2006 14:55:02 -0800, 10.22.241.41
Lines: 39
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5183
Article PK: 1242

I was able to start a session and read the sql file, but
could not execute it. Does anyone know the option for
executing sql? Thanks!


_James

> You can also run ISQL in "batch mode" by supplying a
> command file name; here is a template .BAT file
>
> "%ASANY9%\win32\dbisql.exe" -c "..." READ whatever.sql
>
> You can schedule *that* via Windows - System Tools -
> Scheduled Tasks
>
> Breck
>
> On 9 Feb 2006 10:14:27 -0800, James Shan wrote:
>
> >I am using Interactive SQL. How to automatically start
> a >session to run a query.
> >
> >Background: I am running a large query everyday. It takes
> 4 >hours to complete. I have to waste the whole morning
> before >I can do further query downstream. I hope to
> automaticall >start a session at 5 AM, so that when I come
> info the >office, the first query will be done.
> >
> >Any suggestion will be helpful. Thanks in advance.
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
>
http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com


Breck Carter [TeamSybase] Posted on 2006-02-15 23:12:31.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Interactive SQL -Automation?
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <8e97v11n9lncrj7j1s0es0v9b39692nn28@4ax.com>
References: <580nu1hjp7ep5ombva9bgm0t549d9gnem6@4ax.com> <43f3b146.5bb3.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 15 Feb 2006 15:12:31 -0800
X-Trace: forums-1-dub 1140045151 64.7.134.118 (15 Feb 2006 15:12:31 -0800)
X-Original-Trace: 15 Feb 2006 15:12:31 -0800, bcarter.sentex.ca
Lines: 59
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5185
Article PK: 1244

What exactly happened? FWIW, there isn't a lot of visual confirmation
that anything is happening, how do you know it did not execute?

Here is an actual working example (all one line):

"%ASANY9%\win32\dbisql.exe" -c "ENG=ddd;DBN=ddd;UID=dba;PWD=sql" READ
reload.sql

Breck

On 15 Feb 2006 14:55:02 -0800, James Shan wrote:

>I was able to start a session and read the sql file, but
>could not execute it. Does anyone know the option for
>executing sql? Thanks!
>
>
>_James
>
>
>> You can also run ISQL in "batch mode" by supplying a
>> command file name; here is a template .BAT file
>>
>> "%ASANY9%\win32\dbisql.exe" -c "..." READ whatever.sql
>>
>> You can schedule *that* via Windows - System Tools -
>> Scheduled Tasks
>>
>> Breck
>>
>> On 9 Feb 2006 10:14:27 -0800, James Shan wrote:
>>
>> >I am using Interactive SQL. How to automatically start
>> a >session to run a query.
>> >
>> >Background: I am running a large query everyday. It takes
>> 4 >hours to complete. I have to waste the whole morning
>> before >I can do further query downstream. I hope to
>> automaticall >start a session at 5 AM, so that when I come
>> info the >office, the first query will be done.
>> >
>> >Any suggestion will be helpful. Thanks in advance.
>>
>> --
>> SQL Anywhere Studio 9 Developer's Guide
>> Buy the book:
>>
>http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
>> bcarter@risingroad.com
>> RisingRoad SQL Anywhere and MobiLink Professional Services
>> www.risingroad.com

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com