#DateForumTypeThreadPost
104605 Oct 2014 @ 10:49 PDTTrainingReplyTeradata Basic Certification HelpIf you come from Oracle background it is easy. You can go through this link: http://in.teradata.com/teradata-certified-professional-program/?LangType=16393&LangSelect=true There are quite a ...
104504 Oct 2014 @ 03:29 PDTDatabaseReplyCreate a SUPER/DBA/POWER UserWhy so? If everything is the same, then I feel it is better to share the password, because maintanance is less. If not then grant roles, profiles.... You can go thru this link: http://www.info.t...
104403 Oct 2014 @ 08:45 PDTDatabaseReplySend mail from a stored procedure My opinion:   Stored Procs, functions, packages are objects with different intents. They are meant for modularizing our programs. Each and every business functionality is mapped to ...
104303 Oct 2014 @ 08:00 PDTGeneralReplyTDExpress15 VM resulting in Blue screen of death...I think 2 GB RAM is not an issue. By highlighting more details of your OS, version, capacity. etc etc , VMWARE details....It can help. Because Windows to be frank has lots of things :). Try to def...
104203 Oct 2014 @ 07:15 PDTToolsReplyMultiple queries in one connectiong through Teradata studio / Eclipse pluginFor now I can think of  MSR or macros, where you design statements that do not have /share dependencies are executed  in parallel
104103 Oct 2014 @ 04:01 PDTToolsReplyGet a Thousand Separators Using BTEQ Export ScriptDid you do in unix, bteq or sql assistant or td studio or where? in bteq,unix: select cast(100000 as format '$$$,$$$$'); it looks like you want in this format too  CAST (salary AS ...
104003 Oct 2014 @ 03:51 PDTDatabaseReplyHow to concatenate a date in three different columns?Then you if you can share more details, like your ddl, what you have and what is the expected output, then it will be easier to interpret.
103903 Oct 2014 @ 01:21 PDTToolsReplyGet a Thousand Separators Using BTEQ Export ScriptYou can try something like this CAST (your_field  AS FORMAT ‘$$$,$$$’) In TD studio, you can also see Result Viewer prefrences, where you can change the numeric presentation.
103803 Oct 2014 @ 12:42 PDTConnectivityReplyBODS and teradata connectivityI think this is a setting at the BODS level. I remember vaguely when I used to work on SAP DS. I changed many conficgurations. From Teradata end, to test if any setting is okay, I put one ddl at en...
103703 Oct 2014 @ 12:24 PDTGeneralReplyQuestion Regarding Stored ProcedureTry with TABLENAME =TNAME; Try step by step and execute it.    
103603 Oct 2014 @ 12:21 PDTDatabaseReplyHow to concatenate a date in three different columns?Can you plz share the ddl? It works fine : create table mmmmmm(year1 smallint, month1 smallint, day1 smallint); insert into mmmmmm values( 1987,2,14); insert into mmmmmm values(&n...
103502 Oct 2014 @ 11:11 PDTDatabaseReplyMake insertion to the target table quickerFrom the document: Block-level compression can result in some operations using considerably more CPU while operating on compressed tables (for example, queries, insert/updates, archive and restore...
103402 Oct 2014 @ 08:54 PDTDatabaseReply How to sum up totals from different columns and insert into one columnI am not sure if I understand it correctly. I think this is what you want: ..... (S5IE_ADJ_TOT_AMT+S5IE_DEDN_MAINT_EXPEND_AMT +S5IE_FGN_INC_AMT+S5IE_FRNG_BEN_AMT ........) as summing, Please let...
103302 Oct 2014 @ 08:34 PDTDatabaseReplyHow to concatenate a date in three different columns?oops Dieter's way is the best :)
103202 Oct 2014 @ 08:30 PDTDatabaseReplyHow to concatenate a date in three different columns?You may try too: you can do something like this: select cast(cast(cast(year1 as varchar(4))|| case when character_length(cast(month1 as varchar(2)))=1 then '0'|| cast(month1 as varchar(2...
103102 Oct 2014 @ 07:26 PDTDatabaseReplyunable to obtain data value because the teradata database indicated that the data type is ambiguousJugal, Maybe you can upgrade to 14.10. It is more stable. http://developer.teradata.com/database/articles/new-teradata-express-14-10-versions-available Many functions are also stable there. &nb...
103002 Oct 2014 @ 06:41 PDTGeneralReplychecking for invalid or junk or special characters on numeric fieldYes Carlos true. I think what he means to say is target field is BIGINT and source is varchar maybe.
102902 Oct 2014 @ 06:02 PDTDatabaseReplyunable to obtain data value because the teradata database indicated that the data type is ambiguousIt seems you are missing a coma at the end of NetSal DEC(8,2) FORMAT '$b$$,$$9.99' . Maybe you can try with it?
102802 Oct 2014 @ 03:11 PDTGeneralReplychecking for invalid or junk or special characters on numeric fieldyou can also think of using regexp_similar: example: select * from your_tab where regexp_similar(abc,'[^0-9]+','c')=1
102702 Oct 2014 @ 02:27 PDTDatabaseReplyFinding PI for a table created alreadyI did not test the above proc. 3 in parms ,1 out parm: CALL ALTER_PI_UNIQUE ('DS_DAT','PROD_PARTY','PRDCT_ID',parm5678);
102602 Oct 2014 @ 12:57 PDTGeneralReplyDifference between business calendar and calendar functions in teradataI think once you execute CreateBusinessCalendarPattern and put the settings, there , then all you need to do is mentioned specifically say for ISO , you need to  have in your query, else ...
102502 Oct 2014 @ 12:36 PDTGeneralReplyEffect of business calendar patterns and exceptions impact the result of business calendar functionsMy opinion: Did you try mentioning it specifically ISO too like, after setting SET SESSION calendar = ISO; SELECT TD_WEEK_BEGIN(TIMESTAMP'2012-01-15 12:00:00+02:00','ISO',TIME...
102401 Oct 2014 @ 11:55 PDTDatabaseReplyStored procedureYou can see here: http://www.info.teradata.com/edownload.cfm?itemid=113480020
102301 Oct 2014 @ 09:39 PDTDatabaseReplyHow exactly do I fix an error related to 'untranslatable character'Have you  tried something like this? Select   Col1 ,     Translate_Chk(Col1 using Latin_To_Unicode) ,     Col2 ,     Translate_Chk(Col2 using...
102201 Oct 2014 @ 09:28 PDTToolsReplyTSETI dont think you can do that  thru TSET :) TSET is used to emulate impact of changes in SQL or to validate Optimizer. TSET works with TVE too to emulate the target system.You export emulat...

Pages