196 | 15 Aug 2007 @ 06:51 PDT | Connectivity | Reply | Teradata AIX ODBC Data Source | Does your .odbc.ini file contain the required header sections?[ODBC]InstallDir=/usr/odbc[ODBC Data Sources]TERADB=tdata.soIs your ini file $HOME/.odbc.ini ? If not you need to set ODBCINI environme... |
195 | 15 Aug 2007 @ 10:43 PDT | Connectivity | Reply | Teradata AIX ODBC Data Source | ODBC driver v3.03 doesn't use TeraGSS & TDICU. Either use a newer driver or change LIBPATH to reference /usr/odbc/lib rather than the teragss lib. |
194 | 14 Aug 2007 @ 11:06 PDT | Tools | Reply | From clause 'Select * from table@ a ' | It's not Teradata SQL. I'm guessing it's Oracle, since it has the (+) modifiers for outer join. |
193 | 14 Aug 2007 @ 09:54 PDT | Training | Reply | Error 3802 | If you've never run setup before, you get to make up the passwords. If you choose to re-run it, you enter the passwords set previously. |
192 | 08 Aug 2007 @ 08:19 PDT | Analytics | Reply | SQL and spool space | You are approaching this from the wrong point of view.No, there is no option to "run my query even though it's syntactically incorrect".And the spool space requirement is a function of the data and... |
191 | 05 Aug 2007 @ 01:35 PDT | UDA | Reply | Difference in output | As I said before, you could probably just change UNION to INTERSECT but that would not be my first choice. It's hard to say exactly what would be best without a lot more detail, but I'd consider sp... |
190 | 03 Aug 2007 @ 12:58 PDT | Tools | Reply | Can TPUMP load to one db and put error/log tables in another? | TPUMP creates and uses macros to process the data. If the macros are to be placed in a "third party" database, then that database must be granted DML rights (SELECT, INSERT, UPDATE, DELETE) WITH GR... |
189 | 31 Jul 2007 @ 12:04 PDT | UDA | Reply | Difference in output | Not inner join, exactly; in effect it's being used as a "NOT EXISTS" condition: SELECTS.ACCT_EVENT_TYPE_CD ,S.CUST_ACCT_EVENT_ID ,S.EVENT_USED_BY_CD ,S.EVENT_SEQUENCE_CD ,S.DW_AS_OF_DT ,S.CUST_ACCT... |
188 | 30 Jul 2007 @ 12:12 PDT | UDA | Reply | Difference in output | Not the same, because the term COALESCE(T.DW_EFF_DT,date '0001-01-01') in each subquery evaluates to date'0001-01-01' for all the 'non-matching' rows. In effect your first query is returning rows t... |
187 | 30 Jul 2007 @ 12:33 PDT | Tools | Reply | Varchar in Fast Export | They are not "junk characters", they are the two-byte binary length field that is part of the external format for VARCHAR data (and apparently whatever you are using to view the data translates "no... |
186 | 30 Jul 2007 @ 12:04 PDT | Connectivity | Reply | Implementing Login Security | If you are running V2R6.2, see Appendix D in the Security Administration manual. |
185 | 26 Jul 2007 @ 10:03 PDT | Database | Reply | Cast String to Time | LTRIM and RTRIM are not Teradata functions.Do you really need to TRIM the values? If so, you can use ANSI TRIM(BOTH FROM col)But the fact that LTRIM and RTRIM appear to work tells me you are using ... |
184 | 26 Jul 2007 @ 09:42 PDT | Database | Reply | Column level attributes not copied to target table in CREATE TABLE AS... | If you read the entire topic the documentation is inconsistent; the particular section you excerpted is wrong. What you are observing is the intended behavior. Note there is a difference between th... |
183 | 24 Jul 2007 @ 03:22 PDT | Connectivity | Reply | Executing Queries from UDF | In Teradata V2R6.1 and later, a UDF can do "external I/O" via operating system calls; this is documented in the manuals. You can't have embedded SQL statements in source code provided to CREATE FUN... |
182 | 18 Jul 2007 @ 11:25 PDT | Database | Reply | [HELP] Modify a column name that is also a NUPI Index... | Rename the table, then create a simple view with the name the table used to have; GRANT access rights on the view and REVOKE them from the table.Or create a new table and copy the data... |
181 | 18 Jul 2007 @ 11:09 PDT | Database | Reply | Error while trying to connect to Teradata | Your access logging rules say that an audit trail row must be inserted or updated in DBC.AccLogTbl before the request can be executed, but that logging failed.Perhaps it's because database DBC is o... |
180 | 14 Jul 2007 @ 02:40 PDT | Tools | Reply | Console utilities in teradata Manager | GRANT / REVOKE in the supervisor window pertain to rights to run the utilities from the database window, outside of Teradata Manager |
179 | 13 Jul 2007 @ 01:46 PDT | Database | Reply | how to "purge" transient journal | Transient journal space should be reclaimed automatically as transactions commit or roll back their changes. You must have some very long / very skewed unit of work still processing or rolling back. |
178 | 13 Jul 2007 @ 01:42 PDT | Tools | Reply | Console utilities in teradata Manager | Ticking the box means you can start the interface. To actually run a utility you must have EXECUTE permission on the corresponding MACRO in the CONSOLE database.(The default macro is a null stateme... |
177 | 12 Jul 2007 @ 08:54 PDT | Database | Reply | what does this error mean? | It means that though rows in the derived table may be unique, the combination of join columns (a,b) is not.SELECT a, b from (derived table --> this table returns unique values)dGROUP BY a, bHAVING ... |
176 | 12 Jul 2007 @ 08:49 PDT | Training | Reply | Error 3802 | Yes, for the demo the default database name is DemoTDAT; super user name and password are both dbc. The first time you run Setup, the Console user password (entered once) and the dbcmanager passwor... |
175 | 11 Jul 2007 @ 03:55 PDT | Training | Reply | Error 3802 | Need to run "Database Setup" tool first (found in Teradata Manager program group). |
174 | 06 Jul 2007 @ 12:36 PDT | UDA | Reply | CASE Statement | Be sure your CASE, WHEN/THEN, ELSE, END keywords match up properly; for example:SELECT top 5 CASE WHEN rated_driver_id Is Not Null AND rated_P_driver_id Is Null AND 'H' || trim (t7.corrected_produc... |
173 | 03 Jul 2007 @ 09:53 PDT | Database | Reply | connect failed -- CLI2: BADBUFRQ(302): Invalid buffer size | You can send SQL text larger than the request buffer size. And this error does not say the request is too large for the buffer, it says the specified buffer size is not valid. Are you seeing this e... |
172 | 26 Jun 2007 @ 12:53 PDT | Tools | Reply | BTEQ logon | In "interactive mode" (standard input from terminal), BTEQ does not accept the password on the LOGON statement.In "batch mode" (standard input redirected from file), BTEQ requires the password on t... |