Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #1994 > unrolled thread
| Started by | Zeljko <astinter@gmail.com> |
|---|---|
| First post | 2011-09-12 06:20 -0700 |
| Last post | 2011-09-15 07:21 -0500 |
| Articles | 7 — 5 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | Zeljko <astinter@gmail.com> |
|---|---|
| Date | 2011-09-12 06:20 -0700 |
| Subject | Converting 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]
| From | dlzc <dlzc1@cox.net> |
|---|---|
| Date | 2011-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]
| From | Zeljko <astinter@gmail.com> |
|---|---|
| Date | 2011-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]
| From | John Martens <adsl672100@tiscali.nl> |
|---|---|
| Date | 2011-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]
| From | Zeljko <astinter@gmail.com> |
|---|---|
| Date | 2011-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]
| From | "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> |
|---|---|
| Date | 2011-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]
| From | "Willie Moore" <williem@wmconsulting.com> |
|---|---|
| Date | 2011-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