Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #1994 > unrolled thread

Converting database from COBOL database to DBF

Started byZeljko <astinter@gmail.com>
First post2011-09-12 06:20 -0700
Last post2011-09-15 07:21 -0500
Articles 7 — 5 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  Converting database from COBOL database to DBF Zeljko <astinter@gmail.com> - 2011-09-12 06:20 -0700
    Re: Converting database from COBOL database to DBF dlzc <dlzc1@cox.net> - 2011-09-12 21:09 -0700
      Re: Converting database from COBOL database to DBF Zeljko <astinter@gmail.com> - 2011-09-15 03:08 -0700
    Re: Converting database from COBOL database to DBF John Martens <adsl672100@tiscali.nl> - 2011-09-13 07:39 +0200
      Re: Converting database from COBOL database to DBF Zeljko <astinter@gmail.com> - 2011-09-15 03:18 -0700
        Re: Converting database from COBOL database to DBF "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2011-09-15 21:23 +1000
          Re: Converting database from COBOL database to DBF "Willie Moore" <williem@wmconsulting.com> - 2011-09-15 07:21 -0500

#1994 — Converting database from COBOL database to DBF

FromZeljko <astinter@gmail.com>
Date2011-09-12 06:20 -0700
SubjectConverting database from COBOL database to DBF
Message-ID<64df97be-986e-4db2-839f-18d979bbd89b@t9g2000yqi.googlegroups.com>
I found some important data stored as COBOL database files with EFT,
FIN and KEY extensions. It seems that data  is stored as fixed rows
like in DBF files. Does anybody have a procedure or routine for
converting such data.

[toc] | [next] | [standalone]


#1997

Fromdlzc <dlzc1@cox.net>
Date2011-09-12 21:09 -0700
Message-ID<66420cae-a262-40d0-830e-cca0d927dcb3@z26g2000pre.googlegroups.com>
In reply to#1994
Dear Zeljko:

On Sep 12, 6:20 am, Zeljko <astin...@gmail.com> wrote:
> I found some important data stored as COBOL
> database files with EFT, FIN and KEY extensions.
> It seems that data  is stored as fixed rows like
> in DBF files. Does anybody have a procedure or
> routine for converting such data.

Looks like you can possibly connect to it via something like ODBC.
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/2275817c-8a65-421a-a346-364418d9e4fa

Here is a commercial product:
http://www.cobolproducts.com/datafile/data-viewer.html

... if you don't get better answers.

David A. Smith

[toc] | [prev] | [next] | [standalone]


#2012

FromZeljko <astinter@gmail.com>
Date2011-09-15 03:08 -0700
Message-ID<066b0f99-892f-4e52-87bd-28870cccf8d2@s2g2000vby.googlegroups.com>
In reply to#1997
On Sep 13, 6:09 am, dlzc <dl...@cox.net> wrote:
> Dear Zeljko:
>
> On Sep 12, 6:20 am, Zeljko <astin...@gmail.com> wrote:
>
> > I found some important data stored as COBOL
> > database files with EFT, FIN and KEY extensions.
> > It seems that data  is stored as fixed rows like
> > in DBF files. Does anybody have a procedure or
> > routine for converting such data.
>
> Looks like you can possibly connect to it via something like ODBC.http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/...
>
> Here is a commercial product:http://www.cobolproducts.com/datafile/data-viewer.html
>
> ... if you don't get better answers.
>
> David A. Smith

I tried via ODBC with no success.Commercial product you suggested is
too expensive.
Thanks, David.

[toc] | [prev] | [next] | [standalone]


#1998

FromJohn Martens <adsl672100@tiscali.nl>
Date2011-09-13 07:39 +0200
Message-ID<4e6eec73$0$30705$5fc3050@news.tiscali.nl>
In reply to#1994
it will be a one time operation,
does Excell or LibreOffice help do convert it once ?


Op 12-9-2011 15:20, Zeljko schreef:
> I found some important data stored as COBOL database files with EFT,
> FIN and KEY extensions. It seems that data  is stored as fixed rows
> like in DBF files. Does anybody have a procedure or routine for
> converting such data.

[toc] | [prev] | [next] | [standalone]


#2011

FromZeljko <astinter@gmail.com>
Date2011-09-15 03:18 -0700
Message-ID<6a6fa873-b973-4d2b-bade-d879628225df@n12g2000yqh.googlegroups.com>
In reply to#1998
On Sep 13, 7:39 am, John Martens <adsl672...@tiscali.nl> wrote:
> it will be a one time operation,
> does Excell or LibreOffice help do convert it once ?
>
> Op 12-9-2011 15:20, Zeljko schreef:
>
>
>
>
>
>
>
> > I found some important data stored as COBOL database files with EFT,
> > FIN and KEY extensions. It seems that data  is stored as fixed rows
> > like in DBF files. Does anybody have a procedure or routine for
> > converting such data.

I tried excell and later LibreOffice as you suggested but no success.
Problem is that fixed length rows are with no delimiters between
columns/fields, so every import resulting in putting every row in just
one field. Thank you John.

[toc] | [prev] | [next] | [standalone]


#2017

From"Stephen Quinn" <stevejqNO@bigpondSPAM.net.au>
Date2011-09-15 21:23 +1000
Message-ID<Zilcq.2461$7r4.1396@viwinnwfe02.internal.bigpond.com>
In reply to#2011
Zeljko

>>
EFT, FIN and KEY extensions
<<
IIRC one will be the database, one will be the index and the other will hold 
the database definitions (aka field sizes/types etc..).
I have no idea which is which though as I never got into COBOL - then again 
I might be thinking of another database altogether (failing memory<g>).
You might search google groups (the CLIPPER forum) going back to circa 1990+ 
for posts regarding conversions that have been done in the past and the 
tools used.

>>
Problem is that fixed length rows are with no delimiters between
columns/fields, so every import resulting in putting every row in just
one field
<<

Then you need to parse each line into the relevant fields.
Eg // sample code
ptr := FOpen( 'xyz', FREAD_ONLY )
j := 1
FOR i := 1 UPTO 20
    x := FRead( ptr, j, 55)
    oServer:Fieldput( F1, substr(x, 1, 20) )
    oServer:Fieldput( F2 := substr(x, 21, 30 ) )
    oServer:Fieldput( F3 := substr(x, 31, 40 ) )
    oServer:Fieldput( F4 := substr(x, 41, 50 ) )
    oServer:Fieldput( F5 := val( substr(x, 51, 55) ) )
    j += 55
NEXT
FClose( ptr )

You find the size of the data by trial and error or by examining the cobol 
file with a hexeditor.

CYA
Steve 

[toc] | [prev] | [next] | [standalone]


#2019

From"Willie Moore" <williem@wmconsulting.com>
Date2011-09-15 07:21 -0500
Message-ID<j4sqko$fsn$1@speranza.aioe.org>
In reply to#2017
Steven,

That is exactly how I did it when I had to move some data from COBOL to 
DBFs. If I remember correctly, the numbers wee not stored in ascii and I had 
to do a conversion but it has probably been 25 years since I have had to 
touch cobol.

Regards,
Willie

"Stephen Quinn"  wrote in message 
news:Zilcq.2461$7r4.1396@viwinnwfe02.internal.bigpond.com...

Zeljko

>>
EFT, FIN and KEY extensions
<<
IIRC one will be the database, one will be the index and the other will hold
the database definitions (aka field sizes/types etc..).
I have no idea which is which though as I never got into COBOL - then again
I might be thinking of another database altogether (failing memory<g>).
You might search google groups (the CLIPPER forum) going back to circa 1990+
for posts regarding conversions that have been done in the past and the
tools used.

>>
Problem is that fixed length rows are with no delimiters between
columns/fields, so every import resulting in putting every row in just
one field
<<

Then you need to parse each line into the relevant fields.
Eg // sample code
ptr := FOpen( 'xyz', FREAD_ONLY )
j := 1
FOR i := 1 UPTO 20
    x := FRead( ptr, j, 55)
    oServer:Fieldput( F1, substr(x, 1, 20) )
    oServer:Fieldput( F2 := substr(x, 21, 30 ) )
    oServer:Fieldput( F3 := substr(x, 31, 40 ) )
    oServer:Fieldput( F4 := substr(x, 41, 50 ) )
    oServer:Fieldput( F5 := val( substr(x, 51, 55) ) )
    j += 55
NEXT
FClose( ptr )

You find the size of the data by trial and error or by examining the cobol
file with a hexeditor.

CYA
Steve

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web