| 57666 | 10 Jun 2016 @ 12:56 PDT | JustMe | Database | Reply | No spool space error,when running SP in BTEQ. | And how much spool is currently allocated to that User ID?
|
| 57665 | 10 Jun 2016 @ 12:48 PDT | JustMe | Database | Reply | No spool space error,when running SP in BTEQ. | What does your stored procedure do? Does it perform aggregation? Are you joining tables? have you run explains on the underlying code?
|
| 57664 | 10 Jun 2016 @ 10:16 PDT | tsalonia | Teradata Studio | Reply | Is there a way to modify Connection Properties of DB Connections through some external Windows config file? | ok, for option 1 above, each user may have a different name for a given connection to a particular server, since these names are customizable. how would we address this with a generic .xml fi... |
| 57663 | 10 Jun 2016 @ 09:59 PDT | fgrimmer | Teradata Studio | Reply | Is there a way to modify Connection Properties of DB Connections through some external Windows config file? | Yes, but it is encrypted.
|
| 57662 | 10 Jun 2016 @ 09:01 PDT | feinholz | Tools | Reply | TPT attributes SkipRows and SkipRowsEveryFile | No. You either skip the 'n' rows in one file or all.
|
| 57661 | 10 Jun 2016 @ 07:52 PDT | Gnome | Database | Reply | Calling Dnoeth your expert opinion is requried and a easy question. Please respond. | Next question from the user is it possible to set up customizable setting for spool per amp at the run time?
I suspect I know what the answer is.
Again
Thanks in advance
The Gno... |
| 57660 | 10 Jun 2016 @ 07:44 PDT | Gnome | Database | Reply | Calling Dnoeth your expert opinion is requried and a easy question. Please respond. | Thank you sir
|
| 57659 | 10 Jun 2016 @ 07:36 PDT | dnoeth | Database | Reply | Getting YYYYMMDDHH FORMAT | The simple way:
to_char(Start_Time, 'YYYYMMDDHH24')
|
| 57658 | 10 Jun 2016 @ 07:33 PDT | dnoeth | Database | Reply | Calling Dnoeth your expert opinion is requried and a easy question. Please respond. | You hopefully got the same answer three times:
Spool/Temp/Perm space is always divided by the number of AMPs in the system.
That's why you might need to assign a huge spool due to skewed proc... |
| 57657 | 10 Jun 2016 @ 07:04 PDT | Gnome | Database | Topic | Calling Dnoeth your expert opinion is requried and a easy question. Please respond. | Dieter
We have a simple question that but our user will only accept your reponse as being correct. The question is, is an profile's spool divided accross the total number of AMPS on a sy... |
| 57656 | 10 Jun 2016 @ 06:28 PDT | BRIANH | Database | Reply | DATE - 'SELECT DATE' RETURNS AN INCORRECT DATE | thank Johannes... resetting the linux date and time completed my fix. Thanks again for your advice.
|
| 57655 | 10 Jun 2016 @ 05:44 PDT | Surendhar Reddy | Training | Reply | Teradata 14 basics certification information | Thanks a lot Rakesh, the link you provided is very usefull and that PDF is very informative.
|
| 57654 | 10 Jun 2016 @ 05:44 PDT | tsalonia | Teradata Studio | Reply | Is there a way to modify Connection Properties of DB Connections through some external Windows config file? | Are these connection profiles stored in a file somewhere on the OS?
|
| 57653 | 10 Jun 2016 @ 04:58 PDT | omerf | Database | Topic | Getting YYYYMMDDHH FORMAT | Hi,
I have column which name is Start_Time and it includes '4/26/2016 18:14:57.000000' . i want to take 2016042618 output (YYYYMMDDHH). How can i get it ?
Thank you.
... |
| 57652 | 10 Jun 2016 @ 04:52 PDT | JustMe | Database | Reply | Unable to release locks | Thanks Fred...
We will perform our quarterly refresh later this month, so I know that will take care of it. Was just wondering if there was any other way.
Thanks agai... |
| 57651 | 10 Jun 2016 @ 04:35 PDT | eric_td | Database | Reply | TERADATA on Windows 10 | Hi,
Will Teradata Vmware edition work on Windows 10. It works fine on Win7.
I would be having intel i3/8GB RAM/ Win 10 64bit OS.
Would it work fine? Or would I need i5 processor
|
| 57650 | 10 Jun 2016 @ 04:15 PDT | keerthi1987 | Database | Reply | No spool space error,when running SP in BTEQ. | Hi ashok_paswan,
We have checked the skew factor for single customer table, we are getting below results,
T001_Test_Invoice_Raw
2482.03369140625
0.10... |
| 57649 | 10 Jun 2016 @ 03:46 PDT | Rajudeepak | Database | Reply | Copying trillions of data to new table | Hello,
Help me with a query to purge data from the below table. This table has 670,235,825,680 rows. I'm trying to delete around 164,154,526,390 rows using cal_dt column.
del from pr_us_inv.s... |
| 57648 | 10 Jun 2016 @ 12:01 PDT | Johannes Vink | Database | Reply | Seeing Junk character when inserting hyphen (-) | The utf-8 session recommendation I knew, but the detailed explanation why in this case it is going wrong... wow.
Beside that: don't query DBC.TABLES, but query DBC.TABLESV if available on your... |
| 57647 | 09 Jun 2016 @ 11:58 PDT | Johannes Vink | Database | Reply | DATE - 'SELECT DATE' RETURNS AN INCORRECT DATE | SELECT DATE returns the current date from the database/OS. I guess your VM date/time is not up-to-date...
|
| 57646 | 09 Jun 2016 @ 11:57 PDT | Johannes Vink | Database | Reply | Current date as column name in select query | Set the alias between double quotes: AS "CURRENT_DATE"
|
| 57645 | 09 Jun 2016 @ 10:42 PDT | AVOT | Viewpoint | Topic | Data Labs Installation Question | Hi all
I'm currently using Viewpoint 15.00.01.008 and TD DB: 15.00.03.01 and I am installing the tddatalabsportlets version v15.00.00.04-1.
1. I get the rpm file for tddat... |
| 57644 | 09 Jun 2016 @ 10:34 PDT | sneha.g | Tools | Reply | TPT attributes SkipRows and SkipRowsEveryFile | Thanks for clarifying Steve.
I have another question.
Let's say, there are 5 files and the files are loaded in serial order (i.e. it doesn't get loaded parallely). Out of 5 files, 2 files... |
| 57643 | 09 Jun 2016 @ 07:02 PDT | Vishnujp | Database | Topic | Current date as column name in select query | Hi All,
I need to set alias to a column name as current_date in the format (DDMMMYYYY) in a select query (Teradata version 14).
Eg: Select case when ... then
... |
| 57642 | 09 Jun 2016 @ 03:10 PDT | BRIANH | Database | Topic | DATE - 'SELECT DATE' RETURNS AN INCORRECT DATE | I'm running an old version -Teradata 13.0 under VMWare - Linux. I've had the issue of SELECT DATE; returning an incorrect date. I'm now attempting to correct this problem.
... |
