Re: Generating a File from STRSQL

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

Mike,

try 

SELECT myfield, CAST('myaddedstring'  AS CHAR(20) CCSID 37)
FROM mytable

With regards,
Carel Teijgeler

*********** REPLY SEPARATOR  ***********

On 14-1-2010 at 11:30 Mike 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.