ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

DB2 - SQL Server

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • DB2 - SQL Server

    Hi All,

    I am trying to connect AS/400 with SQL Server using JDBC. I am able to connect it. But i dont know how to track the each and every activity. How to check the connectibity between two DB's...
    Regards,
    Vinothkumar S.

  • #2
    Re: DB2 - SQL Server

    What exactly did you want to track? If you are trying to access data from the AS400 on SQL Server use a linked server. Are you using JDBC bc you are going to use a java app?

    Comment


    • #3
      Re: DB2 - SQL Server

      Hi,

      I have to send some data from AS/400 to SQL Server. I want to ensure that below listed items.

      1. Connection between AS/400 to SQL Server
      2. Once i inserted records i need to check whether its completed successfully.

      Tracking of Connection and Verification of Transaction.
      Regards,
      Vinothkumar S.

      Comment


      • #4
        Re: DB2 - SQL Server

        Take a look at this presentation by Scott Klement. His example utilizes a return value so that you can determine whether the connection or SQL statement processed without error.

        http://www.scottklement.com/presentations/External%20Databases%20from%20RPG.pdf
        Michael Catalani
        IS Director, eCommerce & Web Development
        Acceptance Insurance Corporation
        www.AcceptanceInsurance.com
        www.ProvatoSys.com

        Comment

        Working...
        X