Hi,
there's a way (driver) to attach files DBF to 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.


Another solution is a way to use dbf file in informix, like "linked server" ?

The goal is to manage (read/write) dbf file via informix!

I ran a test in FoxPro 9, there is an option for a remote view using odbc. I did not see a way to create a link between two tables, however you create a table under Informix with the same columns then insert the data using the remote view.

I am not sure this is what you are looking for.

Thanks,
for your reply.

I don't understand well, I can connect via odbc a dbf file with a table in informix?

Where possible, what kind of field i must create in Informix for a match with one memo field in the dbf file ?

Thanks, Francesco

I would need to know the field(s) being used with the dbf table. If it is text information I would suggest a char field. the maximum size is 32K. Can you post the table schema for the dbf table.

An example for the table could be (just an example):

memoid serial not null
memo char(512) yes

This is my schema:

Name T Length Dec Offset
---------- - ------ --- ------
CLCODCLI C 7 0 1
CLRAGSOC C 40 0 8
CLRAGSO2 C 30 0 48
CLINDIRI C 35 0 78
CL___CAP C 5 0 113
CLLOCALI C 30 0 118
CLPROVIN C 2 0 148
CLNAZION C 3 0 150
CLTELEFO C 18 0 153
CLTELFAX C 18 0 171
CLNUMCEL C 18 0 189
CLPERFIS C 1 0 207
CL_SESSO C 1 0 208
CLDATNAS D 8 0 209
CLLOCNAS C 30 0 217
CLPRONAS C 2 0 247
CLCODFIS C 16 0 249
CLPARIVA C 12 0 265
CLGRUCON C 7 0 277
CLPARTSN C 1 0 284
CLSCADSN C 1 0 285
CLCODPAG N 3 0 286
CLCODVET N 3 0 289
CLCODSPE N 3 0 292
CL_PORTO C 1 0 295
CLCODZON N 3 0 296
CLCODAG1 N 3 0 299
CLCODAG2 N 3 0 302
CLCODIVA N 3 0 305
CLCODVAL N 3 0 308
CLCODBAN C 7 0 311
CLCODBAB C 7 0 318
CL1MESCL N 2 0 325
CL2MESCL N 2 0 327
CLGIOSCA N 2 0 329
CL1SCONT N 5 2 331
CL2SCONT N 5 2 336
CLNUMLIS C 3 0 341
CLTIPFAT C 1 0 344
CLBOLFAT C 1 0 345
CLPREBOL C 1 0 346
CLALLEGA C 1 0 347
CLSOLLEC C 1 0 348
CLSCORPO C 1 0 349
CLCODLIN C 3 0 350
CLNUMCOR C 15 0 353
CL__NOTE M 4 0 368
CLATTBLO C 1 0 372
CLATTMOR C 1 0 373
CLCATCOM C 3 0 374
CLCONVEN C 4 0 377
CLINDWEB M 4 0 381
CL_EMAIL M 4 0 385
CL__TIPO C 1 0 389
CLSTACOD C 1 0 390
CLIDEBAN C 16 0 391
CL__FIDO N 11 0 407
CLPERPRO N 5 2 418
CLSOCIO N 1 0 423
CLSCVALO N 2 0 424
CLSETINT N 1 0 426
CLDATINT D 8 0 427
CLSPEFIS N 2 0 435
CLSPETEL N 2 0 437
CLSPETRA N 2 0 439
CLPERMA1 N 5 2 441
CLPERMA2 N 5 2 446
CLPERMA3 N 5 2 451
CLPERMA4 N 5 2 456
CLPERMA5 N 5 2 461
CLPERMA6 N 5 2 466
CLPERMA7 N 5 2 471
CLPFEDBA N 5 2 476
CLRIFERI N 13 0 481
CLFLARID C 1 0 494
CLRAGEFF C 1 0 495
CLDALEFF D 8 0 496
CLALEFFE D 8 0 504
CLFATANT N 1 0 512
CLSCOLIN N 1 0 513
CLCODVEF C 7 0 514
CLULTFAT N 11 0 521
CLPERAG1 N 5 2 532
CLPERAG2 N 5 2 537
CLTIPVET C 1 0 542
CLBUSTAF C 1 0 543
CLFLGARE C 8 0 544
CLMICROA N 7 0 552
CLGIROUR C 1 0 559
CLNUMIN1 N 3 0 560
CLORARI1 C 4 0 563
CLTIPRI1 C 1 0 567
CLNUMIN2 N 3 0 568
CLORARI2 C 4 0 571
CLTIPRI2 C 1 0 575
CLNUMIN3 N 3 0 576
CLORARI3 C 4 0 579
CLTIPRI3 C 1 0 583
CLNUMIN4 N 3 0 584
CLORARI4 C 4 0 587
CLTIPRI4 C 1 0 591
CLNUMIN5 N 3 0 592
CLORARI5 C 4 0 595
CLTIPRI5 C 1 0 599
CLFER1DA D 8 0 600
CLFER1AL D 8 0 608
CLFER2DA D 8 0 616
CLFER2AL D 8 0 624
CLTURNO N 2 0 632
CLFLGNOT C 1 0 634
CLDATBUN C 30 0 635
CLSCOMOD N 5 2 665
CLLIMVEN N 2 0 670
CLSCOFEX N 5 2 672
CLCIRCOS C 1 0 677
CL___CFO N 3 0 678
CL___TOL N 3 0 681
CLNUMIN6 N 3 0 684
CLORARI6 C 4 0 687
CLTIPRI6 C 1 0 691
CLSEDIVA C 1 0 692
CLCIRSED C 1 0 693
CLPASWRD C 10 0 694
CLFLGRIS C 1 0 704
CLCODSTU C 5 0 705
CL_INTRA C 1 0 710
CL_LOGIN C 10 0 711
CLSISPAG N 2 0 721
CLDESMER N 2 0 723
CLRAGFAT C 1 0 725
CLCODCIN C 1 0 726
CL__BBAN C 23 0 727
CL__IBAN C 4 0 750
CLSCOBAA N 5 2 754
CLSCOBAC N 5 2 759
CL3SCONT N 5 2 764
CL4SCONT N 5 2 769
CLINTMOR C 1 0 774
CLFLFTEM C 1 0 775
CLADDPID N 6 2 776
CLADDPED N 6 2 782
CLSTAMAN C 1 0 788
CLVALDDT C 1 0 789
CLINVMSG C 1 0 790
CLSCOINC N 6 2 791
CLADDVAL N 6 2 797
CLSCOSOP N 6 2 803
CLFLGOTC C 1 0 809
CLLISONL C 1 0 810
CLADDIZ1 N 6 2 811
CLADDIZ2 N 6 2 817
CLADDIZ3 N 6 2 823
CLADDIZ4 N 6 2 829
CLSPREAD N 6 2 835

The best answer I can give you is the memo field is comparable to either text or byte data fields. Use text for text information, and byte for binary images.

These datatypes are stored in the dbspaces created for IDS version 9.40 through 11.70. With Standard engine you can not use these datatypes.

You should check with the informix sql documentation for more information.

IBM Informix Products

I hope this helps.