HP3000-L Archives

March 2003, Week 4

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: Image to SQL
From:
Michael Berkowitz <[log in to unmask]>
Reply To:
Michael Berkowitz <[log in to unmask]>
Date:
Mon, 24 Mar 2003 09:26:37 -0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (29 lines) 
Robert Schlosser writes


Good Morning

        I have been asked to locate a tool that will create the SQL
        definition language from an Image database. We are just 
        looking for a tool that will create the SQL schema, not move
        any data between the databases.

        Thanks in advance for any suggestions.

Robert Schlosser _ MPE-CSM
Ochsner Health Plan
(504) 219-8134 
--------------------------------------------------------
If your database is attached via IMAGE/SQL, you can use the program SQLGEN.PUB.SYS.

Use the GEN TABLE command and put in the image database you want, or whatever owner you used at attachment, as the owner.  It will generate SQL statements in the file name it prompts you for.

Mike Berkowitz
Guess? Inc.

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2