|42891||25 Jul 2014 @ 12:35 PDT||deepak.tanna||General||Reply||MAX() OVER () function producing inconsistent results||just 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 ... |
|42890||25 Jul 2014 @ 11:29 PDT||deepak.tanna||General||Topic||MAX() OVER () function producing inconsistent results||Hi experts,
Have a SQL that goes something like this
, MAX(GOVT_ID) over (partition by AGREEMENT_ID, PDCR_ID rows between ... |
|42889||25 Jul 2014 @ 10:38 PDT||WB255000||Tools||Reply||TPT load failure - Please suggest||Hi 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... |
|42888||25 Jul 2014 @ 10:20 PDT||geethareddy||Database||Reply||Aborting Session||Vasu,
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
|42887||25 Jul 2014 @ 07:21 PDT||dnoeth||Tools||Reply||TPT : 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
|42886||25 Jul 2014 @ 07:14 PDT||david.craig||Database||Reply||Problem with Polish special characters in WHERE clause||The 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... |
|42885||25 Jul 2014 @ 06:59 PDT||Glass||Third Party Software||Reply||SQL 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.
|42884||25 Jul 2014 @ 06:16 PDT||Glass||Database||Reply||6932 ERROR: Multiple With Statements||What version Did it run on successfully and what version are you on now.
Also, please provide the query.
|42883||25 Jul 2014 @ 06:14 PDT||CCSlice||Database||Topic||6932 ERROR: Multiple With Statements||Hi,
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... |
|42882||25 Jul 2014 @ 05:44 PDT||dnoeth||Database||Reply||Problem with Polish special characters in WHERE clause||LATIN 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 ... |
|42881||25 Jul 2014 @ 05:41 PDT||taruntrehan||Tools||Reply||TPT : Suppress or Redirect stdout/stderr logs||Hi,
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... |
|42880||25 Jul 2014 @ 05:26 PDT||adasiek||Database||Reply||Problem with Polish special characters in WHERE clause||david,
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.
|42879||25 Jul 2014 @ 05:23 PDT||adasiek||Database||Reply||Problem with Polish special characters in WHERE clause||dnoeth,
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 ... |
|42878||25 Jul 2014 @ 05:02 PDT||eejimkos||Database||Reply||Mvc on aggregated Columns||After 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?
|42877||25 Jul 2014 @ 04:41 PDT||eejimkos||Database||Reply||Identify Multicolumn Foreign key on TD 14|| Hi,
Finally , i will conclude again , never work tired. Thank you all for your time and answers.
,childdb as DB_FK_
,childtable as tbl_fk_
,max(case whe... |
|42876||25 Jul 2014 @ 04:32 PDT||Dominic77||Database||Reply||Common 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... |
|42875||25 Jul 2014 @ 03:50 PDT||taruntrehan||Tools||Topic||TPT : Suppress or Redirect stdout/stderr logs||Hi,
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.
Job end: Mon Jul 14 10:08:43 2014
Job start: Mon Jul 14 10:... |
|42874||25 Jul 2014 @ 03:39 PDT||aneesh_sr||Connectivity||Reply||Teradata jdbc driver upgrade from 13.00.00.07 to 15.00.00.15||Hi Tom,
Thanks for the quick response.
|42873||25 Jul 2014 @ 03:03 PDT||dnoeth||Tools||Reply||Issues 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
|42872||25 Jul 2014 @ 02:08 PDT||dnoeth||Database||Reply||error in UPDATE statement||Hi Carlos,
of course you're right :-)
I didn't read your anwer before my post and also didn't notice the bad syntax.
|42871||25 Jul 2014 @ 01:45 PDT||CarlosAL||Database||Reply||error in UPDATE statement||Dieter:
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"
|42870||25 Jul 2014 @ 01:25 PDT||dnoeth||Database||Reply||Identify Multicolumn Foreign key on TD 14||It'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).
|42869||25 Jul 2014 @ 01:22 PDT||dnoeth||Database||Reply||Date_Insert_error||It'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... |
|42868||25 Jul 2014 @ 01:12 PDT||eejimkos||Database||Reply||Identify Multicolumn Foreign key on TD 14||Hello,
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... |
|42867||25 Jul 2014 @ 12:21 PDT||kartheek0||Database||Reply||Date_Insert_error||Thnk you Dieter..And how can i move my oracel datbase tables to TD..