RE: How to view iSeries files using Quantum DB

If your files are defined with CCSID = 65535 they will be translated anyway.  
Normally CCSID = 65535 means binary data as opposed to text.

The better way to handle this problem is to correctly set the CCSID of the 
files/fields.

HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: wdsci-l-bounces@xxxxxxxxxxxx 
> [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> DBelcher@xxxxxxxxxxxxxxxxxxxx
> Sent: Wednesday, December 14, 2005 11:12 AM
> To: wdsci-l@xxxxxxxxxxxx
> Subject: RE: [WDSCI-L] How to view iSeries files using Quantum DB
> 
> Rick,
> 
> I basically did the same thing you did but did not put the 
> "...translate binary=true".  What does that do for/to you?
> 
> Douglas Belcher 
> KV Pharmaceutical 
> St Louis, MO 
> Opinions expressed are not necessarily those of my employer 
> 
>  
> 
> -----Original Message-----
> From: wdsci-l-bounces@xxxxxxxxxxxx 
> [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> Rick.Chevalier@xxxxxxxxxxxxxxx
> Sent: Tuesday, December 13, 2005 12:38 PM
> To: wdsci-l@xxxxxxxxxxxx
> Subject: RE: [WDSCI-L] How to view iSeries files using Quantum DB
> 
> 
> Richard,
> 
> I'm not sure if my version is the same but this how I set 
> mine up.  Hope it helps.
> 
>  Click on the new bookmark icon in the Database Bookmarks 
> view. In the driver selection window click browse. Navigate 
> to the folder containing jt400.jar and select jt400.jar. 
> Click open. After returning to the new driver window select 
> the IBM driver and click on the class browse button. Select 
> the class displayed. Click OK. In the URL prompt enter 
> "jdbc:as400://yoursystemnamehere;translate binary=true" and 
> click finish.
> 
> Rick
> 
> -----Original Message-----
> From: wdsci-l-bounces@xxxxxxxxxxxx 
> [mailto:wdsci-l-bounces@xxxxxxxxxxxx]On Behalf Of Weber, Richard
> Sent: Tuesday, December 13, 2005 12:19 PM
> To: wdsci-l@xxxxxxxxxxxx
> Subject: [WDSCI-L] How to view iSeries files using Quantum DB
> 
> 
> I finally got Quantum DB perspective to show up:  I upgraded 
> to 6.x Advanced and it just appeared.  (I love my magic computer!)
> 
> 
> 
> Not being one to look a gift horse in the mouth, now I'm 
> trying to figure out how to view an iSeries file with it.  
> The documentation I have found on SourceForge has not been 
> very helpful.  I'm trying to create a database bookmark, but 
> there is only one driver to choose from and even fewer 
> choices when I try to add one.  Anybody know the secret and 
> willing to share it? 
> 
> 
> 
> Richard L. Weber  |  Senior Systems Analyst, TOYS 'Я' US 
> International  |
> 973.617.3497  |  weberr@xxxxxxxxxxx <mailto:weberr@xxxxxxxxxxx>
> 
> 
> 
> 
> ==============================================================
> ==========
> This email message is for the sole use of the intended 
> recipient (s) and may contain confidential and privileged 
> information. Any unauthorized review, use, disclosure or 
> distribution is prohibited. If you are not the intended 
> recipient, please contact the sender by reply email and 
> destroy all copies of the original message. To reply to our 
> email administrator directly, send an email to EmailAdmin@xxxxxxxxxxxx
> Toys "R" Us, Inc.
> --
> 
> Privileged and Confidential.  This e-mail, and any 
> attachments there to, is intended only for use by the 
> addressee(s) named herein and may contain privileged or 
> confidential information.  If you have received this e-mail 
> in error, please notify me immediately by a return e-mail and 
> delete this e-mail.  You are hereby notified that any 
> dissemination, distribution or copying of this e-mail and/or 
> any attachments thereto, is strictly prohibited.
> 
> --
> This is the Websphere Development Studio Client for iSeries  
> (WDSCI-L) mailing list To post a message email: 
> WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change 
> list options,
> visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
> or email: WDSCI-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/wdsci-l.
> 
> 
> 
> 
> -- 
> This is the Websphere Development Studio Client for iSeries  
> (WDSCI-L) mailing list
> To post a message email: WDSCI-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
> or email: WDSCI-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/wdsci-l.
>