webMethods

webMethods

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

AS 400 (DB2) - RPG Calls

  • 1.  AS 400 (DB2) - RPG Calls

    Posted Mon December 04, 2006 07:45 PM

    Hello,

    Is it possible to invoke a RPG call on an AS 400, using a JDBC Adapter (6.0.3), IS 6.0.1 ?

    The connection details are…

    VikasTest:AS400DataBase Details
    Connection Type JDBC Adapter Connection
    Package Name VikasTest
    Connection Properties
    Transaction Type LOCAL_TRANSACTION
    DataSource Class com.ibm.as400.access.AS400JDBCXADataSource
    serverName 10.33.44.22
    user eaiuser
    password ******
    databaseName
    portNumber
    networkProtocol
    Other Properties TranslateBinary=true;SelectMethod=direct;libraries=GH38373SWS;Prompt=false
    Connection Management Properties
    Enable Connection Pooling true
    Minimum Pool Size 1
    Maximum Pool Size 10
    Pool Increment Size 1
    Block Timeout (msec) 1000000
    Expire Timeout (msec) 1000000

    Thanks,
    Vikas.


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 2.  RE: AS 400 (DB2) - RPG Calls

    Posted Tue December 05, 2006 12:23 PM

    To what far i understand your question, JDBC adapter cannot be used to call RPG programs on AS 400. You can directly connect to the OS DB via JDBC, if the AS 400 supports JDBC and issue commands like Select, Delete, Update and Insert.

    Generally the adapter development kit is used to develop custom adapters that are capable of invoking remote functions on the end systems.

    HTH
    Bhavani Shankar


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB