#DateForumTypeThreadPost
47124 Apr 2013 @ 03:33 PDTDatabaseReplyThere 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....
47002 Apr 2013 @ 02:14 PDTToolsReplyFastExport Access Module ErrorPlease start a new thread for new questions. On mainframe, INFILE must specify a DDNAME not a dataset name.
46925 Mar 2013 @ 02:31 PDTToolsReplyTPT wizard 13.10 and LDAPYou 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 ...
46825 Mar 2013 @ 01:53 PDTDatabaseReplyMetadata information for a viewHELP COLUMN dbname.viewname.*;
46712 Mar 2013 @ 03:08 PDTToolsReplyDefine new DB2 ODBC data source on TD SQL Assistant 13.11The 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...
46611 Mar 2013 @ 12:24 PDTDatabaseReplyMigration of Special Characters of UNICODE to TERADATADo you export from SQL Server as UTF16? Did you specify "-c UTF16" option in the MLOAD invocation?
46506 Mar 2013 @ 03:07 PSTDatabaseReplyBTEQ 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...
46406 Mar 2013 @ 01:52 PSTDatabaseReplyMigration of Special Characters of UNICODE to TERADATAHow are you loading the data? What "client character set" is being used for that load?
46326 Feb 2013 @ 03:24 PSTDatabaseReplystring not terminated errorIs there a semicolon after the last apostrophe as well as before?
46223 Feb 2013 @ 01:54 PSTDatabaseReply Table VersionVersion indicates a change to structure (ALTER TABLE, ADD/DROP INDEX, etc.), not to content.
46109 Feb 2013 @ 01:17 PSTDatabaseReplyTop 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...
46007 Feb 2013 @ 08:22 PSTToolsReplyvery 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...
45907 Feb 2013 @ 08:17 PSTConnectivityReplyTeradata_ICULibrariesThe tdicu libraries support "internationalization" in client drivers.   http://en.wikipedia.org/wiki/International_Components_for_Unicode
45807 Feb 2013 @ 08:10 PSTGeneralReplySpool space issue while Inserting into TableAre 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 ...
45707 Feb 2013 @ 08:00 PSTTrainingReplyTERADATA CERTIFICATIONThe 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 ...
45607 Feb 2013 @ 07:32 PSTDatabaseReplyETL Process results in contention on Teradata tableIf 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...
45502 Feb 2013 @ 08:38 PSTGeneralReplyIs 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...
45417 Jan 2013 @ 03:05 PSTConnectivityReplyNeed Help with Teradata ODBC driver on Oracle/AIXBookmarked 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 ...
45311 Jan 2013 @ 10:19 PSTDatabaseReplyBTEQ 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...
45208 Jan 2013 @ 10:00 PSTDatabaseReplyTeradata Lock in Insert StatementNot 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...
45121 Dec 2012 @ 03:12 PSTDatabaseReplyVariable results from an sql statementInteresting 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 = ?'  ...
45007 Dec 2012 @ 05:32 PSTConnectivityReplyFirst 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...
44902 Dec 2012 @ 09:51 PSTAnalyticsReplyhashrow functionThe 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. ...
44801 Dec 2012 @ 05:33 PSTThird Party SoftwareReplyEntityDataSource date parameters with TeradataA 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 ...
44701 Dec 2012 @ 05:20 PSTThird Party SoftwareReplySSRS - querying TD using a VB expression via ODBCA 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...

Pages