1096 | 08 Sep 2016 @ 02:55 PDT | Tools | Reply | SQL Assistant 15.00 TD 14.11.0.1 Doesn't Properly read first Parameter Key | Which patch level of SQL Assistant? There was a fix related to quoted named parameters included in 15.0.0.4
|
1095 | 02 Sep 2016 @ 10:25 PDT | Database | Reply | I can't execute an SP that calls another SP inside | For CREATE / REPLACE PROCEDURE, the CREATOR must have permission to execute any DML statements within the procedure (including CALL).
But the OWNER (database in which the procedure is de... |
1094 | 01 Sep 2016 @ 04:03 PDT | Database | Reply | I can't execute an SP that calls another SP inside | GRANT EXECUTE PROCEDURE ON novaquality.F_QUITA_REPES TO database_containing_calling_procedure;
(Or GRANT on the entire database instead of the individual SP.)
|
1093 | 01 Sep 2016 @ 03:55 PDT | Database | Reply | DBC Diskspace, | Or maybe DBC is simply sized too small for your workload. What fraction of total system PermSpace is DBC MaxPerm?
|
1092 | 01 Sep 2016 @ 03:52 PDT | Database | Reply | DBC Diskspace, | Most likely, this is due to WAL space (DBC.TransientJournal) holding uncommited insert / update / delete information, in case a transaction aborts.
Perhaps you need to commit / c... |
1091 | 29 Aug 2016 @ 10:46 PDT | Database | Reply | Can we pass object as parameter in a macro ? | You can't use SysExecSQL for a data-returning statement. You need to use a second (dynamic) cursor:
DECLARE sel_csr CURSOR FOR sel_stmt;
PREPARE sel_stmt FROM create_user_sql;
OPEN s... |
1090 | 29 Aug 2016 @ 10:34 PDT | Database | Reply | Output is different in DBC.diskspace and for Dbc.diskspacev | Where there are both, the views with "V" are the ones everyone should be using - since TD12. The ones without V are only for backward compatibility.
Currently, object n... |
1089 | 28 Aug 2016 @ 04:26 PDT | Database | Reply | Filtering results of concatenation | It's the extra spaces introduced by implicit typecast from INTEGER result of extract. The default is FORMAT -(10)9 so the year, for example is 2005 with 5 leading spaces.
Explicitly CAST(EXTRA... |
1088 | 28 Aug 2016 @ 04:06 PDT | Teradata Database on VMWare | Reply | ODBC on Teradata on VM | Try setting ODBCINI and/or ODBCINST to make sure those are the ini files you are actually using, e.g.
ODBCINI=/opt/teradata/client/15.10/odbc_64/odbc.ini
|
1087 | 28 Aug 2016 @ 04:00 PDT | Database | Reply | Sum distinct records in a table with duplicates | How about
count(distinct case when a.header_comptia_cd = 'B92' then a.notif_id else NULL end) - 1 /* Don't include NULL in the count */ as B92_Sum
|
1086 | 26 Aug 2016 @ 08:34 PDT | Database | Reply | Teradata: No more room in journal table for novaquality.journals | In Teradata Studio, use the "Move Space" tool in the Teradata Administrator perspective.
|
1085 | 25 Aug 2016 @ 05:05 PDT | Analytics | Reply | Release Lock from a Table | If you ROLLBACK / ABORT or COMMIT the transaction, then the locks are released. And in Teradata mode, a database error causes an automatic rollback before returning the error status to the client.
|
1084 | 25 Aug 2016 @ 05:01 PDT | Tools | Reply | Teradata 14.10 History Window Gone | Under Tools / Options / File paths tab, be sure the history file path exists, is writeable, and has space.
|
1083 | 25 Aug 2016 @ 04:51 PDT | Database | Reply | How to grant all required privileges retained by DBC to my new admin user? | WITH ADMIN OPTION means you can grant role membership to or revoke role membership from other users (or roles), or DROP the role. But a role initially conveys no database rights, you have... |
1082 | 23 Aug 2016 @ 12:06 PDT | Database | Reply | Teradata Implicit Casting | See the "Implicit Type Conversion of Comparison Operands" topic in SQL Reference: Functions, Operators, Expressions, and Predicates manual.
In general, comparing (or joining on) two nume... |
1081 | 23 Aug 2016 @ 11:50 PDT | Database | Reply | ALTER TABLE on UNICODE character type issue | Are you specifying additional attributes in the ALTER besides the VARCHAR(40)?
I believe this check only looks at which attributes are supplied in the DDL, and fails if you specify any a... |
1080 | 22 Aug 2016 @ 03:40 PDT | Database | Reply | Need information about | Need more detail. For example:
How unique / non-unique are Col1 alone, Col2 alone, combined (Col1,Col2)?
How big is table1 vs table2?
|
1079 | 19 Aug 2016 @ 12:00 PDT | Database | Reply | SQL command for setting connection option to return generated keys | There is no SQL statement to change this option. And PyTd doesn't allow you to access a Statement object directly.
Have you considered using an external configuration file?
|
1078 | 18 Aug 2016 @ 11:12 PDT | Database | Reply | Use teradata with jmeter | Just as you would for any other database?
You can use the Teradata JDBC driver to submit SQL statements directly, and/or drive some application that uses Teradata on the back end.
|
1077 | 17 Aug 2016 @ 08:56 PDT | Connectivity | Reply | Connecting to Oracle | In general, Teradata does not provide drivers to connect to other vendors' databases (such as Oracle). Those drivers must be obtained from the other database vendor or a third party.
&nbs... |
1076 | 17 Aug 2016 @ 08:49 PDT | Tools | Reply | Getting export results in same date format as in Teradata table using BTEQ | "Exactly the same format as they are in the Teradata table" would be an internal binary representation; probably not what you really want.
BTEQ in FIELDMODE will use the FORMAT asso... |
1075 | 17 Aug 2016 @ 08:32 PDT | Database | Reply | Declaring variables in Terdata SQL Assistant | This is a DB2 question and not Teradata or even SQL Assistant. Is DECLARE VARIABLE even supported via ODBC?
|
1074 | 16 Aug 2016 @ 09:26 PDT | Database | Reply | Spool space error 2646 collecting statistics | The obvious answer is raise the spool space limit, or possibly to use sampled statistics. But another thing to check is whether EDW_CHECKSUM1 is a VARCHAR/VARBYTE field that has been defi... |
1073 | 16 Aug 2016 @ 09:21 PDT | Database | Reply | Copying Macro one DB Server to another DB with changed Internal Tables wrt to the new DB instance | Macros reference database objects by fully-qualified names, not by internal IDs.
|
1072 | 16 Aug 2016 @ 09:14 PDT | Tools | Reply | Casting Date in Bteq utilities | Not sure I understand your question at this point. Are you saying that you loaded to a staging table as character, and now you want a SQL expression that will CAST the character string to a Timesta... |