Problem:
How can you access a table defined in XDB from a Java program.? Is there a way of connecting XDB with ODBC in Mainframe Express?
Resolution:
The XDB option in Mainframe Express is supplied together with an ODBC driver and interface. You will probaly have to install the ODBC driver manually before a ODBC data source is available.
The best environment to create a ODBC data source for XDB is via the Mainframe Express command prompt. Enter the two commands as below:
...\\>xdbodbcinst -i -p MFE3.0
...\\>odbcad32
On the System DSN tab, click Add.
Select Micro Focus MFE 3.0 XDB ODBC Driver, from the list of ODBC drivers.
Click Finish.
Configure the DSN by filling in the following fields:
Data Source Name - any name you choose.
XDB Path - enter the mfuser\\config directory for Mainframe Express.
Connection - choose between local and remote. If you choose remote, specify the IpAddress and TcpPort of your XDB server.
Server - name associated with the XDB Server.
Location - specify the XDB location you want to use.
User ID - XDB userid to use when connecting with this data source.
Current SQLID - authorisation ID to use when connecting with this data source. If you don't specify a SQLID, the UserID is used.
#EnterpriseDeveloper
#MFDS
