Make your own free website on Tripod.com

InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: InstantDB: Describe DB


Peter-

That worked beautifully thank you for all of your help.

Thank You,
Nathan Cook
edventures.com

----- Original Message -----
From: "Peter Hearty" <peter.hearty@lutris.com>
To: <instantDB@enhydra.org>
Sent: Wednesday, November 15, 2000 6:44 AM
Subject: RE: InstantDB: Describe DB


> Nathan
>
> Try something like:
>
> c get columns mytables% %;
>
> Regards
>
> Peter Hearty
> Lutris Technologies UK
>
>
> -----Original Message-----
> From: owner-instantDB@enhydra.org [mailto:owner-instantDB@enhydra.org]On
> Behalf Of Nathan Cook
> Sent: 14 November 2000 20:24
> To: instantDB@enhydra.org
> Subject: Re: InstantDB: Describe DB
>
>
> Mr. Hearty-
>     I may have made a mistake, but when I run the below sql1.txt I get the
> output below.  Do you know of any commands that would describe a table or
> database with the fields and field types?
>
> Thank You!
> Nathan Cook
>
> --- Contents of SQL1.TXT ---
> d org.enhydra.instantdb.jdbc.idbDriver;
> o jdbc:idb=/home/SocratEase/Server/eudb.prp;
>
> e SET EXPORT "export0.txt" FIXEDLENGTH COLNAMEHEADER ROWNUMBERS CONTROLCOL
> SUMMARYHEADER;
> c all tables;
> c close;
>
>
> --- When I run Startscript tool I get the following output ---
> [root@lyceum webserver]# ./startscripttool
> Enhydra InstantDB - Version 3.21
> The Initial Developer of the Original Code is Lutris Technologies Inc.
> Portions created by Lutris are Copyright (C) 1997-2000 Lutris
Technologies,
> Inc.
> All Rights Reserved.
>
> Connected to jdbc:idb:/home/SocratEase/Server/eudb.prp
> Driver   InstantDB JDBC Driver
> Version  Version 3.21
>
> TABLE_CAT,TABLE_SCHEM,TABLE_NAME,TABLE_TYPE,TABLE_REMARKS
> ,,$db$types,SYSTEM TABLE,
> ,,COURSES$pKey,SYSTEM TABLE,
> ,,COURSE_ENROLLMENTS$pKey,SYSTEM TABLE,
> ,,COURSE_LOCK$pKey,SYSTEM TABLE,
> ,,EXAM_ENTRIES$pKey,SYSTEM TABLE,
> ,,GRADES$pKey,SYSTEM TABLE,
> ,,LESSONS$pKey,SYSTEM TABLE,
> ,,LOCALES$pKey,SYSTEM TABLE,
> ,,MAIL_MESSAGES$pKey,SYSTEM TABLE,
> ,,QUESTIONS$pKey,SYSTEM TABLE,
> ,,SECTIONS$pKey,SYSTEM TABLE,
> ,,SEQUENCE$pKey,SYSTEM TABLE,
> ,,SUBJECTS$pKey,SYSTEM TABLE,
> ,,TEMPLATES$pKey,SYSTEM TABLE,
> ,,THEMES$pKey,SYSTEM TABLE,
> ,,UNITS$pKey,SYSTEM TABLE,
> ,,USERS$pKey,SYSTEM TABLE,
> ,,eudb$db$Cols,SYSTEM TABLE,
> ,,eudb$db$Cols$pKey,SYSTEM TABLE,
> ,,eudb$db$Indexes,SYSTEM TABLE,
> ,,eudb$db$Tables,SYSTEM TABLE,
> ,,eudb$db$Tables$pKey,SYSTEM TABLE,
> ,,COURSES,TABLE,
> ,,COURSE_ENROLLMENTS,TABLE,
> ,,COURSE_LOCK,TABLE,
> ,,COURSE_SUBJECTS,TABLE,
> ,,EXAM_ENTRIES,TABLE,
> ,,GRADES,TABLE,
> ,,LESSONS,TABLE,
> ,,LOCALES,TABLE,
> ,,MAIL_MESSAGES,TABLE,
> ,,MANAGERS,TABLE,
> ,,QUESTIONS,TABLE,
> ,,SECTIONS,TABLE,
> ,,SEQUENCE,TABLE,
> ,,SUBJECTS,TABLE,
> ,,TEMPLATES,TABLE,
> ,,TEMPLATE_COURSES,TABLE,
> ,,THEMES,TABLE,
> ,,UNITS,TABLE,
> ,,USERS,TABLE,
> ,,sub_mail_mailbox,TABLE,
> Database eudb is shutting down...
> Database eudb shutdown complete.
> -----------------------------------------------------------
> ----- Original Message -----
> From: Peter Hearty <peter.hearty@lutris.com>
> To: <instantDB@enhydra.org>
> Sent: Thursday, November 02, 2000 8:55 AM
> Subject: Re: InstantDB: Describe DB
>
>
> > Nathan
> >
> > Try any of:
> >
> > c show meta-data;
> > c system tables;
> > c ordinary tables;
> > c all tables;
> >
> > Other metadata commands can be found by looking in ScriptTool.java in
the
> > Examples directory or by referring to
> >
> >
>
http://instantdb.enhydra.org/software/documentation/sample-applications.html
> > #scriptool
> >
> > Regards
> >
> > Pete
> >
> > --
> >
> > Peter Hearty                         peter.hearty@lutris.com
> > Lutris Technologies (UK)        http://www.lutris.com
> > ----- Original Message -----
> > From: "Nathan Cook" <ncook@pcsedu.com>
> > To: <instantDB@enhydra.org>
> > Sent: Tuesday, October 31, 2000 5:57 PM
> > Subject: InstantDB: Describe DB
> >
> >
> > Is there a command that I can put into sql1.txt for startscripttool to
> > describe tables, or database, with field names and information?
> >
> > Thank You,
> > Nathan Cook
> > ncook@pcsedu.com
> >
> >
> >
>
> --------------------------------------------------------------------------
> ---
> > To unsubscribe from this mailing list, send email to
majordomo@enhydra.org
> > with the text "unsubscribe instantdb" in the body of the email.
> > If you have other questions regarding this mailing list, send email to
> > the list admin at owner-instantdb@enhydra.org.
> >
>
> --------------------------------------------------------------------------
--
> -
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe instantdb" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-instantdb@enhydra.org.
>
>
> --------------------------------------------------------------------------
---
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe instantdb" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-instantdb@enhydra.org.

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.