RE: Generating a File from STRSQL

["Roger Harman" <RHarman@xxxxxxxxxx>]

Scared the bejeebers out of me to think about it but I did when we moved
to our new system.  Just set it up as 37, restored our data, and away we
went.  On our Development system, I changed it mid-day and all was well.


> > > EDeLong@xxxxxxxxxxxxxxx 01/14/2010 10:06:38 AM >>>
I've not heard of any problems relating to changing this system value.
Several posts to the list (from Rob@dekko, I think) have mentioned this
being changed on a live production system without issue...  We did this
years ago (v5r1) and never encountered a problem.

-Eric DeLong

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike
Sent: Thursday, January 14, 2010 11:53 AM
To: Midrange Systems Technical Discussion
Subject: Re: Generating a File from STRSQL

I'll try this. I fear changing system values without knowing the
repercussions. But the system id is 65535.
--
Mike Wills
http://mikewills.info
P: (507) 933-0880 | Skype: koldark


On Thu, Jan 14, 2010 at 11:44 AM, Jack Kingsley
<iseriesflorida@xxxxxxxxx>wrote:

> will changing your job ccsid fix it.  chgjob ccsid(37)
>
> On Thu, Jan 14, 2010 at 12:30 PM, Mike <koldark@xxxxxxxxx> wrote:
>
> > I am creating some file dumps from our iSeries for download to the
PC.
> > Currently, to save time (and out of laziness) I am just having
STRSQL
> > create
> > the file for me. The problem I am having is that some of the fields
where
> I
> > am adding my own string value (SELECT myfield, 'myaddedstring' FROM
> > mytable), it puts the CCSID to 65535 instead of 37. This seems to be
> > causing
> > the PC to download the hex values in the fields vs. the actual text.
Is
> > there a way to force these values to CCSID 37?
> >
> > I discovered this after generating a SQL version of the file in
iSeries
> > Navigator.
> >
> > --
> > Mike Wills
> > http://mikewills.info
> > P: (507) 933-0880 | Skype: koldark
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing
> list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.