#DateForumTypeThreadPost
57118 Jun 2014 @ 08:32 PDTDatabaseReplyLock OverrideYes. Assuming "with PI value" means "WHERE clause specifies values for all PI columns"
57017 Jun 2014 @ 02:22 PDTDatabaseReplyLock Override1. INSERT requires a WRITE lock (the request for ACCESS lock will be ignored) 2. INSERT VALUES should still be a RowHash lock; INSERT SELECT will be a Table lock. (Table locks will show up in the ...
56917 Jun 2014 @ 01:58 PDTGeneralReplyWant to calculate Lag value in Teradata.Use a "window aggregate function" with ORDER BY and ROWS clauses (and optionally PARTITION BY). Unlike SAS, there is no intrinsic order of rows; you must explicitly say how the ...
56812 Jun 2014 @ 02:19 PDTDatabaseReplyDiretct User Login Vs. Query banding.Query Banding in general just allows the client to pass additional information about the session to the database, which can be used for many purposes. Are you asking about the reserved ProxyUs...
56728 May 2014 @ 03:27 PDTTeradata ApplicationsReplyChange UPI columnIn general, you can't. (ALTER might be possible if the table is empty, depending on exactly what sort of change; but since you mention copying data, I assume the table is not empty.)
56628 May 2014 @ 03:19 PDTToolsReplyTPT - Format = text exampleUse "delimited" (even though there is only one column, so the delimiter does not actually appear in the input records). The "text" format is only used when all input fields hav...
56515 May 2014 @ 10:26 PDTDatabaseReplyVariables in a Cursor Standard SQL syntax; to include a single quote character within a string, enter two in a row. Note that these are all single quote / apostrophe (') characters, not the double q...
56415 May 2014 @ 09:31 PDTDatabaseReplyKnowing Teradata System TimeZoneHELP SESSION will display the current session time zone offset interval (hours/minutes). See also the documentation for the system-defined GetTimeZoneOffset UDF.
56314 May 2014 @ 03:06 PDTDatabaseReplyRecommend books about TeradataSimply storing data in a Teradata database doesn't magically turn it into an integrated Data Warehouse. Nor is it impossible to implement a Data Warehouse on a non-Teradata platform.&...
56214 May 2014 @ 02:36 PDTDatabaseReplyVariables in a CursorYou need to use the Dynamic SQL form of cursor, as documented in the "SQL Stored Procedures and Embedded SQL" manual, something like this:   Create procedure ABCD  (in V_WRKTB...
56114 May 2014 @ 08:33 PDTDatabaseReplycreating C UDF - issue with float outputAs detailed in the SQL External Routine Programming manual, a DECIMAL(38,6) maps to a "DECIMAL16" structure: typedef struct { unsigned int int1; unsigned int int2; unsigned int int...
56013 May 2014 @ 10:53 PDTDatabaseReplyIdentifying Temporal TablesOn a real Teradata system, this requires a change control and verification of entitlement. (Yes, it requires a restart.) Talk to your local Teradata sales and Customer Services team for assistance....
55913 May 2014 @ 10:40 PDTToolsReplySet columns width in BTEQNo, BTEQ report mode automatically determines column widths. There is no provision to set default width by type.
55805 May 2014 @ 04:33 PDTGeneralReplyIs it possible to access TD DB via ODBC connection with Teradata Studio? Teradata Studio uses JDBC, not ODBC.
55705 May 2014 @ 04:32 PDTToolsReplyBTEQ Batch Mode LogonIn BTEQ, "batch mode" means reading the LOGON command from a script file, and not from the keyboard. That has nothing to do with "Teradata mode" transaction semantics.
55605 May 2014 @ 03:20 PDTDatabaseReplyuser creationBuild a character string containing the DDL statement, then execute it as dynamic SQL.
55505 May 2014 @ 03:18 PDTDatabaseReplyINTERVAL SUBTRACTION FROM DATE FIELD IN WHERE CLAUSEThe interval itself must have a constant within the quotes, but you can multiply by an integer value: b.aging_days_cnt * INTERVAL '1' DAY.
55405 May 2014 @ 02:54 PDTConnectivityReplyTeradata] [100038] is there a timeout parameter?Yes, set the TdCommand.CommandTimeout property.
55316 Apr 2014 @ 12:55 PDTToolsReplyTPT10508: RDBMS error 2583 error in teradata tptYou will not be able to restart, complete, or back out the update at this point. You can use the RELEASE MLOAD statement to remove the lock, see the MultiLoad manual for details. Or drop and recr...
55216 Apr 2014 @ 12:42 PDTTeradata StudioReplyHow Do You Create A Teradata Database?Teradata Express is the database VM. Teradata Studio [Express] is the newer multi-platform Eclipse-based client tool. The TTU package contains the drivers, utilities, and "legacy" cl...
55104 Apr 2014 @ 10:15 PDTDatabaseReplyHow to cleanse non numeric characters from a field?You will need to distribute the executable file to all the nodes on the target system and change the EXTERNAL NAME string to indicate where the object resides. Download the UDF packaging tool from...
55004 Apr 2014 @ 08:12 PDTDatabaseReplyMERGE INTO and CONCATENATIONString truncation is not considered an error in Teradata mode. My guess is the concatenated string simply doesn't fit in the target column, which makes it appear as if no update is occurring.
54904 Apr 2014 @ 08:10 PDTDatabaseReplyIdentifying revoked roles from a UserYou will need to use Access Logging to record the REVOKE requests. See "BEGIN LOGGING" in the DDL manual.
54804 Apr 2014 @ 08:07 PDTConnectivityReplyExceute Stored Procedure from SSIS thru .NET Data Provider for Teradata 14.10 5510 errorCorresponding keyword for .NET provider is "Session Mode" instead of "TMODE".
54704 Apr 2014 @ 08:05 PDTGeneralReplyDefault Date Format - When Inserting from Date to Varchar Field Have you tried the SET SESSION DATEFORM for the session that compiles the SP?

Pages