#DateForumTypeThreadPost
507 Jan 2014 @ 08:03 PSTDatabaseReplyConverting Number to CharacterKhurram, 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...
407 Jan 2014 @ 05:38 PSTDatabaseReplyConverting Number to CharacterThank 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...
306 Jan 2014 @ 11:45 PSTDatabaseTopicConverting Number to CharacterI 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...
217 Jul 2013 @ 04:38 PDTToolsTopicEnd of CSV File / FastloadI 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...
110 Jul 2013 @ 06:08 PDTToolsTopicUsing FastLoad for Volatile TableI'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 (  ...