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]