Re: How proprietary is the "COBOL file system"
- From: "Pete Dashwood" <dashwood@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 1 Oct 2007 09:50:07 +1300
"Richard" <riplin@xxxxxxxxxxxx> wrote in message
news:1191178815.162798.149670@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Sep 30, 4:18 pm, "Pete Dashwood"
<dashw...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Can anyone tell me if MicroFocus COBOL can read Fujitsu ISAM files, and
vice
versa? What about Realia?
Obviously, at the source code level (SELECT and FD/01) the code is
compatible, but what about object level?
This is no better nor worse than with RDBMS or other databases. One
cannot put an Oracle database file into a PostgresSQL system. MySQL
data files can't work with Informix, etc. Of course the _source_ SQL
is (mostly) compatible, but data has to be extracted and reloaded to
move it, possibly with conversion.
It is trivial to export and import data and structure between RDBMS, and you
don't need to write a program to do it. The data is open and accessible. It
isn't trivial to do so with ISAM.
I agree that "interpretations" of the SQL standard are different between
various RDBMS and this is problematic for me at the moment as I need to
generate DDL for different RDBMS. I was surprised that DDL from ACCESS was
totally incompatible with MySQL and even with SQL Server (although less so
there). Some constructs like ALTER TABLE seem to work in any RDBMS without
change, others (PRIMARY KEY and referential integrity constraints are the
two worst offenders) need serious massaging. I have a separate called C#
program that reformats an ACCESS DDL "Baseline" to whatever is required and
the SQL generated into the load programs is automatically modified for the
target RDBMS. It is all working fine, but it was a lot of work...:-)
Is there a single PC ISAM system, or do all the COBOL vendors have their
own
proprietary indexed system which is delivered with their COBOL compiler?
C-ISAM file system is an X-Open standard and used by Informix, C (or
any C callable language), and MF Cobol. However, other ISAM systems
are faster, more compact, and more reliable. Btrieve was another ISAM
system that tried to be a standard system for all languages.
I know what I THINK the answer is, but would be gald to hear any other
facts/opinions about this.
.
- References:
- How proprietary is the "COBOL file system"
- From: Pete Dashwood
- Re: How proprietary is the "COBOL file system"
- From: Richard
- How proprietary is the "COBOL file system"
- Prev by Date: Re: How proprietary is the "COBOL file system"
- Next by Date: Re: How proprietary is the "COBOL file system"
- Previous by thread: Re: How proprietary is the "COBOL file system"
- Index(es):
Relevant Pages
|
