Re: CCSID of files and JOB on AS400

["Ashish Kulkarni" <ashish.kulkarni13@xxxxxxxxx>]

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.