Re: How to prevent leading spaces in SQL output

2017-01-26 Thread Harris, Steven
Hi Eric There are also the STRIP and TRIM sql functions - same function for these but slightly different syntax. SELECT strip(cast(float(used_space_mb)*100/total_space_mb AS DECIMAL(4,2))) FROM log However, when I tested this on a number less than 1, the implicit cast of the number to a strin

Re: 8.1 Linux client and IT13701 causing heartburn

2017-01-26 Thread Zoltan Forray
Heinz Have you heard anything back from IBM on your PMR? I just had another user call with the same problem, except that they ran traces to figure out where it was failing and the directory it stops on does not have but a few sub/nested directories. Fortunately, the TESTFLAGS workaround seems

Re: Advice for archiving 80 billion of small files.

2017-01-26 Thread Bo Nielsen
Hi All, Thanks you for all the replies. It was very helpful for me, but not for the management. I think they want anything else. Because many of the files have Japanese or Chinese characters, So it's difficult to index the Tar files. Regards Bo -Original Message- From: ADSM: Dist