#DateForumTypeThreadPost
6204 Mar 2013 @ 01:03 PSTDatabaseReplySuggestion Required regarding derived table usageYou can create JI (Join INDEX) on the repeating tables/joins and make COGNOS go towards JI instead of tables directly, that would definately improve the performance.
6104 Mar 2013 @ 09:58 PSTDatabaseReplyDIFF BETWEEN PRIMARY KEY AND PRIMARY INDEXSorry about the formatting, but not sure, why teradata forum is removing all the lines and spaces today.
6004 Mar 2013 @ 09:55 PSTDatabaseReplyDIFF BETWEEN PRIMARY KEY AND PRIMARY INDEXIf you are absolutely looking for the differences then below are few - PRIMARY KEY PRIMARY INDEX 1 It cannot be NULL It can be NU...
5904 Mar 2013 @ 09:43 PSTDatabaseReplyNeed help to improve the performance of the queryIt is very difficult to suggest about performance imrpovement of query without knowing anything about the tables, especially all you are doing is joining bunch of table on some conditions. I can on...
5804 Mar 2013 @ 05:58 PSTDatabaseReplyDifference between Create table Statements That is true the PI of second case is the same as the table as I took the definition of table1 to create table2. However, I thought in the option 1 when you do CREATE TABLE AS SELECT, the new t...
5704 Mar 2013 @ 05:45 PSTDatabaseReplyTable partitioning on TIMESTAMP(3) in Teradata 13There are lot of documents available online to understand the primary index mechanism of data distribution. If you are new then you can start with this very basic document. http://teradata.uark...
5601 Mar 2013 @ 11:01 PSTDatabaseReplyDifference between Create table Statements I am afraid to say that I do not get almost similar explain in both the cases. Here is the example. I am trying to insert data from table 1 to table 2. Table 1 is a multiset table. There are aroun...
5501 Mar 2013 @ 05:53 PSTDatabaseReplyDifference between Create table Statements Hi Dieter, I have experienced (lot of times) that if I follow the method 1 as AnandC mentioned then data gets inserted so fast than if I follow the method 2. I always tried with permanent tab...
5401 Mar 2013 @ 05:41 PSTDatabaseReplydropping partition statisticsDo you get error while running DROP STATS statements that you mentioned or you could run that statements successfully but still not able to alter a table to add range because of some stats are...
5327 Feb 2013 @ 09:59 PSTDatabaseReplyFull join on 1=2First, I do not understand why you would need to do FULL JOIN between same tables (dbname.table2). I am sure we can avoid that if we know what is the exact requirement. Anyways, for any reason if y...
5225 Feb 2013 @ 01:18 PSTDatabaseReplystring not terminated errorTry SUBSTR instead of SUBSTRING, that might solve your issue.
5122 Feb 2013 @ 07:39 PSTDatabaseReplyCombining Multiple Insert Statements with Calculations FieldsNo, you can't run COLLECT STATS statements like that in BTEQ. You have do something like: collect stats on table column (row_wid); collect stats on table column (order_wid);
5021 Feb 2013 @ 11:16 PSTDatabaseReplyClarification doubt on SPOOL SPACEAll users are allocated with certain amount of spool space for the query answer set. So there are chances that your user id got allocated with less space than the another one that you use. Spool s...
4921 Feb 2013 @ 05:53 PSTToolsReplyAlter table to add column after specific columnYou can always make INSERTs of your load scripts to match with the incoming file, it doesn't matter how the table structure is. I don't think of any example where you can face issue because...
4820 Feb 2013 @ 10:09 PSTDatabaseReplyCommand Help : Alter table modify columnThat is definately a good approcah. However, what I hear from DBAs in my company that RENAMEing table is not a good stable thing to do in teradata. So in such kind of situations, they always p...
4720 Feb 2013 @ 06:05 PSTDatabaseReplyCommand Help : Alter table modify columnAs you need to rename so many columns, I'd suggest, you create a new table with desired datatypes, copy all the data from the existing table to this new table by casting to varchar, drop the ex...
4620 Feb 2013 @ 05:58 PSTDatabaseReplyConcatenate o/p of two select statementsI don't think any of the above queries (except Dieter's) would work without having product join. To ask your question on what is the better solution, then in my opinion, as in your scenar...
4519 Feb 2013 @ 01:19 PSTDatabaseReplyConcatenate o/p of two select statementsActually no need for WHERE 1=1, it would work without that too. SEL col1,col2,col3, MAX(eff_date), COUNT(table2.xyz), ... FROM table1, table2 GROUP BY 1,2,3
4419 Feb 2013 @ 01:02 PSTDatabaseReplyConcatenate o/p of two select statementsThe above solution would work perfectly with the scenario you mentioned. However, if you have more than one column to concatenate in your results and there is absolutely NO relation between 2 table...
4319 Feb 2013 @ 09:55 PSTGeneralReplyJoin many data sets You can do that using cursors and dynamic stored procedures.
4218 Feb 2013 @ 10:19 PSTDatabaseReplyHow to store a field value of a table column into variables in Stored ProcedureBy any chance, are you using SELECT...INTO in a dynamic stored procedure ? If yes, then it would not work.
4114 Feb 2013 @ 10:47 PSTToolsReplyFAILURE 2673 SOURCE PARCEL LENGTH DOES NOT MATCH DATA THAT WAS DEFINEDUse CHAR in USING clause instead of VARCHAR as the length of your data is fixed.
4014 Feb 2013 @ 05:45 PSTDatabaseReply UDF creation problem, *** Error 7506 The library for UDF/XSP/UDM SYSLIB.oreplace1 could not be foundOh k. All UDFs/XSPs/UDMs are linked in a dynamic linked library or in a package which must exist on all nodes on the database system. And it looks like, the library for this UDF/XSP/UDM could not b...
3913 Feb 2013 @ 11:18 PSTToolsReplyUsing Parameter in BTEQDo you have the logon script in the beginning (the very first line) of the BTEQ ? If not, then it will give you this error. If it is, then just make sure that it is the correct script/sta...
3813 Feb 2013 @ 10:07 PSTDatabaseReply UDF creation problem, *** Error 7506 The library for UDF/XSP/UDM SYSLIB.oreplace1 could not be foundDo you have SYSLIB.oreplace1 defined somewhere before ? If yes, can you please put its definition ? Also, don't understand why you defined SYSLIB.oreplace2 twice because the later definiti...

Pages