RE: SQL on qsys/qadbifld

You can also just do it for the job so the effect is minimal.


--
Jim Oberholtzer
Agile Technology Architects

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Thursday, August 03, 2017 8:51 AM
To: Midrange Systems Technical Discussion
Subject: Re: SQL on qsys/qadbifld

Many of us have ran CHGSYSVAL QCCSID to 37 right smack dab in the middle of the day with no negative repercussions. Chuck Pence raised a concern with that and you can search the archives for that.

Since your email address ends with ".it" your situation may differ.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: "gio.cot" <gio.cot@xxxxxxxxxxx>
To: <midrange-l@xxxxxxxxxxxx>
Date: 08/03/2017 09:13 AM
Subject: SQL on qsys/qadbifld
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Hi All

If i run this SQL Stmt “SELECT DBITXT, DBIHDG FROM qsys/qadbifld WHERE
DBILIB = ‘MYLIB” , in the DBITXT, DBIHDG I see strange chars like “ä ? À
: Ñ Á > À / “ … if I run CHGJOB CCSID(37) , then I see the DBITXT,
DBIHDG values OK . My SYSTEM CCSID is 65535



Is it normal ?

I run V7R1 but also in other OS Version



Thanks