#DateForumTypeThreadPost
109608 Sep 2016 @ 02:55 PDTToolsReplySQL Assistant 15.00 TD 14.11.0.1 Doesn't Properly read first Parameter KeyWhich patch level of SQL Assistant? There was a fix related to quoted named parameters included in 15.0.0.4
109502 Sep 2016 @ 10:25 PDTDatabaseReplyI can't execute an SP that calls another SP insideFor 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...
109401 Sep 2016 @ 04:03 PDTDatabaseReplyI can't execute an SP that calls another SP insideGRANT EXECUTE PROCEDURE ON novaquality.F_QUITA_REPES TO database_containing_calling_procedure; (Or GRANT on the entire database instead of the individual SP.)
109301 Sep 2016 @ 03:55 PDTDatabaseReplyDBC Diskspace, Or maybe DBC is simply sized too small for your workload. What fraction of total system PermSpace is DBC MaxPerm?
109201 Sep 2016 @ 03:52 PDTDatabaseReplyDBC 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...
109129 Aug 2016 @ 10:46 PDTDatabaseReplyCan 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...
109029 Aug 2016 @ 10:34 PDTDatabaseReplyOutput is different in DBC.diskspace and for Dbc.diskspacevWhere 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...
108928 Aug 2016 @ 04:26 PDTDatabaseReplyFiltering results of concatenationIt'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...
108828 Aug 2016 @ 04:06 PDTTeradata Database on VMWareReplyODBC on Teradata on VMTry 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
108728 Aug 2016 @ 04:00 PDTDatabaseReplySum 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  
108626 Aug 2016 @ 08:34 PDTDatabaseReplyTeradata: No more room in journal table for novaquality.journalsIn Teradata Studio, use the "Move Space" tool in the Teradata Administrator perspective.
108525 Aug 2016 @ 05:05 PDTAnalyticsReplyRelease Lock from a TableIf 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.
108425 Aug 2016 @ 05:01 PDTToolsReplyTeradata 14.10 History Window GoneUnder Tools / Options / File paths tab, be sure the history file path exists, is writeable, and has space.  
108325 Aug 2016 @ 04:51 PDTDatabaseReplyHow 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...
108223 Aug 2016 @ 12:06 PDTDatabaseReplyTeradata Implicit CastingSee 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...
108123 Aug 2016 @ 11:50 PDTDatabaseReplyALTER TABLE on UNICODE character type issueAre 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...
108022 Aug 2016 @ 03:40 PDTDatabaseReplyNeed information aboutNeed more detail. For example: How unique / non-unique are Col1 alone, Col2 alone, combined (Col1,Col2)? How big is table1 vs table2?
107919 Aug 2016 @ 12:00 PDTDatabaseReplySQL command for setting connection option to return generated keysThere 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?
107818 Aug 2016 @ 11:12 PDTDatabaseReplyUse 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.
107717 Aug 2016 @ 08:56 PDTConnectivityReplyConnecting 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...
107617 Aug 2016 @ 08:49 PDTToolsReplyGetting 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...
107517 Aug 2016 @ 08:32 PDTDatabaseReplyDeclaring variables in Terdata SQL AssistantThis is a DB2 question and not Teradata or even SQL Assistant. Is DECLARE VARIABLE even supported via ODBC?
107416 Aug 2016 @ 09:26 PDTDatabaseReplySpool space error 2646 collecting statisticsThe 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...
107316 Aug 2016 @ 09:21 PDTDatabaseReplyCopying Macro one DB Server to another DB with changed Internal Tables wrt to the new DB instanceMacros reference database objects by fully-qualified names, not by internal IDs.
107216 Aug 2016 @ 09:14 PDTToolsReplyCasting Date in Bteq utilitiesNot 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...

Pages