#DateForumTypeThreadPost
87104 Sep 2014 @ 07:35 PDTDatabaseReplyImporting Data from .XLSYou can save your file as csv. You can try something like this:        .import vartext ',' file='temp.csv' ;      .quiet on  ...
87004 Sep 2014 @ 06:13 PDTToolsReplywhich Teradata process is using this tableAs far as I know you can find thru MDS( Metadata services). This link may help  also http://forums.teradata.com/forum/database/how-to-find-the-associated-tables-or-view-in-teradata
86904 Sep 2014 @ 03:52 PDTDatabaseReplyFreeSPacePercent(FSP) to avoid frequent PACKDISK runThese links perchance can answer your questions: http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1184_111A/Create_Table-Details.012.030.html The last sentenc...
86804 Sep 2014 @ 03:10 PDTDatabaseReplyFull OuterJoin IssueBy temporary :) , I mean a table (not VTT) where you can load and do an analysis. If you get a diff , perhaps, then you can narrow down the doubts.
86704 Sep 2014 @ 01:22 PDTDatabaseReplyFull OuterJoin IssueFor analysis purpose, you can load both into some temporary tables. Once loaded, then you can  compare the missing records, how it happens.
86603 Sep 2014 @ 08:17 PDTDatabaseReplyTeradata ErrorWhaw Teradata 12? There was a discussion in the past about this. Hope it helps. http://forums.teradata.com/forum/connectivity/odbc-sql-active-statements-limit-error-using-python-pyodbc I am not a...
86503 Sep 2014 @ 07:53 PDTDatabaseReplyGet Order Yes it can be done in many ways. You can check the explain and see.
86403 Sep 2014 @ 07:31 PDTDatabaseReplyGet Order Current quarter of previous years too? I am a bit confused :) Hope this calculation for  a quarter example below can help you: select .......... ,((CAST(EXTRACT(MONTH FROM ORD_DT) AS BYTEINT...
86302 Sep 2014 @ 11:28 PDTGeneralReplyCan anyone please tell me use of merge block ratio in ddlsHi Purushotham, You can go through this link. It provides a vivid description: http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1184_111A/Create_Table-Details...
86202 Sep 2014 @ 11:20 PDTGeneralReplyWithout using Join keyword how can we retrive matching rows from both the tablesCan you use  intersect ,exists, (not exists), in , (not in), .....union n minus ......? or is it an inhibition that join should not be used at all?  
86102 Sep 2014 @ 04:44 PDTToolsReplyCustom Message in BteqSince you mention about logfile, I m thinking that you may want to use .goto and label too...... can you try with this: insert into.... .if errorcode <> 0 then .goto insert1 insert in...
86002 Sep 2014 @ 04:19 PDTTeradata ApplicationsReplydiff between volatile and GTT table with ON PRESERVE COMMIT statementThey are similar in many features. You can create and see both how they are implemented. This link highlights a comparison: http://www.info.teradata.com/HTMLPubs/DB_TTU_13_10/index.html#page/Data...
85901 Sep 2014 @ 07:57 PDTGeneralReplyCan any help me out with the difference between ETL and ELT Mostly proprietary ETL tools perform ETL task on a row-by-row basis. So performance will be hit. So think of the advantage of doing voluminous transformation(T) at the target server, performing ...
85801 Sep 2014 @ 05:52 PDTDatabaseReplyCalculation Precision issue Oracle Vs TeradataYour second query is Teradata? In Oracle version 11g, it works. SELECT CAST(ROUND(  CAST((( CAST(3.82 AS DECIMAL(18,8))/ CAST(23.88 AS DECIMAL(18,8))) * 23.88 ) / CAST(767 AS DECIMAL(18,5)) ...
85701 Sep 2014 @ 12:17 PDTDatabaseReplySQL query to understand the names of all the available tables in the database , number of records for all these tables and sAre your statistics up-to-date ?
85629 Aug 2014 @ 10:45 PDTDatabaseReplyFormat with leading zerosIn case of varchar field, you can do thus: select regexp_replace(acct_id ,',','',1,0,'i') b,char_length(regexp_replace(acct_id ,',','',1,0,'i') ) a,...
85529 Aug 2014 @ 10:33 PDTDatabaseReplyFormat with leading zerosoops.. I did the opposite: you can do something like this select acct_id,char_length(cast(acct_id as varchar(10))) a, case when a=6 then 'A0'||cast(acct_id as varchar(10)) END FROM yourt...
85429 Aug 2014 @ 09:35 PDTDatabaseReplyFormat with leading zerosWith your data mentioned, I did this way. There are other ways too. select cast(regexp_replace(Result_accnt_id,'A','',1,0,'i') as integer) from your_table; This will work ...
85329 Aug 2014 @ 08:02 PDTDatabaseReplyWhat's the difference between NOT IN and minus in SQL?Run an explain for the same functionality and same tables.  You can see the steps. I tested and see that Minus is better than not in. 
85229 Aug 2014 @ 07:25 PDTUDAReplyProblem Using UPSERTMy table t1 is having  id name 1 'jj' It works : update t1 set name='mm' where id=2 else insert into t1(id,name) values(2,'kk');   UPDATE t1 SET col_a = va...
85129 Aug 2014 @ 06:36 PDTDatabaseReplyHow to configure a scheduler in teradata?I am not sure about your requirement. I am not a weblogic guy either. However, it seems you are asking about Teradaata Query scheduler.  You can have a look and see if it suits befittingly yo...
85028 Aug 2014 @ 10:07 PDTDatabaseReply SQL query to understand the names of the tables , number of records in a table and size of the table If it is tedious to do one by one , you can think of a script thus: SELECT 'SELECT '''||TRIM(TABLENAME)||''' AS TABLE_NM, count(*) AS ROW_CNT FROM '||TRIM(DAT...
84928 Aug 2014 @ 08:30 PDTToolsReplyTeradata Bteq OptimizationAmbuj, You could have tried and tested it :) create dummy tables. login to bteq(here it is bteq) do the above two operations and see the errors. confirm the delete part.
84828 Aug 2014 @ 05:03 PDTDatabaseReplyCalling Stored Procedures from Dynamic SQL Statement I dont think that can be done,also in other databases that I know too. sTored procs are called or compiled , example below CALL abc (1, amt); .compile file def.spl Maybe you can break up i...
84728 Aug 2014 @ 04:27 PDTTeradata ApplicationsReplyPartitions on Existing TD 14.10 table http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1184_111A/Alter_Function-Details.008.088.html#ww16787434 You can see the link here and also the consequence ...

Pages