Re: [sqlite] Ordering looks incorrect

o the duck typing aspect. I've built it on a z/OS mainframe with very little changes and it works great in the z/OS UNIX environment. I'm wondering what it will take to get it to work in the native file system. On 2016/09/14 3:19 PM, David Crayford wrote: Of course. How do I do some

Re: [sqlite] Ordering looks incorrect

On 14/09/2016 9:23 PM, Clemens Ladisch wrote: David Crayford wrote: How do I do something similar to DB2 decimal() function which will add trailing zeros to precision? You could use the standard SQL CAST() to convert the value back into a number, by why not simply sort by the original

Re: [sqlite] Ordering looks incorrect

Of course. How do I do something similar to DB2 decimal() function which will add trailing zeros to precision? I tried round(col,6) but it knocked off the trailing zero like 12.12345. On 14/09/2016 9:10 PM, Clemens Ladisch wrote: David Crayford wrote: 9.733366 595.509361 29.117646 28.607606

[sqlite] Ordering looks incorrect

Greetings, I've just started using sqlite to (ironically) report on z/OS DB2 stats. I've written a query where the results look a bit strange. I group by the DB2 plan name and order by the maximum CPU time. The sort order looks incorrect as you can see in the report below. I'm certainly not di