#DateForumTypeThreadPost
207812 Jul 2013 @ 01:45 PDTDatabaseReplywhat does panicloopdetected contain?/var/opt/teradata/tdtemp/PanicLoopDetected is an empty file. From the "Messages" manual:   13821 Crash loop detected during TPA initialization. Explanation: In order to pre...
207712 Jul 2013 @ 12:30 PDTDatabaseReplyHow to spell out numeric value in English words by select query.Hi Sai, "sp" in Oracle is only supported for DateTime, same in Teradata: SELECT TO_CHAR(CURRENT_DATE,'yyyysp'); *** Query completed. One row found. One column returned. ...
207611 Jul 2013 @ 09:40 PDTDatabaseReplyBTEQ syntax with CAST embedded in SUBSTRING functionI doubt it's working in SQLA, because you mix SUBSTR and SUBSTRING syntax, it's either SUBSTRING(CAST(' ' AS CHAR(8192)) FROM 1 FOR 256 ) or SUBSTR(CAST(' ' AS ...
207511 Jul 2013 @ 09:34 PDTDatabaseReplyInformation about Inverted list database  Hi Raja, could you please clarify your question? Inverted list = Full Text Index Set and row processing = any DBMS can do both   Dieter
207411 Jul 2013 @ 09:30 PDTDatabaseReplyusing a Timestamp value within a dynamic sql statementHi Bala, unless it's a different SP for every CALL you can simply pass the variables as parameters instead of Dynamic SQL: Call dbname.proc_name(v1,v2,v3,V4,V5,null,cast(v7 as varchar(24)))...
207311 Jul 2013 @ 09:16 PDTUDAReplyVARCHAR fieldsThere was a recent thread on VARCHARs: forums.teradata.com/forum/database/behavior-of-varchar-and-compressed-columns-in-spool   It's great when you actually start optimizing/thinking ab...
207211 Jul 2013 @ 09:05 PDTDatabaseReplyOCES-3 details-Hi Nishant, BMSMS: search for "nusi bit mapping" in the "Database Design" manual  OCES: there was an Orange Book a few years ago on this topic, in the "SQL REquest a...
207111 Jul 2013 @ 08:46 PDTToolsReplyReceiving Failure 2673 The source parcel length does not match data that was defined while importing using BTEQHi Manjunath.M, when you TRIM a CHAR(2) i changes to a VARCHAR(2). You can either remove the trim export using CAST(TRIM(state) AS CHAR(2)) or import using in_state ...
207011 Jul 2013 @ 02:43 PDTDatabaseReplyCall a procedure inside another using dynamic sql -Dynamic SQL doesn't support CALL. The only workaround is a huge CASE which list all CALLs to those different SPs.   Dieter
206911 Jul 2013 @ 02:36 PDTViewpointReplyMeaning of basic terms I see in ViewpointHi Raj, you can find all explanations in the Viewpoint User Guide :-) http://www.info.teradata.com/edownload.cfm?itemid=131020002   Dieter
206811 Jul 2013 @ 02:32 PDTDatabaseReplyExperiencing Challenges with TimeStamp in TeradataBoth conditions are not exactly the same. I assume those DATE_START/END_HIST columns are TIMESTAMPs (#2 should fail for DATEs). #1: Compares a TIMESTAMP to a DATE, resulting in the TIMESTAMP is i...
206711 Jul 2013 @ 12:50 PDTDatabaseReplySQL question?Simply write your condition into the RANK: qualify rank() over (partition by CAD.CUST_ACCT_KEY or whatever you need order by case WHEN RCVR_TYPE_DESC = ...
206610 Jul 2013 @ 02:27 PDTDatabaseReplyselected non-aggregate values must be part of the associated groupGROUP BY 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20 is aleady a shortcut :-) Most DBMSes require to explicitly list all column names instead of column numbers.   Dieter
206510 Jul 2013 @ 01:19 PDTDatabaseReplyselected non-aggregate values must be part of the associated groupYo're right, whenever there's an aggregation all other columns must be in GROUP BY. MySQL considers some bad practice as valid SQL, but all other DBMSes consider that illegal :-) What doe...
206410 Jul 2013 @ 01:13 PDTDatabaseReplyCross tab - PivotHi Raymond, what if number of tables increases and you finally hit the 2048 columns in a table limit :-) For me it would be much easier to compare those counts when they are rows in a table. &nb...
206310 Jul 2013 @ 01:09 PDTDatabaseReplyTeradata Hot-Back upHi Mahesh, what activity is allowed during an Online Backup depends on your release. An overview is found in Chapter 10: Archiving, Restoring, and Recovering DataT of the "Databasa Admi...
206210 Jul 2013 @ 01:01 PDTDatabaseReplySQL rewrite - Group byI just checked my query in SQLA and it only complained about the missing table :-) I would expect this error when there was a type in COUNT(*), better check your query.   Dieter
206110 Jul 2013 @ 12:57 PDTDatabaseReplyPerformance tuning for a tpump script-Hi Nishant, 7000 records in 1 hour? My TD Express should load that within a few seconds. Did you check if there were locks/deadlocks? Better use SERIALZE on the PI columns. Is the target table S...
206010 Jul 2013 @ 12:48 PDTDatabaseReplyHow to calculate space taken by a volatile table?Hi Nishant, Volatile Tables are stored within spool space, you can only SUM(CurremtSpool) to get the spool size of all current sessions of that user (of course including the spool in use due to an...
205910 Jul 2013 @ 08:38 PDTDatabaseReplyGet the count of rows in the respective tables using cursorsIf you need an exact count the only reliable way is to run a COUNT(*). If doesn't have to be exact, extracting it from stats uses no additional resources.     Dieter
205810 Jul 2013 @ 08:35 PDTTeradata StudioReplySQL results in Studio 14.2 don't match results from SQL Assistant 13.10Studio's uses ANSI sessions as default while SQLA uses the system's default (and this is usually Teradata mode): In ANSI mode any string literal is case specific, so  "databasena...
205710 Jul 2013 @ 07:49 PDTDatabaseReplyusing a Timestamp value within a dynamic sql statementHi Bala, you have to use an implicit typecast for a TIMSTAMP column: CAST(timestamp_variable as VARCHAR(24). But i doubt you can use dynamic SQL to CALL an SP.   Dieter
205610 Jul 2013 @ 07:43 PDTDatabaseReplyselected non-aggregate values must be part of the associated groupAhh, the well known 3504 error :-) You have to add GROUP BY 1 or GROUP BY vtiger_products.productcategory   Dieter
205510 Jul 2013 @ 07:42 PDTToolsReplyUsing FastLoad for Volatile TableA Volatile table only exists within the current session and automatically dropped at logoff. The VT is created by the FastLoad control session (i wonder why this doesn't fail) and then the Fas...
205410 Jul 2013 @ 02:04 PDTDatabaseReplyHow to get 2 value from same id and same column?How many rows into one column? Is there a know maximum? A typical solution might involve aggregation using MIN(CASE) or OLAP. Btw, if Cognos can't use recursion you can create a recursive vi...

Pages