Re: Generating a File from STRSQL

[Jack Kingsley <iseriesflorida@xxxxxxxxx>]

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.