MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » March 2014

Re: Why isn't Netserver converting stream file with CCSID 37? (created with SK's SQLQSH)



fixed

Scott,

Yeah, I can work-around it easily enough...just hoping to understand what's
going on.

Netserver is configured as CCSID 1252
I don't see anyplace off in a quick look to specify what gets translated
wand what doesn't.
But as I mentioned, it works on other .TXT files (and .TAB for that matter.)

While I've got your attention... :)
Is there a way in the SQL command,
1) to remove the leading LF, x'25' that gets put into the file
2) to specify the TAB char as the separator
3) to use a CRLF as a record separator

Thanks! (I'm going to owe you dinner again)
Charles




On Wed, Mar 5, 2014 at 3:44 PM, Scott Klement
<midrange-l@xxxxxxxxxxxxxxxx>wrote:

Hi Charles,

If you want, QShell can write the data to the file in ASCII. Just
pre-create your 'hhc_custs.txt' file in a different CCSID like this:

touch -C 819 /home/wiltc/hhc_custs.txt

Then when you output to the file, it should be translated to CCSID 819
(which is ISO-8859-1, a flavor of ASCII).

As for why NetServer would translate some files but not others... I'd
need to see how your NetServer is configured. In it's default
configuration, NetServer does no translation at all. But, you can
configure it to translate certain file types, et al, in the Netserver
settings that are found in i Nav.

Personally, I always prefer translation to be turned off in NetServer.
I prefer to do my translation in my programs (or by hand). The vast
majority of files I have in the IFS should not be translated, so I would
rather it not do so automatically.



On 3/5/2014 2:24 PM, Charles Wilt wrote:
All,

Playing around with Scott's "Improved DB2 Command for QShell" aka SQLQSH
found here

http://iprodeveloper.com/application-development/improved-db2-command-qshell

Ran the following:
sql -S -c "|" "select ccusnr, ccusnm from olsdta.corcustm" >
/home/wiltc/hhc_custs.txt

An I get nice pipe delimited stream file, when viewed via the green
screen
DSPF command

However, even I open it using my favorite text editor, Ultra Edit (UE)
via
Windows explorer, I get "garbage". Or at least untranslated EBCDIC. :)

From DSPF, for the first line I see
CCUSNR|CCUSNM

Hex
C3C3E4E2 D5D94FC3 C3E4E2D5 D425

From UE on windows I see the same hex values.

Now, I've got other text stream files in the same folder also coded as
CCSID 37 that open just fine in UE. So it doesn't appear to be a general
issue with Netserver.

If I FTP the file back to my PC, it get's translated properly. So the
issue appears to be just with Netserver and just with this file.

Does anyone have any thoughts as to why Netserver isn't converting this
file?

Thanks!
Charles

--
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.







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact