Re: CCSID of files and JOB on AS400

HiI can do that to transalate binary value, but if your java job is running
with CCSID 65535 on V5R3 and above it wont create connection.
But my question is there any standard or document which says dont use CCSID
65535 for files

Ash

On Fri, Nov 7, 2008 at 10:24 AM, Haas, Matt (CL Tech Sv) <
matt.haas@xxxxxxxxxxx> wrote:

JDBC has a translate binary setting. Here's an example connection string
(Toolbox driver) with that setting in it:

jdbc:as400://myas400.com/;translate binary=true;

Matt

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Jerry Adams
Sent: Friday, November 07, 2008 10:12 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: CCSID of files and JOB on AS400

In the iSeries ODBC connection set-up there is a "Translation" table which
has an option for translating 65535. Maybe JDBC has something similar.

Jerry C. Adams
IBM System i Programmer/Analyst
B&W Wholesale
office: 615-995-7024
email: jerry@xxxxxxxxxxxxxxx


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of rob@xxxxxxxxx
Sent: Friday, November 07, 2008 9:06 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: CCSID of files and JOB on AS400

Ash,

I did a CHGSYSVAL QCCSID to 37 during the middle of the day and never
looked back. Now, that doesn't change the CCSID of any existing files...
Others on the midrange-l list have followed my example. But we're corn
fed midwesterners and do not concern ourselves with supporting multiple
languages.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From:
"Ashish Kulkarni" <ashish.kulkarni13@xxxxxxxxx>
To:
"RPG programming on the AS400 / iSeries" <RPG400-L@xxxxxxxxxxxx>
Date:
11/07/2008 09:58 AM
Subject:
CCSID of files and JOB on AS400
Sent by:
rpg400-l-bounces@xxxxxxxxxxxx



HiWhat should be the CCSID of files and JOB on CCSID, for example if i am
in
USA, i can have files and job CCSID as 37
I have seen some files and JOB with CCSID 65535,
I know that Java JDBC connection does not work with CCSID 65535,
so is there a IBM document which shows not to use CCSID 65535

Ash
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.



--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.