Try the following:
Select MyField, Cast('MyAddedString' as VarChar(50) CCSID 37)
From MyFile
May be there are better solutions.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Mike
Gesendet: Thursday, 14. January 2010 18:30
An: Midrange Systems Technical Discussion
Betreff: Generating a File from STRSQL
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
midrange.com
