Re: setting CCSID of QZDASONIT jobs

Hi Joe Sam,

This sounds viable.

You mean use AS400JDBCConnection.getServerJobIdentifier() to retrieve the 
job number after creating the connection
and construct a statement like 

CALL QSYS.QCMDEXC(CHGJOB JOB(NUMBER/USER/NAME) CCSID(65536)

and run this as a statement.execute() before performing any 
updates-inserts.

Thanks.. I will give it a go.

Best regards,
Eric Lee
DCS Transport & Logistics Solutions




"Joe Sam Shirah" <jshirah@xxxxxxxxxxxxx> 
Sent by: java400-l-bounces+eric.lee=dcstrans.com@xxxxxxxxxxxx
28/02/2005 16:47
Please respond to
Java Programming on and around the iSeries / AS400 
<java400-l@xxxxxxxxxxxx>


To
"Java Programming on and around the iSeries / AS400" 
<java400-l@xxxxxxxxxxxx>
cc

Subject
Re: setting CCSID of QZDASONIT jobs







    Hi Eric,

    Here's a possibility that should work.  Because of all the possible
non-standard variations, a conforming JDBC driver will allow *any* string 
to
be sent to the DBMS.  If the DBMS/OS understands how to interpret it, the
statement will be run.  In "Getting Started with the JDBC API", here's 
what
"SQL Conformance" at:

<
http://java.sun.com/j2se/1.5.0/docs/guide/jdbc/getstart/intro.html#1018592
>

says:

" One way the JDBC API deals with this problem is to allow any query 
string
to be passed through to an underlying DBMS driver... In fact, an 
application
query may be something other than SQL..."

    So, you should be able to pass a  CALL QSYS.QCMDEXC statement for
CHGJOB, using Statement.executeUpdate() or Statement.execute().  See

<
http://www-912.ibm.com/s_dir/slkbase.NSF/0/f1eaeecc0af19cc38625669100569213?OpenDocument

>

for an example with OVRDBF.


                                                         Joe Sam

Joe Sam Shirah -        http://www.conceptgo.com
conceptGO       -        Consulting/Development/Outsourcing
Java Filter Forum:       http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International?    http://www.jguru.com/faq/I18N
Que Java400?            http://www.jguru.com/faq/Java400


----- Original Message ----- 
From: "Eric Lee" <Eric.Lee@xxxxxxxxxxxx>
To: <JAVA400-L@xxxxxxxxxxxx>
Sent: Monday, February 28, 2005 6:50 AM
Subject: setting CCSID of QZDASONIT jobs


> Hi All,
>
> I need to set the ccsid of the QZDASONIT job started by a JDBC 
connection
> to 65535.
>
> I've tried changing the ccsid of the iSeries user profile that the JDBC
> connection uses - but that does not work
> with 65535 - it takes the sysval if you try to use 65535. (The ccsid of
> the qzdasonit job is set correctly if you use another value that forces
> conversion)
>
> Does anyone know of another way I can achieve this (without changing the
> sysval)?
>
> My problem is to do with the jobs writing a hex '3F' for certain 
accented
> characters which is causing problems when the character is read in.
>
> When the job is 65535 - (when I change the job's ccsid manually) the
> characters are written with a valid hex code.
>
> Best regards,
> Eric Lee
> DCS Transport & Logistics Solutions
>

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




******************************************************************************************
'This e-mail message is intended solely for the person to whom it is addressed 
and may contain confidential
or privileged information. If you have received it in error, please notify 
postmaster@xxxxxxxxxxxx and 
destroy this e-mail and any attachments. In addition, you must not disclose, 
copy, distribute or take any
action in reliance on this e-mail or any attachments. Any views or opinions 
presented in this e-mail are 
solely those of the author and do not necessarily represent those of the 
company. When addressed to our
customers, any quotations contained in this e-mail are subject to contract and 
are on the terms of The
Company's standard Conditions, a copy of which is available on request. Any 
errors or omissions in any
quotations or other information issued by The Company shall be subject to 
correction without any liability
on the part of The Company. Due to the nature of Internet communications, DCS 
cannot guarantee that this
communication, or any attachments, do not contain software viruses. We have 
taken every precaution to
minimize this probability but cannot accept any liability for damage which you 
may sustain as a result of
software viruses. We recommend you carry out your own virus checks before 
opening attachments.'

DCS Transport & Logistics Solutions Ltd.
Registered office: Newstead House, Lake View Drive, Sherwood Park, Annesley, 
Nottinghamshire, NG15 0DT
Registered in England no: 3373490
******************************************************************************************