#DateForumTypeThreadPost
13726 Jul 2011 @ 12:56 PDTToolsReplySQL Assistant Insert null with Import of pipe delimited fileTake a look at NULLIF. HTH. Cheers. Carlos.
13626 Jul 2011 @ 12:50 PDTDatabaseReplyUDF's for column securityYou can do it easily using views. HTH. Cheers. Carlos.
13526 Jul 2011 @ 12:47 PDTDatabaseReplyTimeStamp value for every record inserted using ins/selectGrao: If you need unique values for the inserted rows you must use an IDENTITY COLUMN, not a TIMESTAMP. No one can be sure that there will be a unique inserted row per timestamp (even if this ...
13421 Jul 2011 @ 12:47 PDTDatabaseReplyBTEQ. On Error: ContinueNot sure about your question, because this is the BTEQ default behaviour unless you set MAXERROR or QUIT based on the ERRORLEVEL. HTH. Cheers. Carlos.
13312 Jul 2011 @ 08:44 PDTDatabaseReplymload for multiple tablesIf you must adhere to the 'format text' you may try this with the data you provided (not tested): .logtable banklog; .logon xxxx/abcd,xyz; .begin mload tables accounts,customer,trans workt...
13214 Jun 2011 @ 07:57 PDTDatabaseReplyWhat is the equivalent of oracle (+) = in Teradata in SQL(+) = is proprietary syntax for outer joins. You must rewrite those queries with ANSI SQL syntax. Cheers. Carlos.
13114 Jun 2011 @ 05:57 PDTDatabaseReplyWhat is the equivalent of oracle (+) = in Teradata in SQLRIGHT OUTER JOIN But the query doesn't seem to make much sense, (even in Oracle)... Cheers. Carlos.
13007 Jun 2011 @ 07:02 PDTDatabaseReplyCoverting INTEGER value to Date format Two ways: The obvious one: SELECT CAST(CAST(20000000+your_date AS CHAR(8)) AS DATE FORMAT 'YYYYMMDD'); F.Ex.: SELECT CAST(CAST(20000000+100221 AS CHAR(8)) AS DATE FORMAT 'YYYYMMDD'); ...
12927 May 2011 @ 02:22 PDTDatabaseReplyUse of ROWID within a Join IndexThe ROWID will link the join index rows to the base table rows (f. ex.: partial covering indexes). HTH. Cheers. Carlos.
12825 May 2011 @ 06:39 PDTDatabaseReplydate Take a look at FORMAT clause in the documentation. BTW: DATE is DATE is DATE, FORMAT only makes it appear the way you like... HTH. Cheers. Carlos.
12723 May 2011 @ 12:29 PDTDatabaseReplyTotal Sum of all columnsTake a look at WITH clause in the documentation. HTH Cheers. Carlos.
12613 May 2011 @ 05:42 PDTDatabaseReplyCreating a view that uses "WITH RECURSIVE" getting error 6926Teradata uses specific syntax for RECURSIVE VIEWS: "CREATE RECURSIVE VIEW rec_view (col1,col2…) AS..." You cannot simply wrap the WITH RECURSIVE query inside the CREATE/REPLACE VIEW AS... HTH....
12513 May 2011 @ 12:12 PDTCloud ComputingReplyTeradata Express for VMware Player - Growing Pains and Version RefreshJim: Agreed. Besides, if you want/need to configure the network, you'll surely need to use "vmnetcfg.exe" which is hidden inside “network.cab” in the VMWare Player installation file (at l...
12411 May 2011 @ 11:59 PDTCloud ComputingReplyTeradata Express for VMware Player - Growing Pains and Version RefreshJim: Since version 3.0 VMWare Player can build VM's. Cheers. Carlos.
12306 May 2011 @ 05:14 PDTToolsReplyProblem with FexpThis characters are the bytes that indicate the size of the VARCHARS following. CAST the columns to CHAR() in the SELECT statement in order to eliminate them. Cheers. Carlos.
12205 May 2011 @ 11:51 PDTDatabaseReplySelect records from previous week based on current date... WHERE WHATEVER_YOUR_DATE_IS >= DATE - 7 ??? Cheers. Carlos.
12105 May 2011 @ 11:49 PDTGeneralReplyHow to recovert Teradate Query from Windows StandbyJimm wrote: >> no Yes. You can use a time machine and go into the past 5 min before your laptop was closed. Then you take actions in order to avoid your laptop is closed. The problem with...
12003 May 2011 @ 06:17 PDTGeneralReplyCompression value Limit in TD12RTFM: "You cannot create a table if the expansion of its compression values exceeds the maximum size (8,192 characters) of the compressvaluelist column in the DBC.TVFields system table. As a ...
11926 Apr 2011 @ 12:05 PDTDatabaseReplyData Distribution SQLLook for SKEW FACTOR, and the query to show it... HTH. Cheers. Carlos.
11826 Apr 2011 @ 12:03 PDTDatabaseReplyTricky sql's I would do #1 with recursive query, and #2 using analytical function (rownumber, rank...). HTH. Cheers. Carlos
11725 Apr 2011 @ 08:00 PDTToolsReplyNamed Pipe with axsmod bteq export to fastloadI seem to recall that there are problems with cygwin and named pipes. Some time ago I developed several processes with named pipes that never worked on cygwin but worked like a charm on SuSE... ...
11620 Apr 2011 @ 01:43 PDTDatabaseReplyTricky sql's These sql's are far from being 'tricky'. At lest for a regular SQL developer. I feel the scent of some kind of homework... Anyway: 1.- Take a look at RECURSIVE QUERIES. 2.- Take a look at...
11518 Apr 2011 @ 08:02 PDTDatabaseReplyNumeric Overflow error in teredataCast as DECIMAL(required,10): BTEQ -- Enter your SQL request or BTEQ command: CREATE MULTISET TABLE my_db.test04 ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSU...
11405 Apr 2011 @ 12:10 PDTCloud ComputingReplyRunning Teradata VMware 12.0 1 TB edition on ESXiI've just installed the TD13.10 SLES on a WinXP with VMware Workstation 6 (where I had been running TD12 SLES) and to my surprise it cried out that the virtual machine was built on a newer VMware p...
11318 Mar 2011 @ 01:20 PDTGeneralReplyCall macro inside a macro based on some conditionUse SP's instead. BTW what part of "Do not post SQL or database questions here" in the General forum charter you don't understand? Cheers. Carlos.

Pages