unsupported datatype

["Bart Verweijen" <bart.verweijen@xxxxxxxxxxx>]

Hi,

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

Anybody has any idea how i can solve this ?

Thanks in advance,
Bart Verweijen
________________________________________________________
Look at Aikido Samoerai Limburg's website at
http://www.aikido-samoerai.com (Dutch)


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