× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. May 2010

Re: STRSQL displaying 'junk'

Larry

Maybe do a DSPFFD on the FROM files - I wonder if any are Unicode. This is a WAG, early in the morning here!

HTH
Vern

DrFranken wrote:
Running this SQL statement in interactive SQL.

SELECT qaezd0001o.qezalcsize, qaezd0001o.qezdtasize,
qaezd0001o.qezobjnam, qaezd0001d.qezdirnam1
FROM QAEZD0001O INNER JOIN QAEZD0001D on
qaezd0001O.qezdiridx= qaezd0001D.qezdiridx
WHERE qaezd0001o.qezalcsize > 1000000
ORDER BY qaezd0001o.qezalcsize DESC

I'm guessing most of you could run it on your machines un-altered. It runs but the displayed object Name and Directory names are unreadable and appear to be double byte perhaps??

Those fields in the tables are CCSID 1200.

What is my SQL Rookie mistake that does not display those fields correctly. I KNOW I have done this in the past!

My Job CCSID is 65535 and default CCSID is 37.

Same Results on V5R4, V6R1 and V7R1.

- Larry Bolhuis
Frankeni Technology Consulting, LLC
lbolhuis@xxxxxxxxxxxx


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.