Link Dbf To Informix
Francesco asked whether a driver exists to make an old Windows dBase/DBF application transparently read and write Informix tables instead of its .dbf files. Art Kagel said there is no direct way: the only in-server option would be building a Virtual Table Interface access method backed by library code that can read .dbf files, but he could find no such ready-made libraries. As practical alternatives he suggested the Perl DBD/XBase module or a cheap dBase viewer utility to convert .dbf data to delimited files and load it into real Informix tables, plus a pointer to the IDS 9.3 docs on IBM's InfoCenter. No transparent solution was found.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi, There's a way (driver) to attach files to DBF informix table ? I have a old Windows program which writes / reads dbf file. I seek a way to leave intact the old program, and make sure to "connect" the dbf files to the informix tables So that our old program continues to write / read dbf file, when in fact the writing / reading is performed on the Informix database. Thanks for your response, Francesco.
Not directly. You could use the Vitual Table Interface with some library code that can read .dbx files to map the .db file to a table. Art On May 19, 2011 5:24 AM, "Francesco Alfano" <edacedpa@yahoo.it> wrote: > Hi, > There's a way (driver) to attach files to DBF informix table ? > > I have a old Windows program which writes / reads dbf file. > > I seek a way to leave intact the old program, and make sure to "connect" > the dbf files to the informix tables > > So that our old program continues to write / read dbf file, when in fact > the writing / reading is performed on the Informix database. > > Thanks for your response, Francesco. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > --bcaec548a6db557e7904a3a45ac0
Il 19/05/2011 19:29, Art Kagel ha scritto: > Not directly. You could use the Vitual Table Interface with some library > code that can read .dbx files to map the .db file to a table. > > Art > On May 19, 2011 5:24 AM, "Francesco Alfano"<edacedpa@yahoo.it> wrote: >> Hi, >> There's a way (driver) to attach files to DBF informix table ? >> >> I have a old Windows program which writes / reads dbf file. >> >> I seek a way to leave intact the old program, and make sure to "connect" >> the dbf files to the informix tables >> >> So that our old program continues to write / read dbf file, when in fact >> the writing / reading is performed on the Informix database. >> >> Thanks for your response, Francesco. >> >> >> > Thanks for your response, where can i find documentation for IDS 9.30.UC2 ? Francesco.
Go to the Informix InfoCenter ( http://publib.boulder.ibm.com/infocenter/ifxhelp/v0/index.jsp), expand <+Servers> in the menu panel at the left, click on <IDS 9.x> under that, and you will see a link to the 9.3 docs in the panel at the right. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, May 20, 2011 at 2:21 AM, Francesco Alfano <edacedpa@yahoo.it> wrote: > Il 19/05/2011 19:29, Art Kagel ha scritto: > > Not directly. You could use the Vitual Table Interface with some library > > code that can read .dbx files to map the .db file to a table. > > > > Art > > On May 19, 2011 5:24 AM, "Francesco Alfano"<edacedpa@yahoo.it> wrote: > >> Hi, > >> There's a way (driver) to attach files to DBF informix table ? > >> > >> I have a old Windows program which writes / reads dbf file. > >> > >> I seek a way to leave intact the old program, and make sure to "connect" > >> the dbf files to the informix tables > >> > >> So that our old program continues to write / read dbf file, when in fact > >> the writing / reading is performed on the Informix database. > >> > >> Thanks for your response, Francesco. > >> > >> > >> > > > > Thanks for your response, > where can i find documentation for IDS 9.30.UC2 ? > > Francesco. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --20cf30549e6b8e06ba04a3af5c6f
Il 20/05/2011 08:38, Art Kagel ha scritto: > Go to the Informix InfoCenter ( > http://publib.boulder.ibm.com/infocenter/ifxhelp/v0/index.jsp), expand > <+Servers> in the menu panel at the left, click on<IDS 9.x> under that, and > you will see a link to the 9.3 docs in the panel at the right. > > Art Thanks for your reply.
Il 20/05/2011 08:38, Art Kagel ha scritto: > Go to the Informix InfoCenter ( > http://publib.boulder.ibm.com/infocenter/ifxhelp/v0/index.jsp), expand > <+Servers> in the menu panel at the left, click on<IDS 9.x> under that, and > you will see a link to the 9.3 docs in the panel at the right. > >>> Not directly. You could use the Vitual Table Interface with some library >>> code that can read .dbx files to map the .db file to a table. >>> Where can i find a set of "purpose function" to manage dbf (dBase... XBase) file ?
Hmm, I used to see libraries out there for this, but I'm not seeing any. Alternatives: 1. Here's a link to a Perl module that can read .dbf files. Then you could read them in Perl, write out delimited text files instead, and load the files into real Informix tables: http://search.cpan.org/author/JANPAZ/DBD-XBase-0.231/lib/XBase.pm 2. Here's a link to an inexpensive product that can convert .dbf files to delimited format: http://dbase-viewer.scalabium-software.qarchive.org/ Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, May 20, 2011 at 2:54 AM, Francesco Alfano <edacedpa@yahoo.it> wrote: > Il 20/05/2011 08:38, Art Kagel ha scritto: > > Go to the Informix InfoCenter ( > > http://publib.boulder.ibm.com/infocenter/ifxhelp/v0/index.jsp), expand > > <+Servers> in the menu panel at the left, click on<IDS 9.x> under that, > and > > you will see a link to the 9.3 docs in the panel at the right. > > > >>> Not directly. You could use the Vitual Table Interface with some > library > >>> code that can read .dbx files to map the .db file to a table. > >>> > > Where can i find a set of "purpose function" to manage dbf (dBase... > XBase) file ? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --bcaec5014c472033c804a3b3d0ad
Il 20/05/2011 13:56, Art Kagel ha scritto: > Hmm, I used to see libraries out there for this, but I'm not seeing any. > Alternatives: > > 1. Here's a link to a Perl module that can read .dbf files. Then you > > could read them in Perl, write out delimited text files instead, and load > > the files into real Informix tables: > > http://search.cpan.org/author/JANPAZ/DBD-XBase-0.231/lib/XBase.pm > > 2. Here's a link to an inexpensive product that can convert .dbf files to > > delimited format: > > http://dbase-viewer.scalabium-software.qarchive.org/ > > Art Thanks, Francesco.