#DateForumTypeThreadPost
19615 Aug 2007 @ 06:51 PDTConnectivityReplyTeradata AIX ODBC Data SourceDoes 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...
19515 Aug 2007 @ 10:43 PDTConnectivityReplyTeradata AIX ODBC Data SourceODBC 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.
19414 Aug 2007 @ 11:06 PDTToolsReplyFrom clause 'Select * from table@ a 'It's not Teradata SQL. I'm guessing it's Oracle, since it has the (+) modifiers for outer join.
19314 Aug 2007 @ 09:54 PDTTrainingReplyError 3802If 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.
19208 Aug 2007 @ 08:19 PDTAnalyticsReplySQL and spool spaceYou 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...
19105 Aug 2007 @ 01:35 PDTUDAReplyDifference in outputAs 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...
19003 Aug 2007 @ 12:58 PDTToolsReplyCan 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...
18931 Jul 2007 @ 12:04 PDTUDAReplyDifference in outputNot 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...
18830 Jul 2007 @ 12:12 PDTUDAReplyDifference in outputNot 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...
18730 Jul 2007 @ 12:33 PDTToolsReplyVarchar in Fast ExportThey 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...
18630 Jul 2007 @ 12:04 PDTConnectivityReplyImplementing Login SecurityIf you are running V2R6.2, see Appendix D in the Security Administration manual.
18526 Jul 2007 @ 10:03 PDTDatabaseReplyCast String to TimeLTRIM 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 ...
18426 Jul 2007 @ 09:42 PDTDatabaseReplyColumn 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...
18324 Jul 2007 @ 03:22 PDTConnectivityReplyExecuting Queries from UDFIn 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...
18218 Jul 2007 @ 11:25 PDTDatabaseReply[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...
18118 Jul 2007 @ 11:09 PDTDatabaseReplyError while trying to connect to TeradataYour 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...
18014 Jul 2007 @ 02:40 PDTToolsReplyConsole utilities in teradata ManagerGRANT / REVOKE in the supervisor window pertain to rights to run the utilities from the database window, outside of Teradata Manager
17913 Jul 2007 @ 01:46 PDTDatabaseReplyhow to "purge" transient journalTransient 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.
17813 Jul 2007 @ 01:42 PDTToolsReplyConsole utilities in teradata ManagerTicking 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...
17712 Jul 2007 @ 08:54 PDTDatabaseReplywhat 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 ...
17612 Jul 2007 @ 08:49 PDTTrainingReplyError 3802Yes, 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...
17511 Jul 2007 @ 03:55 PDTTrainingReplyError 3802Need to run "Database Setup" tool first (found in Teradata Manager program group).
17406 Jul 2007 @ 12:36 PDTUDAReplyCASE StatementBe 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...
17303 Jul 2007 @ 09:53 PDTDatabaseReplyconnect failed -- CLI2: BADBUFRQ(302): Invalid buffer sizeYou 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...
17226 Jun 2007 @ 12:53 PDTToolsReplyBTEQ logonIn "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...

Pages