Just curios (and several times very angry in the past about this):

Why isn't there a DDL commnad to show the strucutre of an object like Oracle's DESCRIBE?

Without Central I cannot extract table's defintions easily ... true or not?

Martin

DBUNLOAD can extract individual table schema. See -t option.


"Martin Baur" <tinu (AT) mindpower (DOT) com> wrote

Martin Baur wrote:
You can use the system tables and/or system views to get a description
of each table and each column. But your question is a good one and you
should consider posting to the newsgroup:

sybase.public.sqlanywhere.product_futures_discussi on

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

You could also write a simple web-service to do this.

In article <41a639ce$1@forums-2-dub>, nospam__rickb (AT) sybase (DOT) com says...

I take my chance: I invite you to write one for me and all the others ... of course, only if you have time ... :-)


Curious ....

Martin

Check out Breck Carter's cool "RisingRoad Online Schema Display" at
http://risingroad.com/toolbox.html#rrosd

- Mark


Martin Baur wrote:

In article <41A691D7.7B639285 (AT) iAnywhere (DOT) com>, reply_to_newsgroups_only_please_nosp...here (DOT) com says...
I checked that ... becase I was already a csutomer of Rising Road, I saw this kind of output times ago.

However, as a web service, I have not yet seen it. Looks very useful ...

Breck, reading? Is this a product you sell? Soemthing anybody can throw on his ASA9 and it enables ASA to show all mounted DBs (or at least a configured one)?

How about security? Can one tailor the access to the web service? note, I have not yet played around with Web services ....

Thanks

Martin

Yes, I am reading ... the full version of the schema display has
more functionality than the demo, in particular it does *not* need any
objects (procedures, tables, web services) added to the target
database. Everything is encapsulated in a separate tiny V9 database
used only for the purposes of capturing schema information via remote
access. I can send you a beta setup sometime this weekend if you want.

As far as sample code for web services is concerned, there is a bunch
shipped with ASA 9, plus a basic schema display demo available on
CodeXchange at
http://ianywhere.codexchange.sybase....ctDocumentList
or on RisingRoad at http://risingroad.com/toolbox.html#rrosd

The demo doesn't address security, but you can definitely do that.

Breck

On 25 Nov 2004 19:49:39 -0800, Martin Baur <tinu (AT) mindpower (DOT) com> wrote:

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/AS.../risingroad-20
bcarter (AT) risingroad (DOT) com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

The web services docs for 9.0.2 have also been extended considerably.
Take a look in
ASA Database Administration Guide
Using Web Services
which can be viewed online at:
http://www.ianywhere.com/developer/p...9/00000292.htm
--
Mark Culp
ASA Research and Development
-------------------------------------------------------------------------
** Whitepapers, TechDocs, bug fixes are all available through the **
** iAnywhere Developer Community at http://www.ianywhere.com/developer **
-------------------------------------------------------------------------

"Breck Carter [TeamSybase]" wrote:

Hi Breck


Yes, of course I appreciate you sending me a beta ...

Thanks in advance

MArtin