946 | 18 Sep 2014 @ 04:00 PDT | General | Reply | What is the purpose of using DBC.SYSEXECSQL? | Ulrich has answered your question above. It is not at all a bottleneck. It is a boon.
|
945 | 18 Sep 2014 @ 03:52 PDT | Database | Reply | New Features in TD V15 | Just 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... |
944 | 17 Sep 2014 @ 09:48 PDT | Database | Reply | Composite index Vs join index | Can 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... |
943 | 17 Sep 2014 @ 08:47 PDT | Database | Reply | error handler for CAST FAILED BAD CHARACTER IN FORMAT OF DATA | Bad 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... |
942 | 17 Sep 2014 @ 08:33 PDT | Database | Reply | Procedure Issues | even 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... |
941 | 17 Sep 2014 @ 01:26 PDT | Database | Reply | that DBC block my Query? | Your question/issue is not clear. Maybe you can elaborate more on what you are doing a delete .... :)
|
940 | 17 Sep 2014 @ 01:19 PDT | Database | Reply | Use While loop in Stored Procedure in Teradata | Not 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?
|
939 | 17 Sep 2014 @ 01:05 PDT | Extensibility | Reply | process AL3 XML (insurance standard xml) in td | As far as I know , there is not one for AL3. So the solution is to convert it to xml. There may few tools available.
|
938 | 16 Sep 2014 @ 08:41 PDT | Database | Reply | Composite index Vs join index | This is composite index:
CREATE TABLE table1 (
x1 INTEGER,
y1 INTEGER,
z1 INTEGER)
... |
937 | 16 Sep 2014 @ 10:19 PDT | General | Reply | Paasing shell script variables in to BTEQ script | I 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.... |
936 | 16 Sep 2014 @ 10:14 PDT | Database | Reply | Handling NULL values in the data | If 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.
|
935 | 16 Sep 2014 @ 09:58 PDT | Aster | Reply | regarding documnentaion for aster technology | Did 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
|
934 | 16 Sep 2014 @ 09:09 PDT | General | Reply | Are 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... |
933 | 16 Sep 2014 @ 08:41 PDT | Tools | Reply | Downloads from downloads.teradata.com are blocked by Norton | If 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 :)
|
932 | 16 Sep 2014 @ 01:05 PDT | General | Reply | HOw to drop a particular Partition in partition table | Check your syntax properly. Check your table and data properly too. Understand, which data you are going to drop.
|
931 | 16 Sep 2014 @ 12:40 PDT | General | Reply | What 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... |
930 | 15 Sep 2014 @ 10:56 PDT | General | Reply | HOw to drop a particular Partition in partition table | There 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... |
929 | 15 Sep 2014 @ 09:13 PDT | General | Reply | Paasing shell script variables in to BTEQ script | If I understand you correctly, is this waht you mean?:
#!/usr/bin/ksh
export CUST_CORE
export CUST_STAGE
export CUST_SANDBOX
bteq<<! >>${LOG_FILEN... |
928 | 15 Sep 2014 @ 09:01 PDT | General | Reply | HOw to drop a particular Partition in partition table | You 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... |
927 | 15 Sep 2014 @ 08:34 PDT | Third Party Software | Reply | Oracle to Teradata SQL Conversion | If you are a TD customer, you can contact them. No harm in contacting them, I feel :).
|
926 | 15 Sep 2014 @ 08:22 PDT | Database | Reply | Validate integers that can be converted into date | Calendar 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... |
925 | 15 Sep 2014 @ 07:51 PDT | Database | Reply | Updating duplicate rows in table | Here it is Teradata forum . MSSQL folks may give you the right direction. I think a merge may help you.
|
924 | 15 Sep 2014 @ 07:37 PDT | Tools | Reply | Downloads from downloads.teradata.com are blocked by Norton | I 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... |
923 | 15 Sep 2014 @ 08:07 PDT | Database | Reply | Execute 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... |
922 | 15 Sep 2014 @ 07:51 PDT | General | Reply | EXECUTING PROCEDURE BY a USER OTHER THAN THE CREATOR | grant 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.... |