| # | Date | Forum | Type | Thread | Post |
|---|
| 5 | 07 Jan 2014 @ 08:03 PST | Database | Reply | Converting Number to Character | Khurram,
I don't need a fix amount of digits. for the number 0.011 for instance, i need 3 digits after the comma. For the number 12.100, I need one digit (12.1), for the number 14.000 I need n... |
| 4 | 07 Jan 2014 @ 05:38 PST | Database | Reply | Converting Number to Character | Thank you for the responses.
It's not exactly what I wanted.
@Saeed: I tried this as well. The result is fine for a number which has a value behind the comma, but not for all of the f... |
| 3 | 06 Jan 2014 @ 11:45 PST | Database | Topic | Converting Number to Character | I have a numeric value which I want to divide by 1000:
SELECT DISTINCT
Speed_Val_Down AS svd,
CAST(svd AS FLOAT) / 1000 AS div,
CAST(r... |
| 2 | 17 Jul 2013 @ 04:38 PDT | Tools | Topic | End of CSV File / Fastload | I wrote a fastload sript which works fine to load my CSV files. It looks like following:
sessions 2;
errlimit 25;
logon xxxx/yyyy,zzzz;
DROP TABLE scsDataImport;
CREATE TABLE scsDataImport... |
| 1 | 10 Jul 2013 @ 06:08 PDT | Tools | Topic | Using FastLoad for Volatile Table | I'm Trying to load data from a file into a volatile table. Following my FastLoad Job Script:
sessions 2;
errlimit 25;
logon xxxx/yyyy,zzzz;
CREATE VOLATILE TABLE yyyy.vt_employee (
... |
|
|