All forum activity

#DateUserForumTypeThreadPost
4296728 Jul 2014 @ 09:37 PDTRaja_KTAnalyticsReplyGenerate a automated Nested CASE STATEMENT using entries from a tableI think you are looking for an opportunity to automate the process. I see people get faster response by showing sample , this is what I have and this is the output required. The sentence hiera...
4296628 Jul 2014 @ 08:50 PDTRaja_KTDatabaseReplyPartition integer date key by monthI  was about to comment on posting_dt_key integer declaration in partition. I think you  may have something in mind about it when you made it integer, since you know the end reqt and data...
4296528 Jul 2014 @ 07:07 PDTfeinholzToolsReplyTPT in Red Hat Linux - Dumping core We do not normally test with client boxes in a cluster. We are trying to emulate the environment to see if we can duplicate the issue.  
4296428 Jul 2014 @ 05:14 PDTgoldminerDatabaseReplyPartition integer date key by monthThank you... yes I did try that but was concerned about the partition being used if a cast is made.  Guess there is only one way to find out.  I will cast as a date and then see if I can ...
4296328 Jul 2014 @ 02:12 PDTeejimkosDatabaseReplyMvc Compression and Collect Stats on TD 14Hi, Can i ask oone more thing about sample stats. I can identify directly the columns where i can have sample on three approaches , 1) from comparing the uniquevaluecount to rowcount from dbc....
4296228 Jul 2014 @ 01:50 PDTAshwin4teraDatabaseReplyAvoid Product Join StepHi Dieter, The actual rows are not in that range. And the stats on columns CLIENT_NBR and POP_ID are up to date. Here are the steps for spool 26 and 27. Spool 26:    2) We do a group-...
4296128 Jul 2014 @ 01:40 PDTmanmariramaAnalyticsTopicGenerate a automated Nested CASE STATEMENT using entries from a table I have a situation where i am trying to automate a BTEQ script where it has 100ds of conditional statements like  CASE WHEN WHEN CASE WHEN  WHEN CASE WHEN  ...
4296028 Jul 2014 @ 12:31 PDTkrishaneeshDatabaseReplyhexadecimal--->decimal Select '28E1',((((((Index('0123456789abcdef',Substr('28E1',         1,1)) -1) * 16 ) + ((Index('0123456789abcdef',Substr('2...
4295928 Jul 2014 @ 11:51 PDTRaja_KTTeradata ApplicationsReplyEasyloader data transfer issueI am not pretty sure. My guess is the length behaviour of tpt. Did you try increasing the length in schema, maybe 3 times. I m not sure. I remember vaguely about this discussion. It maybe wrong. ...
4295828 Jul 2014 @ 11:20 PDTRaja_KTDatabaseReplyhelp with SQLA quick look at the data it can be thus. select distinct max(case when id is null then 0 else id end) over (partition by id,dt order by id,dt), max(case when dt is null then 0 else dt end) over ...
4295728 Jul 2014 @ 11:11 PDTkrishaneeshDatabaseReplyhelp with SQLWill the COL2, COL3 and COL4 be having multiple values or only a single repetitive value like 75211 mentioned in the example 2. if so the qury given be Glass will work.
4295628 Jul 2014 @ 10:56 PDTGlassDatabaseReplyhelp with SQLsel col1,ts,max(col2),max(col3),max(col4),sum(col5) group by 1,2; note: Max includes only no-null values
4295528 Jul 2014 @ 10:47 PDTRaja_KTDatabaseReplyIdentify Set - Multiset Tables in TD 14In td mode, it will be set table. If you want to change to multiset by default, then it has to be changed to ANSI mode. You may need to MODIFY in dbs control settings in GENERAL , if my memory does...
4295428 Jul 2014 @ 10:45 PDTkrishaneeshDatabaseReplyComplex SQL ScenarioAre the ID's constant, i mean are the rules set based on ID column. is Rule 1 fixed for ID=1 etc..
4295328 Jul 2014 @ 10:25 PDTkrishaneeshDatabaseReplyTotal Quantity of Items Sold per Month@Kartheek, Teradata does not support RR format. Also the max timestamp allowed is timestamp(6). If you need to convert RR notation you need to cast that column in character and then add the century...
4295228 Jul 2014 @ 10:23 PDTtd_admirerDatabaseReplyhelp with SQLHi, Yes, you are right. I need to group on the first 2 columns (COL1 and TS). Also, another scenario to add   405273444339513690 2014-06-02 00:35:29    ?   &n...
4295128 Jul 2014 @ 10:13 PDTkrishaneeshDatabaseReplyNeed help on a case scenarioin Table1 how will you be able to identify that the 2nd row pertains to ID1 and 4th row to ID 2 or other ID. if you have the ID in 2nd row to be 1, then what you can do is a row number over date pa...
4295028 Jul 2014 @ 10:06 PDTNetFxConnectivityReplySending dataset(multiple rows and multiple columns ) from .net to teradata Yes, it is possible. Start with: http://msdn.microsoft.com/en-us/library/aadf8fk2(v=vs.110).aspx   http://developer.teradata.com/doc/connectivity/tdnetdp/15.00/webhelp/webframe.html#Adapte...
4294928 Jul 2014 @ 08:51 PDTcomptrtoy1DatabaseReplyDeclare and Set then Open and FetchDieter. I'm a newbie so just trying to make sure i dont miss anything. Nothing worse than a newbie talking about something they dont know, then insert foot in mouth. Trying to figure out what t...
4294828 Jul 2014 @ 08:42 PDTKishore_1DatabaseReplyHashBufferSizeSorry for the confusion.It is HashedBufSize
4294728 Jul 2014 @ 08:18 PDTGlassDatabaseReplyhelp with SQLWhat different grouping criteria? It looks like your grouping on the fier 2 columns. 
4294628 Jul 2014 @ 07:59 PDTCarlosALDatabaseReplyHashBufferSizeI think you're a little bit disoriented... HashBufferSize is a parameter that Oracle uses to reserve memory for the hash tables in the hash joins. Cheers. Carlos.
4294528 Jul 2014 @ 07:54 PDTtd_admirerDatabaseTopichelp with SQLHi Gurus, Could you please help me with the below SQL? I need to merge the columns from a few rows on the same table based on a different grouping criteria.   This is how the input data loo...
4294428 Jul 2014 @ 07:53 PDTROZIEJobsTopicworkAny job in richmond?
4294328 Jul 2014 @ 07:49 PDTabort_sessionDatabaseReplyESCAPE with Single Quote ?SEL * FROM   ....    WHERE C1 LIKE     '%''FOOD''%'   works now, thanks

Pages