21-04-2021

Agorus Driver

COBOL to DBase using Delphi??

I am using Delphi for two years but I'm totally blind to cobol.
I need to know how cobol data files are structured to import them to
dbase or paradox tables.
You someone has ANY clue, please tell me..

Thanks in advance

ooooooooooooooooooooooooooooooooo
o Paulo Oliveira o
o http://www.nca.pt/individual/PaulOliveira o
ooooooooooooooooooooooooooooooooo

Welcome to the AORUS YouTube channel!Subscribe and stay tuned to get the latest updates on AORUS gaming hardware and gear! By popular demand, HERE IT IS! My quick guide to installing a customized Windows Boot and BIOS logo on your PC.The process will vary depending on your mother.

Re:COBOL to DBase using Delphi??

Paulo,

What version of COBOL?

Do you have the file layouts for the COBOL files or
the source code for the program that created the files?

If you have some of these things I might be able to help.

Paulo Oliveira <paulolive..@mail.telepac.pt> wrote in article
<33D7F396.7D88C..@mail.telepac.pt>..

Quote

> I am using Delphi for two years but I'm totally blind to cobol.
> I need to know how cobol data files are structured to import them to
> dbase or paradox tables.
> You someone has ANY clue, please tell me..
> Thanks in advance
> ooooooooooooooooooooooooooooooooo
> o Paulo Oliveira o
> o http://www.nca.pt/individual/PaulOliveira o
> ooooooooooooooooooooooooooooooooo

Re:COBOL to DBase using Delphi??

Hi, Paulo. Their several different kinds of Cobol data/file formats. One
is ISAM - which is a 'index sequential file- - which uses a Btree(aka
Active development usb devices driver windows 7. Btrieve) type structure for use with hard disk devices.

There is the usual magnetic tape type file - a simple sequential structure
- which may simply be transferred to a hard drive and access is strictly
reading each (logical) record in sequence starting with record one, then 2,
the 3, till end of tape (EOT) or End of File on a hard disk.

Now the 2nd format can be altered by using a simple one logical record is
the same size as the physical record(on tape) (or disk) - or where each
physical record contains two or more logical records - whatever the Cobol
program - and Job Control Language(on IBM Mainframes) set up for the
sequential file structure.

Lastly, Oracle supports PL -Cobol - a Cobol language based client/ server
type data structures - where Oracle is the database engine and SQL
statements are embedded into the Cobol source code.

Oracle supports the same embedded software protocol for several
other languages including C' - for PL-C. That is each compiler has a
special 'preprocessor that translates the SQL statements into calls to
Cobol based and/or 'C' based functions (which are in a special SQL/Cobol
or SQL/'C' library.

I hope that wasn't too confusing.

Lastly it is possible for any program - in any language - to transform any
internal data structure into a ASCII/Text file for Import/Export. A
description of ASCII/Text formats - aka 'comma delimited formats' may be
found on the Delphi 2 CD-ROM in one of the directories that contains a file
filled with technical articles. sorry I can be more specific but I haven't
looked at since Feb., '97.

I hope this helps.

Regards, -= Lou =-
library

Bob Findley <bfind..@cheney.net> wrote in article
<01bc9945$211a5be0$15141..@Bob.DC>..

Quote

> Paulo,
> What version of COBOL?
> Do you have the file layouts for the COBOL files or
> the source code for the program that created the files?
> If you have some of these things I might be able to help.
> Paulo Oliveira <paulolive..@mail.telepac.pt> wrote in article
> <33D7F396.7D88C..@mail.telepac.pt>..
> > I am using Delphi for two years but I'm totally blind to cobol.
> > I need to know how cobol data files are structured to import them to
> > dbase or paradox tables.
> > You someone has ANY clue, please tell me..
> > Thanks in advance
> > ooooooooooooooooooooooooooooooooo
> > o Paulo Oliveira o
> > o http://www.nca.pt/individual/PaulOliveira o
> > ooooooooooooooooooooooooooooooooo

Re:COBOL to DBase using Delphi??

Quote

Paulo Oliveira <paulolive..@mail.telepac.pt> wrote:
>I am using Delphi for two years but I'm totally blind to cobol.
>I need to know how cobol data files are structured to import them to
>dbase or paradox tables.

You best bet is probably to use a small Cobol program that will read in
the file and export it to a format of your choice.

It's not THAT hard, after all. The main issue will often be to know with
which Cobol compiler it was generated.

BTW, if you need to have the Cobol program written, we can do this
(commercially, however).

-------------------------
Frederic G. Biosta driver download for windows 10 7. MARAND
Agorus SA / OSI SARL
mailto: f..@soon.com
http://www.chez.com/osi

Re:COBOL to DBase using Delphi??

Quote

Frederic MARAND wrote:
> Paulo Oliveira <paulolive..@mail.telepac.pt> wrote:
> >I am using Delphi for two years but I'm totally blind to cobol.
> >I need to know how cobol data files are structured to import them to
> >dbase or paradox tables.
> You best bet is probably to use a small Cobol program that will read in
> the file and export it to a format of your choice.

Or if there is an ODBC driver for the COBOL data you need available you
could just
save yourself alot of hair and access the data directly.

Pity it didn't work out that way for me, but it is worth a few minutes
to
research.

--
Windows feeds my body. Linux feeds my soul.
All opinions expressed are mine.

Re:COBOL to DBase using Delphi??

In article <33F1CFF7.7..@voicenet.com> 'Michael C. Mitchell' <coldt..@voicenet.com> writes:

Quote

>> >I am using Delphi for two years but I'm totally blind to cobol.
>> >I need to know how cobol data files are structured to import them to
>> >dbase or paradox tables.
>> You best bet is probably to use a small Cobol program that will read in
>> the file and export it to a format of your choice.
>Or if there is an ODBC driver for the COBOL data you need available you
>could just
>save yourself alot of hair and access the data directly.
>Pity it didn't work out that way for me, but it is worth a few minutes
>to
>research.

If you have a lot of data to move then you might consider either Data Junction
for Windows, or hiring the services of a data conversion company.

Re:COBOL to DBase using Delphi??

Quote

> >Pity it didn't work out that way for me, but it is worth a few minutes
> >to
> >research.
> If you have a lot of data to move then you might consider either Data Junction
> for Windows, or hiring the services of a data conversion company.

Yeah my problem is the COBOL app resides on our Unix box
and is still in use. Just wanted to get at the data that is in there
:0

--
Windows feeds my body. Linux feeds my soul.
All opinions expressed are mine.

Re:COBOL to DBase using Delphi??

In article <33F2037C.2..@voicenet.com> 'Michael C. Mitchell' <coldt..@voicenet.com> writes:

Quote

>> >Pity it didn't work out that way for me, but it is worth a few minutes
>> >to
>> >research.
>> If you have a lot of data to move then you might consider either Data Junction
>> for Windows, or hiring the services of a data conversion company.
>Yeah my problem is the COBOL app resides on our Unix box
>and is still in use. Just wanted to get at the data that is in there
>:0

Check out Data Junction next. (tnt.com)

Re:COBOL to DBase using Delphi??

Quote

> Paulo Oliveira <paulolive..@mail.telepac.pt> wrote:
> >I am using Delphi for two years but I'm totally blind to cobol.
> >I need to know how cobol data files are structured to import them to
> >dbase or paradox tables.

If your data is stored in a datasource (like Sybase or Oracle) for which
ODBC drivers exists, the easiest thing is to access the data directly
from your Delphi code. If your data is being written by the cobol
program to sequential files, all you need to do is ftp it to a client
machine then just have your Delphi program read the data as it would any
other non-database file. We do this all the time with flat files
produced by cobol programs on the mainframe which are then ftp'ed to
client machines and read by VB programs (the process shouldn't be any
different with Delphi).

--
Ray Porter
Applications Analyst Programmer
Administrative Information Services, UNC-CH
Phone: 966-5878
email: l..@email.adp.unc.edu
dra..@email.unc.edu
Home Page: http://www.adp.unc.edu/~allrp/

'Meddle not in the affairs of dragons,
for you are crunchy and taste good with ketchup.'

1. cobol driver or cobol .dat converter

2. How to do multiple Key using DBase in Delphi 1.0

3. Date Fields in Paradox and Dbase when using Delphi 2

4. Read COBOL Tables from Delphi, is this possible?

Agorus Driver License Test

5. Delphi , DB2 and Cobol

6. Create MS Access dbase using Delphi

7. Problem using LIKE operator with DBASE files in Delphi

8. Calling a FM COBOL DLL from Delphi?

9. Accessing MicroFocus COBOL Files from Delphi

10. Calling Cobol DLL's from Delphi

Hi!

Are there good informations sources (books, FAQs, articles..) which
explain ways to optimize the performance of single user Delphi /
Paradox
database applications?

We use a database with over 100 tables, all in the same directory,
over 60
MB data.

BDE driver version: is BDE 4.0 faster?

BDE configuration:
- BLOCK SIZE setting: do higher values result in less 'overhead' time?
- FILL FACTOR setting: lower values = faster

Tables:
- more tables = more file handles: is this critical?

- more tables = more memory usage for data caching, can this be
monitored
(system resources) or 'profiled'?

- in-memory tables: are they faster? (btw. can a physical table be
read
into an in-memory table?) *)

Agorus Driver Jobs

- open table exclusive *)

- index files: speed up the search, but need memory.
= what about 'compact' indizes: didn't find them in the on-line help
for
paradox tables (dBase only).
= maintained index: unmaintained index is faster (until needed)?

- Transactions: do they significantly slow down the application?

- Stored procedures: can they be used for single user (local) database
applications?

- DBiAddfilter, DBiSetrange.. *)

- Native handles ('Native handles allow you to bypass BDE functions to
use
native SQL database APIs to create and manipulate tables. This
approach
can deliver substantial performance improvement.') *) - but it seems
that
this doesn't work for Paradox databases (doesn't appear in the list).

Aorus Driver Update

*) = the online help says this improves BDE performance

The BDE32 online help covers the topics in two pages:
'Improving BDE performance' and 'SQL performance tips'

Aorus Drivers B450

To be continued ..

Agorus Driver Updater

Michael Justin