Re: SAP Sysbase ASE driver for db2 on zLinux
On Wed, Aug 5, 2020 at 2:17 AM Timothy Sipples wrote: > > So have you tried a JDBC driver for Sybase ASE, such as jConnect (filename > probably jconn4.jar), jTDS, or possibly Progress Software's? For example, > jConnect is included with SAP's SDK for ASE, and the driver itself is a > single file that should be named jconn4.jar. > > Thank you Tim, I appreciate your time. I passed along your message to our db2 and application teams hoping that it will help them to figure it out. Thanks! Gregory -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www2.marist.edu/htbin/wlvindex?LINUX-390
Re: SAP Sysbase ASE driver for db2 on zLinux
IBM includes this note in its support matrix for Db2 Federation ( https://www.ibm.com/support/pages/node/957245): "For other data sources not listed in Table 4, customer can also use federation server to access them and perform basic operations like querying remote data via JDBC wrapper, as long as the required JDBC driver comply with 6.0 standard. But they are not optimized so there might be some data types and functions not supported well and the performance is not expected to be as good as the optimized data sources." The reference to "6.0 standard" must be an error since there is no JDBC 6.0 yet. That could mean JDBC 4.0 (or higher) since the JDBC 4.0 specification was introduced with Java 6. So have you tried a JDBC driver for Sybase ASE, such as jConnect (filename probably jconn4.jar), jTDS, or possibly Progress Software's? For example, jConnect is included with SAP's SDK for ASE, and the driver itself is a single file that should be named jconn4.jar. - - - - - - - - - - Timothy Sipples I.T. Architect Executive Digital Asset & Other Industry Solutions IBM Z & LinuxONE - - - - - - - - - - E-Mail: sipp...@sg.ibm.com -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www2.marist.edu/htbin/wlvindex?LINUX-390
SAP Sysbase ASE driver for db2 on zLinux
Hello, Does anyone have any experience with Sysbase ASE and zLinux? We run Sysbase database on some other architecture but we have a db2 instance on zLinux which needs to be able to communicate with Sysbase via this driver. This driver is not available in db2 federation. I apologize if I am mixing terms but hopefully for someone who knows this stuff it will be clear what I am asking about. There is a sysbase client (which I was told includes the driver a db2 needs) on their website available for download, but there is no s390 version in there. There is AIX, pLinux, regular linux ... but no Z. I am hoping that there is a workaround or some open source driver which might replace this. thanks Best regards Gregory P -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www2.marist.edu/htbin/wlvindex?LINUX-390