Results 1 to 6 of 6
  1. #1
    Join Date
    May 2011
    Posts
    3

    Unanswered: Access to Dbf File via Informix

    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!

  2. #2
    Join Date
    Sep 2004
    Posts
    51
    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.

  3. #3
    Join Date
    May 2011
    Posts
    3

    Access to Dbf File via Informix

    Quote Originally Posted by marymurny View Post
    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

  4. #4
    Join Date
    Sep 2004
    Posts
    51

    Access to Dbf File via Informix

    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

  5. #5
    Join Date
    May 2011
    Posts
    3

    Access to Dbf File via Informix

    Quote Originally Posted by marymurny View Post
    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

  6. #6
    Join Date
    Sep 2004
    Posts
    51

    Access to Dbf File via Informix

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •