473,418 Members | 2,144 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,418 software developers and data experts.

JDBC and AS400

Hi,
I am using com.ibm.as400.access.as400JdbcDataSource(Jt400.jar ) to read data from DB2 on AS400 V5R3. But here binary is not getting translated. when tried on V5R1 it works. ie binary is getting translated.
I tried even setting the property translateBinary = true, but no luck.
Is there any specific settings required for AS400V5R3.Any Idea?

Thanks in advance
-BR
Sep 21 '05 #1
1 3069
UniDyne
18
Assuming you are working in a Windows environment, it might be a better idea to use a different approach. Instead of connecting to the DB2 database directly with IBMs JDBC driver, try using a Windows ODBC driver for DB2 to create an ODBC data source in Windows. Then use the JDBC/ODBC bridge to connect to the ODBC source. Generally, I have found that the more advanced features are better supported in the ODBC drivers than in the JDBC drivers in most packages. (The exception is Progress where the ODBC driver is crap and the JDBC driver is the only thing that works!)
Oct 5 '05 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: fn | last post by:
Can anyone help me understand what it takes to define a Linked Server connection to an IBM eSeries (AS400)? Do I need Microsoft's SNA Server or some other product or can I simply do it with the...
2
by: Niyazi | last post by:
Hi, I have to retrieve a data from AS400 DB2 and after working with data I have to export into one of existing Excel file. I can connect into specific library in AS400 DB2 using AS400...
2
by: Marc Stiegele | last post by:
Hello, I have a problem with the IBM DB2 UDB XML Extender. I`m working on a iSeries 400 server (AS/400, V5R1) with a integrated DB2 (my client is NT 4.0 Service Pack 1 with JDK1.1.8). I want to...
1
by: Robert Schneider | last post by:
Hi forum, can anyone tell me wether it is possible to adjust the journaling via JDBC? I have created a database (library) via CREATE SCHEMA which creates a journal and journal receiver...
0
by: Robert Schneider | last post by:
Hello everybody, we have the following problem with our Java application: Within our app we have connection pool for JDBC connections which always should be opened. We need this since several...
13
by: Sehboo | last post by:
Hello, we have data sitting on AS400 (V4R5M0) - DB2-400. I need to access that from my vb.net application. I don't know anything about AS400. Is it possible to get data from tables and stored...
1
by: tom.eeraerts | last post by:
Hello, I have a problem migrating an application from v5r2 to v5r3. The problem is with the prepared statements. To see what the problem is, i extracted a small piece of code and debugged the...
1
by: Iain | last post by:
Hi All I am creating a database trigger to write details real time from tables on one AS400 to another over our WAN. Is there such a concept as ODBC connections on the AS400 to perform this...
1
by: accyboy1981 | last post by:
Hi, I'm new to AS400 and am trying to copy the contents of a table from an SQL Server 2000 table to a table in AS400, I'm doing this using DTS. I'm connecting using the iSeries Access ODBC...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.