#DateForumTypeThreadPost
42311 Mar 2013 @ 02:05 PDTDatabaseReplyLENGTH() function in bteqYes, CHARACTER_LENGTH will surely work.
42211 Mar 2013 @ 02:01 PDTDatabaseReplyUnique primary key voilation ErrorAnd the error is .... ? Some detials might help.
42111 Mar 2013 @ 02:01 PDTDatabaseReplyhow to create a user, database and table in sql assistant?I dont think they are default ones .... better ask who granted them. :)
42011 Mar 2013 @ 01:58 PDTDatabaseReplyProcedures Calling Procedures with Dynamic Result Sets (from TD notes)There has to be some error description, code .... ?
41911 Mar 2013 @ 01:55 PDTDatabaseReplyIs it good to creating SET table with UPI or NUPI and why..?What is going to be the use of the table? What type of data is expected? Is it going to be History Handled? Is it going to be loaded near real-time? Will it be used in joins majority of the times? ...
41811 Mar 2013 @ 01:52 PDTPrivate Forum
41703 Mar 2013 @ 02:57 PSTToolsReplySQL Assistant - Not able to Define ODBC Data Source through Teradata SQL Assistant v 13.11.0.04Can you share more details .... like if you are using VMWare, or its a local server or on a network .... etc?
41603 Mar 2013 @ 02:56 PSTDatabaseReplyFastLoad And Query AccessWill try it out .... never seen that .... may be probability is very low. Good info Dieter! :)
41503 Mar 2013 @ 02:53 PSTDatabaseReplyTable partitioning on TIMESTAMP(3) in Teradata 13Perfect .... Dieter :)
41402 Mar 2013 @ 05:06 PSTDatabaseReplyFastLoad And Query AccessNo it is not possible.   Whereas, normally table is dropped and created within a FL script.   HTH!
41302 Mar 2013 @ 05:03 PSTDatabaseReplySybase To Teradata.....Thorough analysis and documentation should be done on them and depending on the available skill-set .... the logic should be transformed either to a SP in Teradata (most of the cases) or for a few ...
41202 Mar 2013 @ 04:59 PSTDatabaseReplyWill volatile tables be dropped?Are you using dynamic SQL to create VTs?
41102 Mar 2013 @ 04:56 PSTDatabaseReplyTable partitioning on TIMESTAMP(3) in Teradata 13Can be done using follows:     PARTITION BY RANGE_N(ts1 BETWEEN TIMESTAMP '0001-01-01 00:00:00.000000+00:00' AND TIMESTAMP '9999-12-31 23:23:59.999999+00:00'...
41002 Mar 2013 @ 03:53 PSTUDAReplyImporting delimiter text file!!!!!!!!This is a typical case of complex delimited file scenario: If you take " as your delimiter, you will have following columns:   null 12345 , ABCD , STU,GHj , ...
40902 Mar 2013 @ 03:46 PSTGeneralReplyDid anyone store RDF data (Resource Description Framework) data on Teradata ?Isnt the RDF data XML files?
40802 Mar 2013 @ 03:38 PSTToolsReplySQL Assistant - Not able to Define ODBC Data Source through Teradata SQL Assistant v 13.11.0.04Can you try re-installing ODBC driver?
40702 Mar 2013 @ 03:37 PSTToolsReplyWhat tool for SP development?SQL Assistant .... or a Notepad.
40602 Mar 2013 @ 03:34 PSTDatabaseReplyUse of a Primary IndexDocumentation :)
40502 Mar 2013 @ 03:31 PSTDatabaseReplyDifference between Create table Statements The only difference is that .... in option 1 you have a leverage to tweak/select (correct) index.   I have seen scenarios where option 2 takes hours to process data .... and if you go with o...
40404 Feb 2013 @ 02:43 PSTAnalyticsReplyUsing different date formatsTeradata stores the date internally as an integer, so it doesnt affect the comparison or processing speed.
40304 Feb 2013 @ 01:40 PSTGeneralReplyDoes COMPRESS help performance?Lesser data to fetch, store, process .... meaning .... lesser bytes to read, write, access .... less I/Os which is very expensive operation. CPU time may increase but it is much efficient as compar...
40203 Feb 2013 @ 11:42 PSTDatabaseReplyNew user. Tyring to figure out how to group two statementsDuplicate post.
40103 Feb 2013 @ 12:14 PSTGeneralReplyHow to check which data has an errorYou can export the error table to see the row-content which has error.   Regards, Adeel  
40003 Feb 2013 @ 12:09 PSTGeneralReplyHow to find status Difference using date fieldDuplicate post.
39903 Feb 2013 @ 12:05 PSTGeneralReplyWhy does it feel like Teradata is years behind?In my opinion .... its a matter of perspective.   I agree to some points mentioned by Nezoic, but again .... it all depends on the way you at things.   Teradata Engineering is contino...

Pages