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.

Scripting

5 posts in General Discussion Last posting was on 2009-01-23 21:15:13.0Z
Simon Posted on 2009-01-22 15:27:19.0Z
Sender: 22df.49788fc2.1804289383@sybase.com
From: Simon
Newsgroups: ianywhere.public.general
Subject: Scripting
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49789057.22ee.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 22 Jan 2009 07:27:19 -0800
X-Trace: forums-1-dub 1232638039 10.22.241.41 (22 Jan 2009 07:27:19 -0800)
X-Original-Trace: 22 Jan 2009 07:27:19 -0800, 10.22.241.41
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7315
Article PK: 5526

It seems like lot of people prefer to use scripting rather
than Java enabled utilities with iAnywhere.

But is the best source to learn all the syntax/scripting
language?

Thank you in advance


Jeff Albion (Sybase iAnywhere) Posted on 2009-01-22 16:16:50.0Z
From: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Scripting
References: <49789057.22ee.1681692777@sybase.com>
In-Reply-To: <49789057.22ee.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49789bf2$1@forums-1-dub>
Date: 22 Jan 2009 08:16:50 -0800
X-Trace: forums-1-dub 1232641010 10.22.241.152 (22 Jan 2009 08:16:50 -0800)
X-Original-Trace: 22 Jan 2009 08:16:50 -0800, vip152.sybase.com
Lines: 59
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7316
Article PK: 5527

Simon,

You'll have to be more specific when referring to "scripting". :) What
kind of script are you looking to write? Is it just a batch script ( a
sequence of commands interpretted by your operating system to run some
database adminstration tasks?) or are you looking for something else?

---

"Batch" scripts are specific to the Windows operating system. They are
executed in the "Command Prompt" environment. A useful reference I've
found for batch-specific commands is here:
http://www.robvanderwoude.com/batchfiles.html
From the batch file, you can then in turn execute our command-line
utilities: http://dcx.sybase.com/1100en/dbadmin_en11/da-dbutilities.html

Windows also has the option of "Windows Script Host" scripts that's
closer to writing a Visual Basic program:
http://msdn.microsoft.com/en-us/library/9bbdkx3k(VS.85).aspx

"Shell" scripts can be found on the Linux/UNIX/Mac OS platforms. These
are typically executed in one of two styles of shell intepreters: Bourne
or C-Shell. Both have their own unique commands to accomplish similar
tasks, so you either have to provide an interpreter at the top of your
scripts (usually /bin/sh, or "Bash") or know in advance what type of
shell your users are using. A good reference for bash shell scripts can
be found here:

http://tldp.org/HOWTO/Bash-Prog-Intro-HOWTO.html

---

Also remember that many database tasks can be done using various SQL
statements. You can put these statements into a file, then execute them
using "dbisql" (dbisql.com in v11, if running from the
command-line/batch script).

See our SQL reference:
http://dcx.sybase.com/1100en/dbreference_en11/rf-statements.html
dbisql reference:
http://dcx.sybase.com/1100en/dbadmin_en11/dbisql-interactive-dbutilities.html

Regards,

Simon wrote:
> It seems like lot of people prefer to use scripting rather
> than Java enabled utilities with iAnywhere.
>
> But is the best source to learn all the syntax/scripting
> language?

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0


Simon Posted on 2009-01-23 19:13:01.0Z
Sender: 4b1d.497a14a1.846930886@sybase.com
From: Simon
Newsgroups: ianywhere.public.general
Subject: Re: Scripting
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <497a16bd.4b59.1681692777@sybase.com>
References: <49789bf2$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 Jan 2009 11:13:01 -0800
X-Trace: forums-1-dub 1232737981 10.22.241.41 (23 Jan 2009 11:13:01 -0800)
X-Original-Trace: 23 Jan 2009 11:13:01 -0800, 10.22.241.41
Lines: 83
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7317
Article PK: 5528

Jeff

Thank you for the answer. Yes, I was looking for scripting
with database (Sybase Anywhere) using dbisql tools etc.

for instance:
connect to mydbsrv database 'mydb' user DBA identified by
SQL

From where can I find these sort of information to do
things.

> Simon,
>
> You'll have to be more specific when referring to
> "scripting". :) What kind of script are you looking to
> write? Is it just a batch script ( a sequence of commands
> interpretted by your operating system to run some
> database adminstration tasks?) or are you looking for
> something else?
>
> ---
>
> "Batch" scripts are specific to the Windows operating
> system. They are executed in the "Command Prompt"
> environment. A useful reference I've found for
> batch-specific commands is here:
> http://www.robvanderwoude.com/batchfiles.html
> From the batch file, you can then in turn execute our
> command-line utilities:
>
http://dcx.sybase.com/1100en/dbadmin_en11/da-dbutilities.html
>
> Windows also has the option of "Windows Script Host"
> scripts that's closer to writing a Visual Basic program:
>
http://msdn.microsoft.com/en-us/library/9bbdkx3k(VS.85).aspx
>
> "Shell" scripts can be found on the Linux/UNIX/Mac OS
> platforms. These are typically executed in one of two
> styles of shell intepreters: Bourne or C-Shell. Both have
> their own unique commands to accomplish similar tasks, so
> you either have to provide an interpreter at the top of
> your scripts (usually /bin/sh, or "Bash") or know in
> advance what type of shell your users are using. A good
> reference for bash shell scripts can be found here:
>
> http://tldp.org/HOWTO/Bash-Prog-Intro-HOWTO.html
>
> ---
>
> Also remember that many database tasks can be done using
> various SQL statements. You can put these statements into
> a file, then execute them using "dbisql" (dbisql.com in
> v11, if running from the command-line/batch script).
>
> See our SQL reference:
>
http://dcx.sybase.com/1100en/dbreference_en11/rf-statements.html
> dbisql reference:
>
http://dcx.sybase.com/1100en/dbadmin_en11/dbisql-interactive-dbutilities.html
>
> Regards,
>
> Simon wrote:
> > It seems like lot of people prefer to use scripting
> > rather than Java enabled utilities with iAnywhere.
> >
> > But is the best source to learn all the syntax/scripting
> > language?
>
> --
> Jeff Albion, Sybase iAnywhere
>
> iAnywhere Developer Community :
>
http://www.sybase.com/developer/library/sql-anywhere-techcorner
> iAnywhere Documentation :
> http://www.ianywhere.com/developer/product_manuals SQL
> Anywhere Patches and EBFs :
>

http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0


Breck Carter [TeamSybase] Posted on 2009-01-23 21:15:13.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: ianywhere.public.general
Subject: Re: Scripting
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <gbbkn4907ouccq1g79r01s6ln961js5n1h@4ax.com>
References: <49789bf2$1@forums-1-dub> <497a16bd.4b59.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: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 23 Jan 2009 13:15:13 -0800
X-Trace: forums-1-dub 1232745313 10.22.241.152 (23 Jan 2009 13:15:13 -0800)
X-Original-Trace: 23 Jan 2009 13:15:13 -0800, vip152.sybase.com
Lines: 101
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7319
Article PK: 5529

If you are talking about running SQL scripts via dbisql, then this
post shows how to set up a test environment:

http://sqlanywhere.blogspot.com/2008/02/dont-be-afraid.html

Then click on the "SQL code" category on the right to see articles
about writing SQL scripts.

Breck

On 23 Jan 2009 11:13:01 -0800, Simon wrote:

>Jeff
>
>Thank you for the answer. Yes, I was looking for scripting
>with database (Sybase Anywhere) using dbisql tools etc.
>
>for instance:
>connect to mydbsrv database 'mydb' user DBA identified by
>SQL
>
>From where can I find these sort of information to do
>things.
>
>> Simon,
>>
>> You'll have to be more specific when referring to
>> "scripting". :) What kind of script are you looking to
>> write? Is it just a batch script ( a sequence of commands
>> interpretted by your operating system to run some
>> database adminstration tasks?) or are you looking for
>> something else?
>>
>> ---
>>
>> "Batch" scripts are specific to the Windows operating
>> system. They are executed in the "Command Prompt"
>> environment. A useful reference I've found for
>> batch-specific commands is here:
>> http://www.robvanderwoude.com/batchfiles.html
>> From the batch file, you can then in turn execute our
>> command-line utilities:
>>
>http://dcx.sybase.com/1100en/dbadmin_en11/da-dbutilities.html
>>
>> Windows also has the option of "Windows Script Host"
>> scripts that's closer to writing a Visual Basic program:
>>
>http://msdn.microsoft.com/en-us/library/9bbdkx3k(VS.85).aspx
>>
>> "Shell" scripts can be found on the Linux/UNIX/Mac OS
>> platforms. These are typically executed in one of two
>> styles of shell intepreters: Bourne or C-Shell. Both have
>> their own unique commands to accomplish similar tasks, so
>> you either have to provide an interpreter at the top of
>> your scripts (usually /bin/sh, or "Bash") or know in
>> advance what type of shell your users are using. A good
>> reference for bash shell scripts can be found here:
>>
>> http://tldp.org/HOWTO/Bash-Prog-Intro-HOWTO.html
>>
>> ---
>>
>> Also remember that many database tasks can be done using
>> various SQL statements. You can put these statements into
>> a file, then execute them using "dbisql" (dbisql.com in
>> v11, if running from the command-line/batch script).
>>
>> See our SQL reference:
>>
>http://dcx.sybase.com/1100en/dbreference_en11/rf-statements.html
>> dbisql reference:
>>
>http://dcx.sybase.com/1100en/dbadmin_en11/dbisql-interactive-dbutilities.html
>>
>> Regards,
>>
>> Simon wrote:
>> > It seems like lot of people prefer to use scripting
>> > rather than Java enabled utilities with iAnywhere.
>> >
>> > But is the best source to learn all the syntax/scripting
>> > language?
>>
>> --
>> Jeff Albion, Sybase iAnywhere
>>
>> iAnywhere Developer Community :
>>
>http://www.sybase.com/developer/library/sql-anywhere-techcorner
>> iAnywhere Documentation :
>> http://www.ianywhere.com/developer/product_manuals SQL
>> Anywhere Patches and EBFs :
>>
>http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter@risingroad.com


Jonathan Baker [Sybase] Posted on 2009-01-23 19:57:36.0Z
From: "Jonathan Baker [Sybase]" <lastnamefirstinitial@sybase.com>
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Scripting
References: <49789bf2$1@forums-1-dub> <497a16bd.4b59.1681692777@sybase.com>
In-Reply-To: <497a16bd.4b59.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <497a2130$1@forums-1-dub>
Date: 23 Jan 2009 11:57:36 -0800
X-Trace: forums-1-dub 1232740656 10.22.241.152 (23 Jan 2009 11:57:36 -0800)
X-Original-Trace: 23 Jan 2009 11:57:36 -0800, vip152.sybase.com
Lines: 95
X-Authenticated-User: NGSysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7318
Article PK: 5530

What scripting language do you want to use?

There are so many to choose from - shell/cshell scripts, perl, php...

Jonathan

Simon wrote:
> Jeff
>
> Thank you for the answer. Yes, I was looking for scripting
> with database (Sybase Anywhere) using dbisql tools etc.
>
> for instance:
> connect to mydbsrv database 'mydb' user DBA identified by
> SQL
>
> From where can I find these sort of information to do
> things.
>
>> Simon,
>>
>> You'll have to be more specific when referring to
>> "scripting". :) What kind of script are you looking to
>> write? Is it just a batch script ( a sequence of commands
>> interpretted by your operating system to run some
>> database adminstration tasks?) or are you looking for
>> something else?
>>
>> ---
>>
>> "Batch" scripts are specific to the Windows operating
>> system. They are executed in the "Command Prompt"
>> environment. A useful reference I've found for
>> batch-specific commands is here:
>> http://www.robvanderwoude.com/batchfiles.html
>> From the batch file, you can then in turn execute our
>> command-line utilities:
>>
> http://dcx.sybase.com/1100en/dbadmin_en11/da-dbutilities.html
>> Windows also has the option of "Windows Script Host"
>> scripts that's closer to writing a Visual Basic program:
>>
> http://msdn.microsoft.com/en-us/library/9bbdkx3k(VS.85).aspx
>> "Shell" scripts can be found on the Linux/UNIX/Mac OS
>> platforms. These are typically executed in one of two
>> styles of shell intepreters: Bourne or C-Shell. Both have
>> their own unique commands to accomplish similar tasks, so
>> you either have to provide an interpreter at the top of
>> your scripts (usually /bin/sh, or "Bash") or know in
>> advance what type of shell your users are using. A good
>> reference for bash shell scripts can be found here:
>>
>> http://tldp.org/HOWTO/Bash-Prog-Intro-HOWTO.html
>>
>> ---
>>
>> Also remember that many database tasks can be done using
>> various SQL statements. You can put these statements into
>> a file, then execute them using "dbisql" (dbisql.com in
>> v11, if running from the command-line/batch script).
>>
>> See our SQL reference:
>>
> http://dcx.sybase.com/1100en/dbreference_en11/rf-statements.html
>> dbisql reference:
>>
> http://dcx.sybase.com/1100en/dbadmin_en11/dbisql-interactive-dbutilities.html
>> Regards,
>>
>> Simon wrote:
>>> It seems like lot of people prefer to use scripting
>>> rather than Java enabled utilities with iAnywhere.
>>>
>>> But is the best source to learn all the syntax/scripting
>>> language?
>> --
>> Jeff Albion, Sybase iAnywhere
>>
>> iAnywhere Developer Community :
>>
> http://www.sybase.com/developer/library/sql-anywhere-techcorner
>> iAnywhere Documentation :
>> http://www.ianywhere.com/developer/product_manuals SQL
>> Anywhere Patches and EBFs :
>>
> http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0

--
Jonathan Baker
Director, Sybase Developers Network (SDN)
Sybase, Inc.

http://www.sybase.com/developer
bakerj@sybase.com