I repeat my previous post ....
<clip>
You can use cursors in SQL - and some 3rd party products have a proven
track record of translating image calls onto SQL calls on the target
database - but you would have to seriously consider the overhead of such
an approach.
</end clip>
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Robert Collins
Sent: 03 March 2006 13:58
To: [log in to unmask]
Subject: Re: [HP3000-L] Migration recommendations; PRELIMINARY INQUIRY
Several comments I have read leads me to think many of you have made the
change to Eloquence to reduce code changes.
You can implement an RDBMS without changing the DBGET's to SQL.
We have a piece that sits between the program and the RDBMS to intercept
the database calls, convert them to the appropriate SQL calls to the
RDBMS.
I think there are a couple of others out there who do this as well.
We built it because of the simple fact many shops want to go to SQL
Server or Oracle. But the amount of code changes to go native SQL code
would be massive.
The product is called the Transoft Data Access Module (TDAM).
Robert Collins
U.S. Sales Consultant
Transoft, Business Solutions Division
Computer Software Group plc
2000 Riveredge Pkwy, Ste 450
Atlanta, GA 30328
Phone #: 706-265-4110
Cell #: 770-789-1462
fax #: 706-265-1621
www.transoft.com www.computersoftware.com
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
Behalf Of Jerry Finn
Sent: Friday, March 03, 2006 4:46 AM
To: [log in to unmask]
Subject: Re: [HP3000-L] Migration recommendations; PRELIMINARY INQUIRY
> -----Original Message-----
> Behalf Of Mark Wonsil
...
> The term relational comes from relational mathematics, i.e. set >
theory. This is why there are union and intersection (join) functions.
...
> ImageSQL *is* an SQL interface for Image, so Adam's point stands that
> having an SQL interface does not a relational database make.
Excellent summary Mark.
Although SQL does not make a relational database, its development is
closely linked, and I think that's why they are confused so often. The
best explanation I've read of what a relational database is and how it
was derived from set theory was published in a series of articles from
Intelligent Enterprise magazine. Which starts at the link below
http://www.intelligententerprise.com/db_area/archives/1998/9810/feat4.jh
tml
At the link below it finally gets into how Edgar F Cobb wanted to
translate set theory in a computer language called Data Sublanguage
Alpha. It was never implemented but it provide the basis for SQL.
http://www.intelligententerprise.com/db_area/archives/1999/991602/online
2.jhtml
Jerry Finn
The Migration Factory
IBM Corporation
11400 Burnet Rd.
Austin, TX 78758
http://www-1.ibm.com/servers/eserver/migration/
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
The contents of this email are confidential to the intended recipient
and may not be disclosed. Although it is believed that this email and
any attachments are virus free, it is the responsibility of the recipient to confirm this.
Smith & Williamson Corporate Finance Limited - A member of the London Stock Exchange.
A member of M&A International Inc. http://www.mergers.net Registered in England No. 4533970. Authorised and regulated by the Financial Services Authority
Smith & Williamson Investment Management Limited, Registered No. 976145. Authorised and regulated by the Financial Services Authority.
Smith & Williamson Pension Consultancy Limited - Independent Intermediary. Registered No. 3133226. Authorised and regulated by the Financial Services Authority.
Smith & Williamson Fund Administration Limited, Registered No. 1934644. Authorised and regulated by the Financial Services Authority.
Smith & Williamson Limited - A member of Nexia International. Registered in England No. 4534022. Regulated by the Institute of Chartered Accountants in England & Wales for a range of investment business activities.
NCL Investments Limited, Registered No. 1913794.
Member of the London Stock Exchange authorised and regulated by the Financial Services Authority.
Registered Office: 25 Moorgate, London EC2R 6AY
Telephone: 020 7131 4000 http://www.smith.williamson.co.uk
Nexia Audit Limited - A member of Nexia International. Registered in
England No. 4469576. Registered to carry on audit work and regulated by the Institute of Chartered Accountants in England & Wales for a range of investment business activities.
Registered Office: 25 Moorgate, London EC2R 6AY
Telephone: 020 7131 4000 http://www.nexiaaudit.co.uk
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|