Linking tables via JDBC?

Ask a Question related to Informix, Design and Development.

  1. #1

    Default Linking tables via JDBC?


    We have an Informix 9.21UC3-1 database on a RedHat Linux box. And we
    are evaluating a package from Transsoft Inc. that allows access to
    legacy ISAM data (on an RS/6000 in this case running AcuCOBOL) via
    JDBC/ODBC.

    I've read about (EGM?) linking tables from other data sources into the
    Informix engine. Is this possible in this scenario? EGM doesn't list
    as being available for Linux? Does this require EGM?

    I'd prefer JDBC as I know that works on a Linux box, I haven't noodled
    around with the libodbc* files they include on the UNIX side as I only
    have those for AIX.

    sending to informix-list
    Adam Williams Guest

  2. Similar Questions and Discussions

    1. JDBC MSSQL Driver Losing Tables?
      So, I had and developed an app fine with CFMX 6.1 running Apache 2. I moved it to a different server and everything pretty much works fine in all...
    2. Linking tables within document
      We often use tables with text in the cells. Some of the same information appears twice in a given document. It would be very helpful if we could make...
    3. Sort_Order Linking Tables
      Hi, I am trying to setup a database of all my Films/Games, and so far it has proven very successful. But at the moment I have seperatae pages for...
    4. Temp tables and jdbc 2.21.jc3 on IDS 9.4.UC1
      The following query uses a TEMP table. I get the results in dbaccess, but the query fails when submitted from a java program using JDBC 2.21.jc3......
    5. Problem with typed tables and JDBC
      I am just starting to use structured typed tables with JDBC and I am getting an error on an insert. My schema looks like this: CREATE TYPE...
  3. #2

    Default Re: Linking tables via JDBC?

    On Tue, 08 Jul 2003 08:52:03 -0400, Adam Williams wrote:

    With 9.xx you have another elegant solution to linking tables from other
    databases. You can create an external data access method and define the
    tables in the foreign database as tables using that access method. From
    then on you can treat the external table as if it were a native Informix
    table.

    Art S. Kagel
    > We have an Informix 9.21UC3-1 database on a RedHat Linux box. And we
    > are evaluating a package from Transsoft Inc. that allows access to
    > legacy ISAM data (on an RS/6000 in this case running AcuCOBOL) via
    > JDBC/ODBC.
    >
    > I've read about (EGM?) linking tables from other data sources into the
    > Informix engine. Is this possible in this scenario? EGM doesn't list
    > as being available for Linux? Does this require EGM?
    >
    > I'd prefer JDBC as I know that works on a Linux box, I haven't noodled
    > around with the libodbc* files they include on the UNIX side as I only
    > have those for AIX.
    >
    > sending to informix-list
    Art S. Kagel Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139