#DateForumTypeThreadPost
94618 Sep 2014 @ 04:00 PDTGeneralReplyWhat is the purpose of using DBC.SYSEXECSQL?Ulrich has answered your question above. It is not at all a bottleneck. It is a boon.
94518 Sep 2014 @ 03:52 PDTDatabaseReplyNew Features in TD V15Just to name a few: we can write codes in any language and execute using SCRIPT,table operator,Ferret showblocks sql interface, Table operator enhancements,TASM enhancements,DBQL logs stats for...
94417 Sep 2014 @ 09:48 PDTDatabaseReplyComposite index Vs join indexCan you give me the queries  for both of them and some test data, I will test and let you know. Partially covered?   I think that JI is better than Partially covered one. Howe...
94317 Sep 2014 @ 08:47 PDTDatabaseReplyerror handler for CAST FAILED BAD CHARACTER IN FORMAT OF DATABad characters, untranslatable characters, valid , in valid, it depends. If we know the patterns in advance we can filter them out. I m not pretty sure if translate_chk can help in your case. exa...
94217 Sep 2014 @ 08:33 PDTDatabaseReplyProcedure Issueseven you tried: Grant mmmmmmm on DBTest1 to DBTest_user WITH GRANT OPTION;   SELECT UserName ..... FROM dbc.AllRights WHERE DatabaseName = abc AND TableName = def AND A...
94117 Sep 2014 @ 01:26 PDTDatabaseReplythat DBC block my Query?Your question/issue is not clear. Maybe you can elaborate more on what you are doing a delete .... :)
94017 Sep 2014 @ 01:19 PDTDatabaseReplyUse While loop in Stored Procedure in TeradataNot seen your code, but are you executing in ANSI (....commit...)or BTET mode? Also your temp table is it VTT , where you need on commit preserve rows?
93917 Sep 2014 @ 01:05 PDTExtensibilityReplyprocess AL3 XML (insurance standard xml) in tdAs far as I know , there is not one for AL3. So the solution is to convert it to xml. There may few tools available.
93816 Sep 2014 @ 08:41 PDTDatabaseReplyComposite index Vs join indexThis is composite index: CREATE TABLE table1 (        x1 INTEGER,        y1 INTEGER,        z1 INTEGER)    ...
93716 Sep 2014 @ 10:19 PDTGeneralReplyPaasing shell script variables in to BTEQ scriptI see your export does not have values.  Why cant you stuff sql inside the sh, example below: export DB_NAME=abc export DB_USER_NAME=def   bteq<<! >>$PWD/abf....
93616 Sep 2014 @ 10:14 PDTDatabaseReplyHandling NULL values in the dataIf the file is in unix, I could have done sed: example: sed -e 's/NULL//g'? Can you try this before really impementing, if it is good for you.
93516 Sep 2014 @ 09:58 PDTAsterReplyregarding documnentaion for aster technologyDid you have a look at this link? http://www.info.teradata.com/AsterData/eBrowseBy.cfm Aster is for data discovery, analytics, multi-structured data, SQL-MR
93416 Sep 2014 @ 09:09 PDTGeneralReplyAre a tables columns accessible as a CSV list in DBC?Not that I know. It seems you want all columns from a database and table something like this: select tdstats.udfconcat(trim(columnname)) from dbc.columns where databasename='yourdb' and ta...
93316 Sep 2014 @ 08:41 PDTToolsReplyDownloads from downloads.teradata.com are blocked by NortonIf we are working in an organization, and it is blocked by Security admin, we can't help. As for Norton and outside, let TD Website team decide maybe :)
93216 Sep 2014 @ 01:05 PDTGeneralReplyHOw to drop a particular Partition in partition tableCheck your syntax properly. Check your table  and data properly too. Understand, which data you are going to drop.
93116 Sep 2014 @ 12:40 PDTGeneralReplyWhat is the purpose of using DBC.SYSEXECSQL?Thru EXECUTE IMMEDIATE,DBC.SysExecSQL  can we can execute dynamic ddl  statements too. We can stuff logics together to achieve a functionality. Just imagine one call is enough. Uisng cur...
93015 Sep 2014 @ 10:56 PDTGeneralReplyHOw to drop a particular Partition in partition tableThere are cases, for that reason I  mentioned rules. I do not want to rephrase the words from the doc. The link is provided here: http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html...
92915 Sep 2014 @ 09:13 PDTGeneralReplyPaasing shell script variables in to BTEQ scriptIf I understand you correctly, is this waht you mean?: #!/usr/bin/ksh export CUST_CORE export CUST_STAGE export CUST_SANDBOX     bteq<<! >>${LOG_FILEN...
92815 Sep 2014 @ 09:01 PDTGeneralReplyHOw to drop a particular Partition in partition tableYou can refer to this link for adding and dropping partition: http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1144_111A/Alter_Function-Syntax.020.106.html Be...
92715 Sep 2014 @ 08:34 PDTThird Party SoftwareReplyOracle to Teradata SQL ConversionIf you are a TD customer, you can contact them. No harm in contacting them, I feel :).
92615 Sep 2014 @ 08:22 PDTDatabaseReplyValidate integers that can be converted into dateCalendar is also an issue and you cannot use it ..... hmm.You said you use exception, it seems you are using  stored proc. If you loop through, each one and check the validation  with mul...
92515 Sep 2014 @ 07:51 PDTDatabaseReplyUpdating duplicate rows in tableHere it is Teradata forum . MSSQL folks may give you the right direction. I think a merge may help you.
92415 Sep 2014 @ 07:37 PDTToolsReplyDownloads from downloads.teradata.com are blocked by NortonI have McCafee. What I did was , I disable the anti-virus software :). It is there in the icon , next to time icon. Once that is disabled, I downloaded what I wanted. Then I switch on the anti-viru...
92315 Sep 2014 @ 08:07 PDTDatabaseReplyExecute access for Procedure?You posted twice :). You can post only in one place and it will be answered. It is answered below under created by you :). http://forums.teradata.com/forum/general/executing-procedure-by-a-user-ot...
92215 Sep 2014 @ 07:51 PDTGeneralReplyEXECUTING PROCEDURE BY a USER OTHER THAN THE CREATORgrant execute procedure retail to public; you can refer to granting in this link too: http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1149_111A/ch02.004.028....

Pages