#DateForumTypeThreadPost
32113 Nov 2008 @ 12:33 PSTAnalyticsReplyDynamic Cursor ForUsing "embedded SQL" in an external routine, you can DECLARE a cursor for a dynamic SQL statement that you PREPARE and DESCRIBE. Search for examples; details would be too lengthy to post here.It ma...
32012 Nov 2008 @ 03:31 PSTDatabaseReplyConvert string 13/10/1974 into 13-10-1974 formatI would have phrased it differently:BTEQ uses FIELD mode by default, which effectively causes an implicit CAST to VARCHAR using the FORMAT. But most client tools and drivers use RECORD mode, in whi...
31911 Nov 2008 @ 12:46 PSTDatabaseReplyproblem with importYour CAST does not specify a FORMAT, so Teradata will try to use 'YYYY-MM-DD' (which should always be the default for ANSIDATE, and in this case is also the column default that INTEGERDATE would us...
31806 Nov 2008 @ 11:14 PSTDatabaseReplydifference between version V2R6 and V2R12The Release Summary manual lists the differences between one release and the prior release.Get it at www.info.teradata.comFor TD12.0 http://www.info.teradata.com/eDownload.cfm?itemid=072600018 (And...
31730 Oct 2008 @ 11:28 PDTToolsReplyFast ExportThe behavior may have changed when all the drivers were restructured to use GSS for authentication; that was in TTU8.0 (which corresponds to your V2R6 observation).
31629 Oct 2008 @ 02:51 PDTDatabaseReplyDifference in DBQL Tables V2R6 and V2R12(Demo).In TD12.0 and later, the data dictionary tables store character strings in Unicode. The "new" views with the "V" or "VX" suffix access the information without conversion; for backward compatibility...
31527 Oct 2008 @ 12:15 PDTToolsReplysetting BTEQ Import attribute dynamicallyEXPORT a ".IMPORT" statement to a temp file and .RUN that, e.g..set format off.export report file=importcmd.txtSELECT '.IMPORT DATA FILE='||FILENAME (TITLE '') FROM CTLTBL;.export reset.run file=im...
31426 Oct 2008 @ 07:06 PDTDatabaseReplySQL vs Teradata SQLThat's a different construct called "scalar subquery" rather than "derived table expression". Teradata 13.0 supports scalar subqueries (without adding the correlation names). But in earlier version...
31326 Oct 2008 @ 02:22 PDTToolsReplyFast ExportThat's just how it works. Since this is only an issue when running "interactively", and longer term the move is toward single sign-on / directory-based authentication, I doubt Teradata will change ...
31226 Oct 2008 @ 01:31 PDTDatabaseReplySQL vs Teradata SQLThe "derived table expression" (nested query) itself and each expression in it must have a "correlation name" (even if you don't reference that name anywhere):select stu from ( select student as st...
31119 Oct 2008 @ 11:22 PDTUDAReplyAM PM in Current_timestampIt's 24-hour time by default. You can use FORMAT to display AM/PM indicator, e.g.cast(cast(current_timestamp(0) as format 'y4-mm-ddbhh:mi:ssbt') as char(22))
31018 Oct 2008 @ 02:42 PDTToolsReplyTPT 101The client-side code for the operators and the TPT framework / API is new, but the LOAD operator still uses the "FastLoad protocol" to communicate with the DBMS. So each instance of a LOAD operato...
30918 Oct 2008 @ 02:24 PDTConnectivityReplyCatalog ErrorBe sure you have installed proper TDICU and TeraGSS libraries also.
30818 Oct 2008 @ 02:20 PDTUDAReplyNeed help to create table through ms access 2007Check the help file regarding the "Custom Options" for MS Access compatibility at the bottom of the ODBC Configuration / Options / Advanced dialog.
30718 Oct 2008 @ 02:05 PDTToolsReplyArcmain HelpUnless you are migrating database DBC and dictionary contents as well as user data, RESTORE is only valid when directed to the same database on the same system. Use COPY instead.
30609 Oct 2008 @ 05:01 PDTDatabaseReplyelementary questionThis is users helping users, so it depends on how busy we all are...ROW_NUMBER has been available in Teradata for years.
30509 Oct 2008 @ 04:50 PDTUDAReplyOnline reference to OLAP functionality in Teradata SQLSELECT * FROM DBC.DBCINFO;
30409 Oct 2008 @ 04:49 PDTToolsReplyDate value nullTeradata can't decide which data type you intended as the result CASE WHEN ... THEN [VARCHAR] ELSE [DATE] ENDMake the datatypes match. For example:case when load_date is null then ' ' else CAST(lo...
30309 Oct 2008 @ 04:20 PDTConnectivityReplySupport of Teradata ODBC Driver for AIXYes. The 64-bit AIX OS supports applications running in 32-bit mode, and you can install the 32-bit ODBC driver.
30208 Oct 2008 @ 11:35 PDTConnectivityReplySupport of Teradata ODBC Driver for AIXThere are two separate drivers, one that can be called by applications running in 32-bit mode and one that can be called by applications running in 64-bit mode. Starting with TTU13.0, they are pack...
30107 Oct 2008 @ 11:38 PDTConnectivityReplySupport of Teradata ODBC Driver for AIXIf your ODBC application is running 32-bit mode (even if the server is running 64-bit AIX kernel) you would use a 32-bit driver; if your application is 64-bit, use the 64-bit version of the driver....
30005 Oct 2008 @ 12:16 PDTDatabaseReply2 dimensional CURSORsFor best performance, avoid CURSORs (which limit processing to one row at a time) and redesign your application to use SQL operations which can exploit the parallel nature of the Teradata database....
29904 Oct 2008 @ 11:26 PDTDatabaseReplyCrontab - MPRASThis isn't specific to MP-RAS. The UNIX cron command itself does not support that level of granularity, but you can have a cron entry for "every Sunday" and use conditional execution to achieve thi...
29825 Sep 2008 @ 04:19 PDTAnalyticsReplyHow to search for all % in a columnNot clear exactly what you intend, but perhaps this will help. Since '%' and '_' have special meaning in a LIKE clause, if you want to match those characters you must define and use an ESCAPE chara...
29711 Sep 2008 @ 12:50 PDTAnalyticsReplyHiding a column from outputOr if you don't mind using old-style Teradata extensions:SELECT CUST_ID,DTE_BIRTH,CASEWHEN (DATE-DTE_BIRTH)/365.25 (named AGE) < 18THEN 'Under 18'WHEN AGE BETWEEN 18 AND 65THEN 'Between 18 and 6...

Pages