Convert Microfocus to DBF

[Goyo Santamaría]

How can I convert a Microfocus Cobol 3.0 data file to a DBF one?

[Thane Hubbell]

On Mon, 8 Jun 1998 15:20:10, "Goyo Santamaría"
<gsant...@coverlink.es> wrote:

> How can I convert a Microfocus Cobol 3.0 data file to a DBF one?
>

E-mail me. When I get home, where I have the program, I'll send you
the source I have for converting a file to .dbf format. It's not
pretty, but it works.

[a. h.]

In article <6lgvaj$383$1...@talia.mad.ibernet.es>,
gsant...@coverlink.es says...

[a. h.]

In article <Jl0PnHJ5PvPd-pn2-Wiy5Kx5qxRLJ@Dwight_Miller.iix.com>,
red...@ibm.net says...

>
>On Mon, 8 Jun 1998 15:20:10, "Goyo Santamaría"
><gsant...@coverlink.es> wrote:
>

>> How can I convert a Microfocus Cobol 3.0 data file to a DBF one?
>>
>

>E-mail me. When I get home, where I have the program, I'll send you
>the source I have for converting a file to .dbf format. It's not
>pretty, but it works.
>

could you please send me a copy of that utility I would like to try it.

[JCJ0347]

>How can I convert a Microfocus Cobol 3.0 data file to a DBF one?
>

If you only want to do this one-time and the file isn't overly large,
here's a quick and dirty. (Assumption is an indexed file to be converted.)

Write the file out as a sequential (somefile.txt) file.

Open somefile.txt in Excell.
Insert column headings, conforming to appropriate .dbf rules
for field names.

Save it as somefile.dbf.

I've done this a couple of times to put our customer locations
into a mapping product called MapLinx. It's not something you would
want to do every day, but it works for the ad hoc creation of .dbf.

James Jones.

[cba...@galstar.com]

In article <6lu71j$pev$1...@gaia.ns.utk.edu>,

ham...@utm.edu (a. h.) wrote:
>
> In article <6lgvaj$383$1...@talia.mad.ibernet.es>,
> gsant...@coverlink.es says...
> >

> >How can I convert a Microfocus Cobol 3.0 data file to a DBF one?
> >
> >
> >
>
>

I have converted many cobol files to dbf's. I first wrote a cobol program to
copy the cobol file to a flat (ascii) file. Then I wrote a Foxpro, Clipper,
dBase program to read the flat file into a data base (dbf) file. Might be a
utility to do this, but if so I am unaware of it. Cliff

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/ Now offering spam-free web-based newsreading

[Dave Johnson]

cba...@galstar.com wrote in message <6m3bjq$eog$1...@nnrp1.dejanews.com>...

>In article <6lu71j$pev$1...@gaia.ns.utk.edu>,
> ham...@utm.edu (a. h.) wrote:
>>
>> In article <6lgvaj$383$1...@talia.mad.ibernet.es>,
>> gsant...@coverlink.es says...
>> >
>> >How can I convert a Microfocus Cobol 3.0 data file to a DBF one?
>> >
>> >
>> >
>>
>>
>I have converted many cobol files to dbf's. I first wrote a cobol program
to
>copy the cobol file to a flat (ascii) file. Then I wrote a Foxpro,
Clipper,
>dBase program to read the flat file into a data base (dbf) file. Might be
a
>utility to do this, but if so I am unaware of it. Cliff
>
>

Most PC database packages have 'flat file' import, either comma delimited
(surround strings with quotes and put a comma between each field, eg "text
1", 12, "text2"..... etc), or fixed width (text 1 12text2.. etc). Same
holds for most spreadsheets as well - check out IMPORT commands/menus.
You'll still have to do the COBOL program to create the flat file though -
only potential problem is disk space as you'll need roughtly 3 times the
current file size (original, flat file, database) plus a bit for the indexes
(tip - most databases will let you load without indexes (delete the flat
file) then build an index.
DaveJ.