HP3000-L Archives

February 2007, 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 converter
From:
Robert Mills <[log in to unmask]>
Reply To:
Robert Mills <[log in to unmask]>
Date:
Wed, 28 Feb 2007 09:07:07 -0000
Content-Type:
text/plain
Parts/Attachments:
text/plain (42 lines) 
John,

Why not use the tools that you already have available?

1) Create an Allbase DBE.

2) Attach your Image database(s) to the DBE.

3) Use SQLGEN's GENERATE ALL command to create the SQL schema.

You can also use SQLGEN's GENREATE LOAD command to create two SQL
scripts. One will unload your Image tables to flat files and the other
will load your SQL/2000 tables from the flat files.

regards, 
  
Robert W.Mills 
Systems Development Manager 
Pinnacle Arvato 
(020) 8309 3604 


-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of John Bawden
Sent: 27 February 2007 18:49
To: [log in to unmask]
Subject: [HP3000-L] Image to SQL converter

Looking for a program (preferably COBOL) to use DBINFO calls on HP3000
to produce SQL code to create a SQL/2000 database.
  Anyone know of something like this?
  TIA.



* 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