Re: unsupported datatype

[Pete Hall <pbhall@xxxxxxxxxx>]

At 07:47 07/04/2001, Bart Verweijen wrote:
>I have a query that creates a file. I used a substring to get the 'month'
>out of a date (using substr(digits(date_field, 5, 2). When I run this query
>on a V4R4 machine and look at the file with Client Access SQL client, it
>looks OK; but when i look at the same file created on a V4R5 machine, it
>shows the month field like 'F0F5' iso '05'.

Check the CCSID of the file. That looks suspiciously like what you will see 
if the file CCSID = 65535 (hex). If that's the problem, to fix it, create 
the file with a CCSID compatible with your national language, or open the 
ODBC data source named QDSN_yoursystemname in ODBC administrator, go to the 
"Translation" tab and check the "Convert binary data..." checkbox.
Pete Hall
pbhall@execpc.com
http://www.execpc.com/~pbhall/

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---