471 | 24 Apr 2013 @ 03:33 PDT | Database | Reply | There is another way to remove a volatile table? | HELP VOLATILE TABLE;
Will list the Volatile Tables that exist for the current session.
You can simply DROP TableName; for any volatile table you want to remove prior to disconnecting the session.... |
470 | 02 Apr 2013 @ 02:14 PDT | Tools | Reply | FastExport Access Module Error | Please start a new thread for new questions.
On mainframe, INFILE must specify a DDNAME not a dataset name.
|
469 | 25 Mar 2013 @ 02:31 PDT | Tools | Reply | TPT wizard 13.10 and LDAP | You can edit TdgssUseConfigFile.xml (found in tdgssconfig.jar in the ...\tptwizard\jars folder) to either designate LDAP as default mechanism or change its rank.
Save a copy of the jar file ... |
468 | 25 Mar 2013 @ 01:53 PDT | Database | Reply | Metadata information for a view | HELP COLUMN dbname.viewname.*;
|
467 | 12 Mar 2013 @ 03:08 PDT | Tools | Reply | Define new DB2 ODBC data source on TD SQL Assistant 13.11 | The IBM DB2 driver is dependent on IBM's native CLI driver. Before you can create an ODBC DSN, the corresponding CLI configuration must be "cataloged".
Easiest solution is to us... |
466 | 11 Mar 2013 @ 12:24 PDT | Database | Reply | Migration of Special Characters of UNICODE to TERADATA | Do you export from SQL Server as UTF16?
Did you specify "-c UTF16" option in the MLOAD invocation?
|
465 | 06 Mar 2013 @ 03:07 PST | Database | Reply | BTEQ is not returning proper error code when run file is not present. | Better to create a new thread for a new question.
In batch mode (within a script), the password goes on the .logon rather than on a separate line (as interactive mode):
.logmech ldap
.logon tdpi... |
464 | 06 Mar 2013 @ 01:52 PST | Database | Reply | Migration of Special Characters of UNICODE to TERADATA | How are you loading the data? What "client character set" is being used for that load?
|
463 | 26 Feb 2013 @ 03:24 PST | Database | Reply | string not terminated error | Is there a semicolon after the last apostrophe as well as before?
|
462 | 23 Feb 2013 @ 01:54 PST | Database | Reply | Table Version | Version indicates a change to structure (ALTER TABLE, ADD/DROP INDEX, etc.), not to content.
|
461 | 09 Feb 2013 @ 01:17 PST | Database | Reply | Top 10 Databases And Tables According To Size? | SUM(CurrentPerm) is the actual space.
MAX(CurrentPerm)*(HashAmp()+1) = MAX(CurrentPerm)*NumberOfAMPs can be regarded as the "effective space" allowing for skew.
Both values can be calcu... |
460 | 07 Feb 2013 @ 08:22 PST | Tools | Reply | very High CPU spent on [CheckPoint Loading] | You are correct. The CPU attributed to [CheckPoint Loading] includes load processing as well as the checkpoint itself.
Note that there is a checkpoint at the end of acquisition phase, ev... |
459 | 07 Feb 2013 @ 08:17 PST | Connectivity | Reply | Teradata_ICULibraries | The tdicu libraries support "internationalization" in client drivers.
http://en.wikipedia.org/wiki/International_Components_for_Unicode
|
458 | 07 Feb 2013 @ 08:10 PST | General | Reply | Spool space issue while Inserting into Table | Are the PI values for the target (looks like EDW_OFFSHORE_BASE.ISA.SVC_ACCT_NUM) highly skewed?
Even if not skewed, the redistribution by target PI to prepare for the MERGE step will require ... |
457 | 07 Feb 2013 @ 08:00 PST | Training | Reply | TERADATA CERTIFICATION | The general rule is that all the required exams for a certification must be passed at the same release level.
The exception is that if one already is a Teradata Certified Master at ... |
456 | 07 Feb 2013 @ 07:32 PST | Database | Reply | ETL Process results in contention on Teradata table | If the WHERE clause allows Teradata to identify a single specific RowHash to be updated by the statement (e.g. access by PI or USI) then RowHash locking can be used. Otherwise (e.g. acces... |
455 | 02 Feb 2013 @ 08:38 PST | General | Reply | Is there a limitation on the Merge statement and Rank Function? | No. Use the ANSI windowed format if this is what you intend:
RANK() OVER (PARTITION BY Account_Number, Date_Added, Time_Added)
In the (deprecated) Teradata RANK syntax, the columns only... |
454 | 17 Jan 2013 @ 03:05 PST | Connectivity | Reply | Need Help with Teradata ODBC driver on Oracle/AIX | Bookmarked links don't always work if the site has been restructured.
For the ODBC driver or other publicly available software, use the Downloads link on the Developer Exchange ... |
453 | 11 Jan 2013 @ 10:19 PST | Database | Reply | BTEQ is not returning proper error code when run file is not present. | ERRORCODE is the database error code from the most recent database request - and since the last database request was a successful LOGON, ERRORCODE is zero.
Perhaps you want to use ERRORL... |
452 | 08 Jan 2013 @ 10:00 PST | Database | Reply | Teradata Lock in Insert Statement | Not quite true. With a SELECT, you can downgrade from the default READ lock to ACCESS, or you can upgrade to WRITE or EXCLUSIVE. For INSERT/UPDATE/DELETE you can upgrade from the default WRITE... |
451 | 21 Dec 2012 @ 03:12 PST | Database | Reply | Variable results from an sql statement | Interesting workaround.
The more general answer is to use a cursor (even if the SELECT returns only one row):
SET sql_stmt = 'SELECT COUNT(*) FROM DM_JNJCHF_TEST WHERE PT_ID = ?' ... |
450 | 07 Dec 2012 @ 05:32 PST | Connectivity | Reply | First attempt fails. 20 min. later connection results. | Hard to say. This message only indicates that an error occurred trying to format the real error message, so we don't know the underlying cause. Usually it indicates a driver installation o... |
449 | 02 Dec 2012 @ 09:51 PST | Analytics | Reply | hashrow function | The hash function seldom changes, and will be clearly documented in the Release Summary. To rephrase Todd's answer, an in-place upgrade to a new release will not change the hash function. ... |
448 | 01 Dec 2012 @ 05:33 PST | Third Party Software | Reply | EntityDataSource date parameters with Teradata | A Teradata DATE literal has the keyword DATE followed by a 10-character string enclosed in apostrophes(single quotes), like
DATE '2012-11-30'
Or you can supply a character literal ... |
447 | 01 Dec 2012 @ 05:20 PST | Third Party Software | Reply | SSRS - querying TD using a VB expression via ODBC | A Teradata/ANSI timestamp literal is preceded by keyword TIMESTAMP and enclosed in apostrophes / single quotes:
TIMESTAMP '2012-11-30 12:34:56'
Or you can cast a characte... |