#DateForumTypeThreadPost
2020 Dec 2010 @ 08:46 PSTToolsReplyXML data format support by the TPT DataConnector OperatorAnd even Teradata JMS Universal connector will also load the data into the message queue in XML format (by default). http://developer.teradata.com/connectivity/reference/jms-install-guide/13-00-03/...
1917 Dec 2010 @ 09:39 PSTToolsReplyXML data format support by the TPT DataConnector OperatorThanks feinholz! Informatica PowerCenter ( realtime with JMS license) was used to load the data in the queue. I heard that , with default settings , informatica will load as XML format to JMS messa...
1807 Dec 2010 @ 09:03 PSTToolsReplyXML data format support by the TPT DataConnector OperatorSmall correction..looks like TPT DataConnector Operator will not support the XML *format*.My question is "Can we read the JMS queue data (which is having XML format) , using the TPT scipt, which us...
1706 Dec 2010 @ 09:14 PSTToolsTopicXML data format support by the TPT DataConnector OperatorHi, I need to write the TPT script, which will read from JMS queue and load the data to Teradata table. I am using Teradata databse v12 and JMS access module for teradata was installed. As far...
1615 Mar 2009 @ 09:27 PDTDatabaseTopicSearch and replace the special chractersHi, I have a table with one single column(LATIN character set). I got a requirement to search and replace the following special characters with blank value in that column.0xFFFE0xFFFFControl charac...
1513 Jan 2008 @ 04:32 PSTDatabaseTopicTimestamp calculationHi All,I have Table 1 with columns local_timestamp difference 2008-01-02 10:01:47 -360 2008-01-02 23:01:42 -240 2008-01-04 02:10...
1402 Jan 2008 @ 11:11 PSTDatabaseReplysubtracting from Timestamp column.Thanks Fred!
1327 Dec 2007 @ 07:26 PSTDatabaseReplysubtracting from Timestamp column.I tried with the below SQL, but it's not workingSel current_timestamp(0)- (time '06:00:00') hour to second(0)
1227 Dec 2007 @ 07:15 PSTDatabaseTopicsubtracting from Timestamp column.Hi, I am copying from one teradata table to another. Both the tables having timestamp(0) columns and the format is 'YYYY-MM-DDBHH:MI:SS'. While copying i need to perform table2 timestamp column...
1112 Dec 2007 @ 11:58 PSTDatabaseReplyhow to get only integer values from character fieldBalamurugan & Feroz, Thanks for your the solutions. Both the answers are useful to me.
1010 Dec 2007 @ 07:54 PSTDatabaseTopichow to get only integer values from character fieldHi, I have a table with one of the columns defined as character. This column contains integer values and character values also. I need to copy this data into another table which is having the integ...
902 Dec 2007 @ 08:46 PSTDatabaseTopichow to round the percentage?Hi, I am populating percentage calculation value to a decimal(5,2) field. I tried to cast the computed value to decimal(5,2), but unable to get the desired result. For example : select cast((1/...
820 Nov 2007 @ 05:25 PSTDatabaseTopicHow to cast the timestampHi All,I have a column in the table with timestamp(0) data type. My requirement is to extract the time portion of this column and compare if it is between 00:00:00 to 04:59:00 i.e upto morning 5 am...
720 Nov 2007 @ 05:24 PSTUDAReplyHow to cast the timestamp?Sorry, I should have posted this in Database section. I will post it there.
620 Nov 2007 @ 04:46 PSTUDATopicHow to cast the timestamp?Hi All, I have a column in the table with timestamp(0) data type. My requirement is to extract the time portion of this column and compare if it is between 00:00:00 to 04:59:00 i.e upto morning ...
520 Nov 2007 @ 04:17 PSTDatabaseReplyInserting current_timestamp value into timestamp(0) columnThanks Fred.My problem solved with your answer :-)Somesh, even your solution is working fine.
419 Nov 2007 @ 11:11 PSTDatabaseReplyInserting current_timestamp value into timestamp(0) columnThanks for th advise. My problem is I can't insert the the current_timestamp in timestamp(0) column.How to cast the current_timestamp to fit into the timestamp(0) data type?Just to give better idea...
318 Nov 2007 @ 07:13 PSTDatabaseTopicInserting current_timestamp value into timestamp(0) columnI have a tablecreate table stats( record_time TIMESTAMP(0) )For every load I need to populate the current_timestamp value into this column.I tried withinsert into stats (record_time )selectcurrent_...
217 Nov 2007 @ 04:47 PSTDatabaseReplycomparing the date with 11 monthsThanks Dieter!Your answer solved my question.- Rahul
116 Nov 2007 @ 04:38 PSTDatabaseTopiccomparing the date with 11 monthsHi, I have a table with the date column. create table driver ( insert_dt DATE format 'yyyy-mm-dd' ) I have to delete the records from this table which are older than 11 months based on inser...