#DateForumTypeThreadPost
2116 Jun 2016 @ 05:21 PDTDatabaseReplyFastload not picking decimal valueHi, iam loading from file to table, where table is having datatype varchar(100)
2015 Jun 2016 @ 04:36 PDTDatabaseTopicFastload not picking decimal valueHi , i have txt file with decimal values. iam trying to load file to table(staging table with varchar datatype) i have used format as vartext in fastload script, in table its not populating deci...
1914 Jun 2016 @ 02:30 PDTDatabaseTopicRetrive data from tableHi team, I have table A with four fields Empid,ename,salary,partyid. i want to fetch data from table a where atleast of one of field Empid or Partyid should be not null value. if both fields are ...
1810 May 2016 @ 04:07 PDTDatabaseReplysql to retrive data from same column with differnt criteriaThank You AtardecerR0j0.
1710 May 2016 @ 02:35 PDTDatabaseTopicsql to retrive data from same column with differnt criteriaHi,   ID Start_date                          last_upd&nb...
1621 Apr 2016 @ 04:42 PDTDatabaseTopicload Zip file using FastloadHi Team, i have an a huge file which is zipped, do we have any posibilites to load data from zip file to teradata using fastload without unzip the file.  
1512 Apr 2016 @ 11:43 PDTDatabaseReplyEphoc to teradata timestampThanks Dieter :)
1412 Apr 2016 @ 11:10 PDTDatabaseReplyEphoc to teradata timestampcan please provide sample sql
1312 Apr 2016 @ 10:04 PDTDatabaseReplyEphoc to teradata timestampThanks Carlos. can i know why we use 1970-01-01 date here. ,CAST(DATE '1970-01-01' + (cast(EMP_join_date as bigint)/86400000) AS TIMESTAMP(0)) + (((cast(EMP_join_date as bigint)/ 1000) ...
1212 Apr 2016 @ 04:30 PDTDatabaseTopicEphoc to teradata timestampHi , i have an a file with date column EMP_join_date 1454247163111 1453315790000   i have to convert into teradata timestamp. i have used below query ,CAST(DATE '1970-01-01' + ...
1111 Apr 2016 @ 01:04 PDTDatabaseReplymload deleteThanks Dieter
1011 Apr 2016 @ 12:42 PDTDatabaseTopicmload deleteHi team, i want to delete table and import data from file using mload. can u please provide script for delete and load data.
905 Apr 2016 @ 04:21 PDTDatabaseReplyAccess module error '61' in mload insertHi Dieter, yeah, my file has duplicate records. i have file as below  042|1450000|40.0|1488000 042|1450000|40.0|1488000 042|1450000|40.0|1488000 042|1450000|40.0|1488000 042|1450000...
805 Apr 2016 @ 01:00 PDTDatabaseTopicAccess module error '61' in mload insert    Hi Team, iam inserting data into table using txt file through mload.iam geeting below error.please help me out. **** 16:21:03 UTY4014 Access module error '61' received dur...
705 Apr 2016 @ 12:54 PDTDatabaseReplyUV tableThanks Dieter,Sakthi
604 Apr 2016 @ 02:44 PDTDatabaseReplyUV tabledo we need to wirte trim function in filter condition?
504 Apr 2016 @ 02:38 PDTDatabaseReplyUV tableupdate statement in script.   UPDATE table_name SET emp_name=:emp_name ,salary=:salary WHERE empid=':empid';   Log: Applyseq SourSeq  uniqness DBCERROR 1  58...
404 Apr 2016 @ 02:05 PDTDatabaseTopicUV tableHi ,   i have table with all datatype as varchar (100) ,i want to update the table by using txt file.i have defined all columns as *  varchar (100) in Mload script.when iam trying ...
323 Mar 2016 @ 03:58 PDTDatabaseReplyStore Negative decimal value into teradata datatypeThanks Sakthi its working fine :)
223 Mar 2016 @ 02:46 PDTDatabaseReplyStore Negative decimal value into teradata datatypeHi Dieter, i have two tables Table A and tablle B , where Table A has 26.66 67.1 0.0 -29.71 -1.0 19.98 having datatype as varchar. now i want to load data from table A to Table B(w...
123 Mar 2016 @ 02:02 PDTDatabaseTopicStore Negative decimal value into teradata datatypeHi ,   Could you please let me know what datatype to use to store below value., i have negative decimal value as well, i have tried using decimal,smallint,byteint,integer,bigint, but no luck...