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 [PLUG]
From:
John Hohn <[log in to unmask]>
Reply To:
[log in to unmask]
Date:
Wed, 28 Feb 2007 08:53:00 -0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (70 lines) 
Robert, 

That sounds like a good and cheap (free?) approach for a generic 
conversion. The TIPS tools does lots of other stuff as well, like 
KSAM and flat file to SQL conversions, date conversions, 
converting individual fields  to 'non-default' SQL data types,  
inserting implied decimal points, etc.

It also has UEs allowing you to embed your own HP3000 logic 
during the SQL creation and/or extraction process. This has been 
used to apply 'business rules' to determine field values, correct 
invalid dates, etc. Basically it opens up the 'conversion' process to 
anything you feel like coding, while doing all the infrastructure 
tasks automatically.

Plus it's inexpensive. 

- John

Date sent:      	Wed, 28 Feb 2007 09:07:07 -0000
Send reply to:  	Robert Mills <[log in to unmask]>
From:           	Robert Mills <[log in to unmask]>
Subject:        	Re: [HP3000-L] Image to SQL converter
To:             	[log in to unmask]

> 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 *

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

ATOM RSS1 RSS2