Re: Generating a File from STRSQL

[Mike <koldark@xxxxxxxxx>]

 I think Lawson software had something like that too. I don't remember what
I did there.

--
Mike Wills
http://mikewills.info
P: (507) 933-0880 | Skype: koldark


On Thu, Jan 14, 2010 at 1:51 PM, Alan Campin <alan0307d@xxxxxxxxx> wrote:

> The only gotcha I have heard about is Mapics wants all their tables created
> with 65535. For what reason I never found out.
>
> On Thu, Jan 14, 2010 at 12:25 PM, <rob@xxxxxxxxx> wrote:
>
> > Go for it.  I will say that someone expressed their reason for not going
> > it somewhere in the archives.  But I think it was one of those
> > multinational foreigners.  Feel free to browse the archives for ccsid.
> >
> >
> > Rob Berendt
> > --
> > Group Dekko Services, LLC
> > Dept 01.073
> > Dock 108
> > 6928N 400E
> > Kendallville, IN 46755
> > http://www.dekko.com
> >
> >
> >
> >
> >
> > From:   Mike <koldark@xxxxxxxxx>
> > To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> > Date:   01/14/2010 02:11 PM
> > Subject:        Re: Generating a File from STRSQL
> > Sent by:        midrange-l-bounces@xxxxxxxxxxxx
> >
> >
> >
> > 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.
> > --
> > 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.
> --
> 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.