#DateForumTypeThreadPost
931 Jul 2014 @ 04:56 PDTDatabaseReplyNeed Query for reading XML data from a CLOB objectHi, Also, since I doesn't know the exact syntax of the XMLPATH_SHRED0 , I don’t have an idea of how it can be used to full extent. Would it also be possible for you to send me the syntax...
831 Jul 2014 @ 04:42 PDTDatabaseReplyNeed Query for reading XML data from a CLOB objectHi Dieter, 1) I face a strange problem on the length of the column values displayed on Teradata SQL assistant (TSA). I read XML data from the CLOB column (Query provided below) and if an...
711 Jul 2014 @ 04:05 PDTDatabaseReplyNeed Query for reading XML data from a CLOB objectHi Dieter, Not sure of my TD server's OS type. Ill let you know on that. Also, on the above examples that i have posted in here, there were few sysxml functions being used like sys...
611 Jul 2014 @ 01:15 PDTDatabaseTopicXML data - Relational table data ComparisonHi Guys, Can some one pls suggest whats the best possible way to compare the XML data and relational table data on Teradata DB (DB Version : 14.0). I had to start off with one such thing very so...
511 Jul 2014 @ 01:10 PDTDatabaseTopicNeed Query for reading XML data from a CLOB objectHi Folks, I am an user of Teradata (DataBase version 14.0). I have a requirement to extract / read the XML data from the DB which is stored as a CLOB object. 1) Since we don't find ...
406 Jul 2014 @ 11:31 PDTGeneralReplyTimestamp with time zoneHi Dieter, thanks for your help. I will go ahead with writing UDF.     thanks a lot.
304 Jul 2014 @ 06:01 PDTGeneralReplyTimestamp with time zoneHi, thanks for the information. I switched to .NET connection. Now I can see the records with suffix +04:00 But i have this requirement. Time zone region('EST' or 'America Eastern&#...
203 Jul 2014 @ 11:19 PDTGeneralTopicMulti-lingual data supportHi All,   We are trying to load Chinese and Japanese characters into Teradata through informatica relational connection.  Is there any Teradata level and informatica level setting to be...
103 Jul 2014 @ 11:16 PDTGeneralTopicTimestamp with time zoneHi All, We are trying to load timestamp with time zone ( say EST or IST) into ‘timestamp(6) with time zone’ column. when i try to load the load with the ‘EST’ suffix it is ...