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.

doing db admin and other tasks dynamically

2 posts in General Discussion Last posting was on 2004-08-12 13:35:32.0Z
annie abraham Posted on 2004-07-26 16:33:17.0Z
From: "annie abraham" <annie.abraham@mobiledataforce.com>
Newsgroups: ianywhere.public.general
Subject: doing db admin and other tasks dynamically
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: 208.187.119.18
Message-ID: <41053351$1@forums-2-dub>
X-Original-Trace: 26 Jul 2004 09:37:37 -0700, 208.187.119.18
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 26 Jul 2004 09:26:10 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 26 Jul 2004 09:33:17 -0700
X-Trace: forums-1-dub 1090859597 10.22.108.75 (26 Jul 2004 09:33:17 -0700)
X-Original-Trace: 26 Jul 2004 09:33:17 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3318
Article PK: 7230

Adaptive Server Anywhere 9 9.0.1.1751

Hi

We have an application that helps users create customised forms and store
data in dbs, and I have to do things like create a
publication,user,synchronization, extract a reference a database, create a
ultralite schema etc from within the program.
I use a .NET programming environment and I'd like to know which is the best
way to go about this. Is calling script files with the command-line
utilities the best way, or is there some other way. Also can I have links
to latest documentation of exit codes of all the diffrent command-line
utilities.
Thanks

Annie


David Fishburn Posted on 2004-08-12 13:35:32.0Z
Newsgroups: ianywhere.public.general
Subject: Re: doing db admin and other tasks dynamically
From: David Fishburn <fishburn_spam_off@ianywhere.com>
References: <41053351$1@forums-2-dub>
Organization: iAnywhere Solutions
Message-ID: <Xns95436017E3A74fishburnsybasecom@10.22.241.106>
User-Agent: Xnews/06.08.25
NNTP-Posting-Host: 10.25.100.134
X-Original-NNTP-Posting-Host: 10.25.100.134
Date: 12 Aug 2004 06:35:32 -0700
X-Trace: forums-1-dub 1092317732 10.25.100.134 (12 Aug 2004 06:35:32 -0700)
X-Original-Trace: 12 Aug 2004 06:35:32 -0700, 10.25.100.134
Lines: 56
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3378
Article PK: 7279

"annie abraham" <annie.abraham@mobiledataforce.com> wrote in
news:41053351$1@forums-2-dub:

aa>
aa> Adaptive Server Anywhere 9 9.0.1.1751
aa>
aa> We have an application that helps users create customised forms and
aa> store data in dbs, and I have to do things like create a
aa> publication,user,synchronization, extract a reference a database,
aa> create a ultralite schema etc from within the program.
aa> I use a .NET programming environment and I'd like to know which is
the
aa> best way to go about this. Is calling script files with the
aa> command-line utilities the best way, or is there some other way.

I guess the "best" way is whatever way you are most comfortable.
I personally would:
1. Create a schema file
2. Create a publication / subcription file (which takes parameters via
DBISQL).
3. Have a batch script that will:
dbinit
dbisql read schema.sql
dbisql read publication.sql [sync_user] [ml_host] [ml_port] ...
whatever additional parameters I want to pass in to
customize *this* database for a given user.
copy the db and log to the device.

aa> Also can I have links to latest documentation of exit codes of all
the
aa> diffrent command-line utilities.

If you are using the 9.0.1 Docs (which is a separate download) then you
have the most current documentation.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList