File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes zipped EBCDIC in DB2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "zipped EBCDIC in DB2" Watch "zipped EBCDIC in DB2" New topic

zipped EBCDIC in DB2

jimbo jawgar

Joined: Oct 25, 2004
Posts: 4
Has anyone extracted zipped EBCDIC i.e. zipped mainframe data into a websphere java application? We believe the content is being converted to ASCII - which we need to disable.
Paul Clapham

Joined: Oct 14, 2005
Posts: 19973

That conversion may be taking place, but it isn't the classes from the standard Zip API that's doing it. It would be something in your code, if it's happening at all. But you don't even seem to be sure that it is happening. It might be a good idea to identify the problem before you start trying to solve it.

(For example, the people who are creating the zip file might be doing the EBCDIC-to-ASCII conversion as well.)
[ May 16, 2006: Message edited by: Paul Clapham ]
jimbo jawgar

Joined: Oct 25, 2004
Posts: 4
We had to load our zipped EBCDIC into a DB2 table defined as binary (We could not prevent ASCII conversion when reading from a var_char table). Thereafter byte-stream java IO was used, followed by unzip, then ASCII conversion
stu derby
Ranch Hand

Joined: Dec 15, 2005
Posts: 333
Thanks for the followup...
I agree. Here's the link:
subject: zipped EBCDIC in DB2
It's not a secret anymore!