#DateForumTypeThreadPost
3607 Feb 2012 @ 07:12 PSTDatabaseReplyis this a range_n partition or case_n partition? yes. That is a good recommendation.
3503 Feb 2012 @ 02:46 PSTGeneralReplynext levels in a DW career Enterprise architect?
3403 Feb 2012 @ 01:47 PSTDatabaseReplyis this a range_n partition or case_n partition? Does anybody know about this?
3303 Feb 2012 @ 01:46 PSTDatabaseReplycan we execute a macro inside a stored procedure? Thanks!
3202 Feb 2012 @ 09:31 PSTDatabaseTopiccan we execute a macro inside a stored procedure? Inside a stored procedure, does it allow an execution of macros?
3102 Feb 2012 @ 09:03 PSTDatabaseTopicis this a range_n partition or case_n partition? Hi, lots of the tables in our database are partition by YR. The create table syntax is like : create table (YR smallint, ... ) Unique primary index (YR, ....) partiti...
3016 Nov 2011 @ 09:58 PSTDatabaseTopicIs Teradata JDBC 13.0 and TARA 13.0 supported on TD13.10? We are currently on Teradata 13.0 and looking forward upgrading to 13.10 soon. I want to find out if the JDBC13.0 and the backup software TARA 13.0 is supported after upgrade to 13.10. Any ...
2918 Aug 2011 @ 12:41 PDTExtensibilityReplyHow to convert coordinates between different "GeospatIal reference system" ? The st_transform format is as follow, SELECT a.*, geom_col.ST_TRANSFORM(x.srtext, y.srtext) AS new_geom_col FROM table a, sysspatial.spatial_ref_sys x, sysspatial.spatial_ref_sys y WHERE x.a...
2817 Jun 2011 @ 11:37 PDTDatabaseTopicAnybody have problem using the Teradata Geospatial packages?We upgraded to TD13 with its Teradata Geospatial companent two years ago. But in these two years we have been struggling to get the Geospatial package to run into our envirnement. Lots of probl...
2730 Jul 2010 @ 10:02 PDTThird Party SoftwareReplySecurity Code vulnerabilities in Informatica seciprts, BTEQ ScriptsStore log in information in BTEQ scripts.
2613 Jul 2010 @ 07:51 PDTToolsReplyVisual Explain V 13 CrushedWe had opened up an incident for Teradata support. The query we were trying to do was just a simple select from a table contained geospactial data type. And we go the same error : please do not res...
2512 Jul 2010 @ 03:09 PDTToolsTopicfastload windows 64-bit?Does fastload/fastexport has windows 64-bit version?
2427 Feb 2009 @ 02:48 PSTDatabaseTopicTeradata Database 12I would like to know what are the tools and utilies bunbled with TD 12? For example, Teradata dynamic workload manager, Teradata Warehouse Miner and Teradata profiler. When i search online, it seem...
2325 Aug 2008 @ 05:47 PDTDatabaseReplyhow to write a function to retrieve random character from A TO ZI tried this query and it just worked fine to me.
2218 Aug 2008 @ 10:29 PDTDatabaseTopicdefault charactersetI changed the user default characterset to LATIN. But whenever I am using CREATE TABLE AS statement, the default characterset for string fields are still unicode. For example:create table test as(s...
2129 Jul 2008 @ 04:55 PDTDatabaseReplyhow to clean a user's maxpermThank you guys. I used modify user to change the permanent space to 0 bytes
2025 Jul 2008 @ 10:18 PDTDatabaseTopichow to clean a user's maxpermI have moved 5G permspace under user A for his stored procedures. After he finished the task, he dropped his procedures and I tried to move out this 5G permspace back to other database. Move space ...
1922 Jul 2008 @ 02:35 PDTUDAReplyTimestamp with a value of "2008-07-07 16:41:60"Maybe it should be '2008-07-07 10:42:00'
1815 Jul 2008 @ 12:13 PDTDatabaseReplyHow to find out who has loaded the table recently ?Or take a look at the dbc.tablesx. check to see what time and which accout created that table. But this way you can only know the table strcture changes of a specific table. For insert statement, y...
1715 Jul 2008 @ 12:06 PDTDatabaseReplyJDBC connection ErrorWhich version of the Teradata JDBC Driver you are using? I have the same problem after I sent out a large serial job. It could not exist peacefully in the program.
1626 Jun 2008 @ 02:41 PDTDatabaseReplyConnecting Teradata from JavaDown load the Teradata JDBC driver from Teradate website... then1. set up connection private void buildCon() { try { Class.forName("com.ncr.teradata.TeraDriver"); con = DriverM...
1526 Jun 2008 @ 01:01 PDTDatabaseTopicHow does the function 'not in' perform with a column has null valueI have these three sql but give me different results:select count(*) from caestg1.zipcodeswhere zip_cd not in(select zip_cd from updatearea.zipcodes_new where zip_cd is not null);** result returns ...
1417 Jun 2008 @ 11:40 PDTDatabaseReplywhat kind of query being logged in dbqlogtbl? how to enable logging for an account?If I enable the query log of every account for every query step, will it use up a lot of DBC sapce?
1317 Jun 2008 @ 11:27 PDTDatabaseReplyFastExport to TextBut we need a tab delimited flat file output as our final result.
1216 Jun 2008 @ 11:21 PDTDatabaseTopicwhat kind of query being logged in dbqlogtbl? how to enable logging for an account?I didselect distinct(clientid) from dbc.dbqlogtbl;The result come back does not include all the accounts in our databases, which means some of the account do not have any query log history. How cou...

Pages