IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

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.


#TechXchangePresenter
 View Only
Back to discussions
Expand all | Collapse all

Specify Database Schema In AS/400 DB Connection

  • 1.  Specify Database Schema In AS/400 DB Connection

    Posted Fri May 25, 2012 04:35 PM

    I am trying to specify currentSchema when I build my AS400 db connection but it doesn’t seem to work. In otherProperties I have tried both libraries=, and currentSchema= and neither work. What is the correct parameter?

    [TABLE=“width: 100%”]
    [TR]
    [TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]Transaction Type[/TD]
    [TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined, align: left”]NO_TRANSACTION[/TD]
    [/TR]
    [TR]
    [TD=“class: oddrow, bgcolor: #E0E0C0, colspan: undefined, align: right”]DataSource Class[/TD]
    [TD=“class: oddrowdata-l, bgcolor: #E0E0C0, colspan: undefined, align: left”]com.ibm.as400.access.AS400JDBCDataSource[/TD]
    [/TR]
    [TR]
    [TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]serverName[/TD]
    [TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined, align: left”]MBJDEDV[/TD]
    [/TR]
    [TR]
    [TD=“class: oddrow, bgcolor: #E0E0C0, colspan: undefined, align: right”]user[/TD]
    [TD=“class: oddrowdata-l, bgcolor: #E0E0C0, colspan: undefined, align: left”]xCXC[/TD]
    [/TR]
    [TR]
    [TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]password[/TD]
    [TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined, align: left”]******[/TD]
    [/TR]
    [TR]
    [TD=“class: oddrow, bgcolor: #E0E0C0, colspan: undefined, align: right”]databaseName[/TD]
    [TD=“class: oddrowdata-l, bgcolor: #E0E0C0, colspan: undefined, align: left”][/TD]
    [/TR]
    [TR]
    [TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]portNumber[/TD]
    [TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined, align: left”][/TD]
    [/TR]
    [TR]
    [TD=“class: oddrow, bgcolor: #E0E0C0, colspan: undefined, align: right”]networkProtocol[/TD]
    [TD=“class: oddrowdata-l, bgcolor: #E0E0C0, colspan: undefined, align: left”][/TD]
    [/TR]
    [TR]
    [TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]Other Properties[/TD]
    [TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined, align: left”]libraries=TESTDTA;[/TD]
    [/TR]
    [/TABLE]


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


Related Content