All forum activity

#DateUserForumTypeThreadPost
4289125 Jul 2014 @ 12:35 PDTdeepak.tannaGeneralReplyMAX() OVER () function producing inconsistent resultsjust noticed, the expected results had a typo, pls use the below AGREEMENT_ID PDCR_ID OWNR_INSD_ORDER GOVT_ID INSD_GOVT_ID SCND_INSD_GOVT_ID 7475178 0000401450 1 123456789 123456789 ...
4289025 Jul 2014 @ 11:29 PDTdeepak.tannaGeneralTopicMAX() OVER () function producing inconsistent resultsHi experts, Have a SQL that goes something like this SEL AGREEMENT_ID , PDCR_ID , OWNR_INSD_ORDER , GOVT_ID , MAX(GOVT_ID) over (partition by AGREEMENT_ID, PDCR_ID rows between ...
4288925 Jul 2014 @ 10:38 PDTWB255000ToolsReplyTPT load failure - Please suggestHi Feinholz. Thanks you very much, I'll try using #5 version. On the Other Hands, I used "DataDirect 6.1 for SQL Server Wire Protocol" this is which appear in my ODBC Drivers L...
4288825 Jul 2014 @ 10:20 PDTgeethareddyDatabaseReplyAborting SessionVasu, RCVManager is CNS subsystem utility. You cannot invoke them via queries. Rather you can use Viewpoint Remote Console Utility OR use Cnsterm 6. > Cnsterm 6 start rcvmanager; rcmanager...
4288725 Jul 2014 @ 07:21 PDTdnoethToolsReplyTPT : Suppress or Redirect stdout/stderr logs"level of IO"? For a few lines? You're joking :-) if you don't want that output redirect to /dev/null
4288625 Jul 2014 @ 07:14 PDTdavid.craigDatabaseReplyProblem with Polish special characters in WHERE clauseThe Teradata ASCII client character set does not support Polish characters either. ASCII to the LATIN server character set is a passthrough translation which does not change any byte values. Becaus...
4288525 Jul 2014 @ 06:59 PDTGlassThird Party SoftwareReplySQL Assistant: Database Explorer: Tablenames in MixedCase ?The explorer window will display the tablenames the way they are defined in the databases. If you run Help database on your target you will see the same.
4288425 Jul 2014 @ 06:16 PDTGlassDatabaseReply6932 ERROR: Multiple With StatementsWhat version Did it run on successfully and what version are you on now. Also, please provide the query.   thnanks, Rglass
4288325 Jul 2014 @ 06:14 PDTCCSliceDatabaseTopic6932 ERROR: Multiple With StatementsHi, Does anyone have a fix for multiple WITH statements?  It seems that in Version 13 does not like this.    This is the error that I get:  SELECT Failed 6932: Multiple WI...
4288225 Jul 2014 @ 05:44 PDTdnoethDatabaseReplyProblem with Polish special characters in WHERE clauseLATIN can't store polish characters, you must use UNICODE and use UTF8 or UTF16 sessions. After inserting those polish characters in an ASCII session you should select them. You'll notice ...
4288125 Jul 2014 @ 05:41 PDTtaruntrehanToolsReplyTPT : Suppress or Redirect stdout/stderr logsHi, I was able to redirect to a log file using a standard redirect unix operator tbuild > xyz.log However, just wondering if TPT has some log tracel level implementation to prevent this level...
4288025 Jul 2014 @ 05:26 PDTadasiekDatabaseReplyProblem with Polish special characters in WHERE clausedavid, Thanks for the explanation. I'm using ASCII client character set and when I changed to UTF8 everything started to work OK with UNICODE column character set.
4287925 Jul 2014 @ 05:23 PDTadasiekDatabaseReplyProblem with Polish special characters in WHERE clausednoeth, All the CHAR and VARCHAR columns at this customer have LATIN character set. I inserted Polish characters into a LATIN column because the session character set was ASCII. When you change ...
4287825 Jul 2014 @ 05:02 PDTeejimkosDatabaseReplyMvc on aggregated ColumnsAfter some tests , the cpu decreased by 15%  on join indexes cases and it remains almost the same or less on direct agregations. Any thoughts? Has anyone make similar tests?  
4287725 Jul 2014 @ 04:41 PDTeejimkosDatabaseReplyIdentify Multicolumn Foreign key on TD 14 Hi,   Finally , i will conclude again , never work tired. Thank you all for your time and answers.   sel indexID ,childdb as DB_FK_ ,childtable as tbl_fk_ ,max(case whe...
4287625 Jul 2014 @ 04:32 PDTDominic77DatabaseReplyCommon Table Expressions (CTE) Hi Dieter Thanks a lot for your answer. I'm using now the workaround with the changed order of the CTEs. It works.... Even if the optimizer would re-use a prior spool result...the SQL code ne...
4287525 Jul 2014 @ 03:50 PDTtaruntrehanToolsTopicTPT : Suppress or Redirect stdout/stderr logsHi, I am using TPT to load an extract. The job is running fine but it prints a lot of statements to the stdout of unix. Example : Job end: Mon Jul 14 10:08:43 2014 Job start: Mon Jul 14 10:...
4287425 Jul 2014 @ 03:39 PDTaneesh_srConnectivityReplyTeradata jdbc driver upgrade from 13.00.00.07 to 15.00.00.15Hi Tom, Thanks for the quick response.
4287325 Jul 2014 @ 03:03 PDTdnoethToolsReplyIssues with loading date field using BTEQ script- when you define VARTEXT all fields must be defined as VARCHAR in USING - a FLOAT is a FLOAT and not a DATE
4287225 Jul 2014 @ 02:08 PDTdnoethDatabaseReplyerror in UPDATE statementHi Carlos, of course you're right :-) I didn't read your anwer before my post and also didn't notice the bad syntax.
4287125 Jul 2014 @ 01:45 PDTCarlosALDatabaseReplyerror in UPDATE statementDieter: I stick to my guns ;-) You cannot use table qualificator in the SET part of the update: "SET t1.TABLE_SIZE = t2.corrente -->  SET TABLE_SIZE = t2.corrente" C...
4287025 Jul 2014 @ 01:25 PDTdnoethDatabaseReplyIdentify Multicolumn Foreign key on TD 14It's an easy task to provide the info about multicolumn FKs using the dbc views as each column of a  multicolumns FK is stored as a row in those views (similar to dbc.IndicesV).
4286925 Jul 2014 @ 01:22 PDTdnoethDatabaseReplyDate_Insert_errorIt's like any other switch in database technology: Doing it on your own might be a big task, especially if you don't have expertise in the new DBMS. There's 3rd party software like Sw...
4286825 Jul 2014 @ 01:12 PDTeejimkosDatabaseReplyIdentify Multicolumn Foreign key on TD 14Hello, Thank you for your time and reply. I have seen this post , but i wanted to avoid this solution . There are system tables which keep the information of foreign key (parent - child ) but the...
4286725 Jul 2014 @ 12:21 PDTkartheek0DatabaseReplyDate_Insert_errorThnk you Dieter..And how can i move my oracel datbase tables to TD..

Pages