#DateForumTypeThreadPost
26211 Sep 2013 @ 11:11 PDTDatabaseReplyYou dont want the DBA to see the records?row level security is the most granular level security option provided in TD 14, to only allow the users with proper access rights to access the information. Previously one could secure the access ...
26111 Sep 2013 @ 10:55 PDTUDAReplycreating stored proceduresYou need to install the C/C++ compliler... this is required to compile the stored procedure!
26010 Sep 2013 @ 12:14 PDTDatabaseReplyYou dont want the DBA to see the records?If I am not wrong and understand your question corrently then I would say a DBA user who has created the database/user where you are creating the objects will have the implicit select access to the...
25910 Sep 2013 @ 12:06 PDTDatabaseReplyHelp me to improve the query performanceWithout looking at the table DDLs and EXPLAIN plain, I don't think its possible to suggest something. Share the table definition and explain plan to have a look.
25810 Sep 2013 @ 04:09 PDTGeneralReplyARCMAIN failed!!!!!1. Return Code 4 is for warnings, but the normal flow of the execution will continue. If you see the processing logs, there was a warning issued by the utility as the table SHIPMENT_SETL1_HIST...
25710 Sep 2013 @ 03:59 PDTPrivate Forum
25610 Sep 2013 @ 03:48 PDTDatabaseReplyImporting the large flat files failingHandling 900MB file is a piece of cake for Teradata... Its the tool that you are using or probably it could be your system's limitations as well. SQLA is not made to load such huge files... Tr...
25507 Sep 2013 @ 01:05 PDTGeneralReplyPlease convert query oracle to teradataNo Teradata doesn't have packages like Oracle does... Teradata UDFs have packages concept but that is also different from Oracle system...
25407 Sep 2013 @ 12:37 PDTDatabaseReplyDeleting duplicate rows in multiset tableRead the TD documentation, if you don't understand anything then post a specific question!!!!
25306 Sep 2013 @ 02:55 PDTUDAReplyCREATE NEW TABLE with COLUMNS FROM four QUERIES + CONSTANT FieldsNo the DDL is not correct. While defining Col1, CHARACTER is misspelled as CHRACTER... You need to correct that. Not exactly sure what you are asking in STEP 2... You need to ask questions with pr...
25206 Sep 2013 @ 02:48 PDTDatabaseReplyerror handiling in bteq errorCan't see anything wrong with the .IF or .GOTO syntax.... Can you try removing the space between the \ and teradataexportoutput.txt ??  
25106 Sep 2013 @ 02:33 PDTDatabaseReplySelect Failed: 3504: Selected non_aggregate values must be part of the associated groupYou are not using any aggregate function in your SELECT clause & on top of that you are already doing DISTINCT alongwith GROUP BY clause (both of which has the same impact) You can solve the e...
25004 Sep 2013 @ 12:25 PDTDatabaseReplyIs this the casting error? select substring(ID from 1 for index(ID, '*')-1), substring(ID from index(ID, '*')+1 for char_length(ID))  
24903 Sep 2013 @ 01:32 PDTDatabaseReplyWhich column should i select for Index creationI would go with Col4, as the data on both the AMPs is distributed equally, 50 & 51. In your case you can choose either one as the data count is small thus the PI selection won't make too m...
24802 Sep 2013 @ 12:45 PDTDatabaseReplyDoes Teradata support database/schema aliasesYou can't pass on database names as the parameter list. The dirty way could be that you can put a check using IF statement and then write two SQLs and fetch the results from TEST or PROD based ...
24730 Aug 2013 @ 10:52 PDTDatabaseReplyAuto select on PI The above query should give you idea as how many rows will land on a certain AMP, so you can add/remove the column list to choose the best suitable PI for the table... Generally the numeric/calcul...
24630 Aug 2013 @ 10:12 PDTAnalyticsReplyREPORT FROM MULTIPLES QUERY BEST APPROACH Re your create table issue... There is a typo... Change CHRACTER to CHARACTER in the definition of Col1...  
24530 Aug 2013 @ 09:34 PDTGeneralReplyNeed a function in Teradata which accepts a string and returns a integer listFollowing link should address your problem using recursive SQL if you can tune the query with the separator used in your string http://forums.teradata.com/forum/database/help-in-recursive-query-re...
24430 Aug 2013 @ 09:27 PDTDatabaseReplyAuto select on PI The PI once created on a table can't be changed simply. You will have to create a copy of the table with a different PI, insert the data in the second table, delete the base table and rename th...
24330 Aug 2013 @ 09:20 PDTDatabaseReplyColumnName is missing with error messagesI don't think that would be possible...
24226 Aug 2013 @ 10:02 PDTDatabaseReplyPropagate row data until next date is encounteredThe below post will give you some idea as how to start with... http://forums.teradata.com/forum/database/handling-missing-dates
24125 Aug 2013 @ 10:41 PDTDatabaseReplyvolatile table as select..with data - not loading dataYou got a working piece of code... What kind of help you are looking for? Sorry no magic wand!
24024 Aug 2013 @ 08:18 PDTDatabaseReplyCombine Multiple Select StatementsReplace the comma with dot in the first line.... t1,cnt should be t1.cnt 
23924 Aug 2013 @ 08:05 PDTDatabaseReplyvolatile table as select..with data - not loading dataWe can only make some guess without looking at the actual DDLs.... Share the tables DDLs and people here will definitely help you with both of your queries!
23824 Aug 2013 @ 07:55 PDTDatabaseReplyWhich column should i select for Index creation The below query will give you some stats about the data distribution as how many rows will be landing on different amps... Execute the query with different column list, you surely will be able t...

Pages