DBScheme
Hi all,
Is there anybody with an idea how i can use dbschema to get a table schema
PLUS the dbspace where the table has been defined. DBscheme seems to leave out
the spaces info. Using a product like ServerStudioJE seems to get the schema
Plus the spaces, any idea how they archive this?
Paul.
Try
Dbschema -ss -d <database>
Paul Watson
Tel: +1 913-400-2620
Mob: +1 913-387-7529
Web: www.oninit.com
Failure is not as frightening as regret.
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> Behalf Of PAUL GATHOGO
> Sent: 24 July 2007 06:27
> To: ids@iiug.org
> Subject: DBScheme [9616]
>
> Hi all,
>
> Is there anybody with an idea how i can use dbschema to get a
> table schema PLUS the dbspace where the table has been
> defined. DBscheme seems to leave out the spaces info. Using a
> product like ServerStudioJE seems to get the schema Plus the
> spaces, any idea how they archive this?
>
> Paul.
>
>
> **************************************************************
> *****************
> Forum Note: Use "Reply" to post a response in the
> discussion forum.
You are right, the syntax is:
dbschema -d databasenane -ss output_file_name
or use "dbschema -- " to get the full syntax.
Regards,
Mohammad Marwan.
Databases and Unix section head
Mediterranean Smart Cards Company
92 Eltahrir st., Dokki, Cairo, Egypt.
Tel: +20(2) 33331457
Mobile: +2 012 2449825
mmarwan@mscc.com.eg www.mscc.com.eg
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Paul Watson
Sent: Tuesday, July 24, 2007 2:31 PM
To: ids@iiug.org
Subject: RE: DBScheme [9617]
Try
Dbschema -ss -d <database>
Paul Watson
Tel: +1 913-400-2620
Mob: +1 913-387-7529
Web: www.oninit.com
Failure is not as frightening as regret.
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> Behalf Of PAUL GATHOGO
> Sent: 24 July 2007 06:27
> To: ids@iiug.org
> Subject: DBScheme [9616]
>
> Hi all,
>
> Is there anybody with an idea how i can use dbschema to get a
> table schema PLUS the dbspace where the table has been
> defined. DBscheme seems to leave out the spaces info. Using a
> product like ServerStudioJE seems to get the schema Plus the
> spaces, any idea how they archive this?
>
> Paul.
>
>
> **************************************************************
> *****************
> Forum Note: Use "Reply" to post a response in the
> discussion forum.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * * * * * * * * * * * * * * * * * * * * * * * *
This e-mail (including attachments) is classified as Mediterranean Smart Cards
Company confidential and proprietary information
The recipient hereby is committed to hold in strict confidence the contents of
this (e-mail, document, and information) and not to disclose to any third
party without the prior written consent of Mediterranean Smart Cards Company.
Recipient will be held liable for any unauthorized disclosure.
It is intended solely for the addressee. Unless you are the addressee, you may
not read, copy, use or store this e-mail in any way, or permit others to.
If you have received it in error, please notify the sender by return e-mail
and delete the message in its entirety, including any attachments
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * * * * * * * * * * * * * * * * * * * * * * * *
Watson, Thank you. Paul