Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2005
    Posts
    8

    Unanswered: Migration of proxy tables from Sybase

    Hi,
    I have a set of proxy tables in Sybase, which are required to be migrated to DB2.
    Could you please highlight the procedure for the same.

    Thanks,
    Saurabh.

  2. #2
    Join Date
    Apr 2005
    Posts
    41
    By 'proxy' table, I am assuming you mean that this is a Table in Sybase which maps to a remote table/view/procedure.

    In DB2, if you want to access non-DB2 data sources natively (ie via SQL), then you need to use the Federation technology in Websphere Information Integrator, and using this, you can define remote servers (ie a Sybase databases), and nicknames (ie a Sybase Table). You can then access the data as if it were a local DB2 Table.
    If you want to physically move the data from Sybase to DB2, then you have
    many options, such as II above, export/import, etc., but I believe moving this scenario is more complex then a simple export/import.

    There is an useful article on using II and Sybase:

    http://www-128.ibm.com/developerwork...m-0406purnell/

    The best source of information for Sybase -> DB2 Migarations is:

    http://www-128.ibm.com/developerwork...igrate/db.html

    Graham Martin
    http://www-306.ibm.com/software/data/db2/migration/

  3. #3
    Join Date
    Oct 2005
    Posts
    8

    Link between DB2 and MS Access

    Hi,
    Currently I am having MS Access linked to Sybase database. Could you please help me in creating the link between MS Access and DB2?

    Secondly, regarding the proxy tables in Sybase - the Web Sphere Information Integrator will only send the request to Sybase for Stored Procedures' resultset which is nothing but the "existing table" (Proxy table).
    But, what if Sybase is not there? Can we have a total substitute of those proxy tables in DB2 itself?

    Thanks,
    Saurabh.

Posting Permissions

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