| 58192 | 05 Jul 2016 @ 07:48 PDT | hagrdan | Database | Reply | Database per object type -- Best practice or over engineered? | I can tell you another downside. A mistake was made in database creation whereas not enough space was allocated for our VIEWS database, resulting in our view creation script failing. Th... |
| 58191 | 05 Jul 2016 @ 07:05 PDT | nealvenna | Database | Topic | regexp_similar '^.$' issues |
Hi
For data scrubbing I have lot of hard coded values in my code. I am trying to put those values in a table. One of the condition for this scrubbing is to find length of character and code ... |
| 58190 | 05 Jul 2016 @ 06:50 PDT | tomnolan | Connectivity | Reply | JDBC Fastload Error Tables | Generally speaking, there is no need for the JDBC FastLoad error tables to persist. The FastLoad error information is provided to your application as an exception chain.
Please remember th... |
| 58189 | 05 Jul 2016 @ 06:24 PDT | Dira | Database | Topic | Last access timestamp is not getting updated in Dbc.Indices | HI Team,
Last access timestamp is not getting updated in Dbc.Indices though objectusage is set to T as shown below and we are on 14.10.05.07.
Please help me on this...
... |
| 58188 | 05 Jul 2016 @ 05:29 PDT | kartaj | General | Reply | Update statment is getting failed | Thank you Dieter...:)
|
| 58187 | 05 Jul 2016 @ 01:22 PDT | lokmac | Database | Reply | Day Of Week or Week-Ending Function? |
SELECT TD_Day_of_Week(Date_Column) FROM Table1;
I think many people have overlooked Ashok's excellent suggestion above, so to reiterate, you can use the Day_of_Week function bundled with Ter... |
| 58186 | 05 Jul 2016 @ 12:23 PDT | kvz | Tools | Reply | <Internal Session> blocking users and causing deadlock |
We are getting blockings even in online backup. Blocking gets clear once the backup of that DB get completed.
Locks will be applied on DB level or Table level during online backups?
what... |
| 58185 | 05 Jul 2016 @ 12:17 PDT | kvz | Database | Reply | Online backup performance |
We are getting blockings even in online backup. Blocking gets clear once the backup of that DB get completed.
Locks will be applied on DB level or Table level during online backups?
what... |
| 58184 | 05 Jul 2016 @ 12:14 PDT | kvz | Tools | Reply | online archive feature in Teradata 13 | We are getting blockings even in online backup. Blocking gets clear once the backup of that DB get completed.
Locks will be applied on DB level or Table level during online backups?
what is ... |
| 58183 | 04 Jul 2016 @ 11:51 PDT | M.Saeed Khurram | General | Reply | Update statment is getting failed | Thank you Dieter. It is an addition to my knowledge as well :)
|
| 58182 | 04 Jul 2016 @ 06:41 PDT | gerald.waters | Database | Reply | Database per object type -- Best practice or over engineered? | I'd like to reiterate a part of your question:
Is "all views in a views DB, all procs in a procs DB, all data in a data DB, and DB names follow no pattern" really a Teradata best pra... |
| 58181 | 04 Jul 2016 @ 12:43 PDT | Cvinodh | Connectivity | Reply | JDBC Fastload Error Tables | both the fastload error tables are getting dropped as soon the JDBC fastload job completes. This happenes even when the error tables have error record entry. Is there a way with JDBC fastload to pe... |
| 58180 | 04 Jul 2016 @ 11:56 PDT | dnoeth | General | Reply | Update statment is getting failed | SAMPLE is not allowed in subqueries (probably because this might be a correlated subquery), but in Derived Tables:
UPDATE TABLE_NM SET EFF_STRT_DT = '2016-07-04'
WHERE EFF_END_DT = '... |
| 58179 | 04 Jul 2016 @ 11:15 PDT | kartaj | General | Reply | Update statment is getting failed | Thanks for your revert Khurram,
can you please suggest ,if there is any alternate way to write the update query (which reaches the above recuriment)
|
| 58178 | 04 Jul 2016 @ 11:00 PDT | M.Saeed Khurram | General | Reply | Update statment is getting failed | Hi,
It is very clear message, SAMPLE is not allowed in subquries. remove this sample caluse:
UPDATE TABLE_NM SET EFF_STRT_DT = '2016-07-04' WHERE EFF_END_DT = '9999-12-31... |
| 58177 | 04 Jul 2016 @ 10:45 PDT | kartaj | General | Topic | Update statment is getting failed | Hi team,
I was trying to update sample 100 active records with a specific date('2016-07-04'), But my query is getting failed...(i have tried using with qualify rank, even it was not ... |
| 58176 | 04 Jul 2016 @ 09:58 PDT | pietro.nardella | Database | Topic | TACTICAL QUERIES ON WINDOWS FUNCTION | Dear ATRs,
I have a "simple" view V made by a "driving" table T (250 Mln rows) and a "left table" L (220 Mln rows) with a window fu... |
| 58175 | 04 Jul 2016 @ 09:03 PDT | dev1987 | Database | Topic | Need help on writing teradata stored procedure | Hello All,
I have one simple requirement on writing stored procedure.Requirement is as follows.
create stored procedure xxxx(In load_type varchar(20),load_date date)
... |
| 58174 | 03 Jul 2016 @ 11:05 PDT | Noa_Shahak | Database | Reply | Manually generate create table | Hi Dieter,
Thanks for your quick replay :)
I'll explain my situation.
We're using Teradata 14.10 and currently changing some prod tables schema to columnar.
In order not to harm o... |
| 58173 | 03 Jul 2016 @ 08:47 PDT | dasthu | Database | Reply | How to call unix commands with in the BTEQ script? | how to connect teradata to informatica?
and unix to teradata?
|
| 58172 | 03 Jul 2016 @ 08:26 PDT | dnoeth | Database | Reply | Manually generate create table | Define "manually generate".
There's CREATE TABLE newtable AS existingtable..., which allows defining indexes.
Or SHOW TABLE and then edit.
|
| 58171 | 03 Jul 2016 @ 06:16 PDT | Noa_Shahak | Database | Topic | Manually generate create table |
Hi All,
I'm looking for a way to manually generate create table (as another table) script.
The output should be script because I need to edit it.
My f... |
| 58170 | 03 Jul 2016 @ 05:29 PDT | zszmigiero | Aster | Reply | INSERT undocumented syntax | My question was not described clearly.
Aster SQL mentions syntax
INSERT INTO table query;
my question is related to syntax:
INSERT INTO table (query);
Do exist any other undocumented syntaxes?... |
| 58169 | 03 Jul 2016 @ 02:20 PDT | SyedShah | Database | Topic | Calling a stored procedure from Teradata Rest API | Hi All,
I am trying to call a stored procedure from Teradata Rest API and i am unable to do so.
When i call a stored procedure like a normal SQL, it executes the procedure but does not displa... |
| 58168 | 03 Jul 2016 @ 12:49 PDT | zarina | General | Topic | cumulative sum and moving average | Hi All
I am new to teradata and looking for the teradata query for the below situation
query to retireve cumulative amount and moving average salary for each employee in the reporting per... |
