|15990||16 Jun 2010 @ 10:01 PDT||flash7gordon||Connectivity||Topic||teradata client install a no show in odbc||Hi,
We installed this teradata driver:
on a windows 2008 box. It's a 64 bit teradata driver. But when I go to add a System DSN in ODBC, none of... |
|15989||16 Jun 2010 @ 09:36 PDT||flash7gordon||Connectivity||Topic||what does the teradata client point to?||Hi,
I'm using the r13 client tools and they work fine on my laptop. But now I have to install the client tools/odbc/oledb on a server that are generic so I need to point at the internal te... |
|15988||16 Jun 2010 @ 08:38 PDT||Tnewbee||Database||Reply||Capture the data while updating a table||Thanks for ur reply!
I have added a flag which I will be setting whenever a record gets updated. In this way after all updates, I can use the flag to find the updated records. |
|15987||16 Jun 2010 @ 06:04 PDT||stuffie0912||Database||Reply||table size without indexes||Using the example above...(shown below)
Can I calculate total table size for all tables of a specific user?
select databasename, tablename, sum(currentperm)
where ... |
|15986||16 Jun 2010 @ 06:02 PDT||stuffie0912||Analytics||Topic||using dbc.tablesize, determine total tablesize for a specific user||Using TD SQL Assistant, how can I find the total size of all my tables I have created?
Just for my username.
What statistics are in dbc.tablesize?
will it collect tablesize info for tables... |
|15985||16 Jun 2010 @ 06:02 PDT||archer007||General||Reply||Primary Index Reducing Space||Thanks dnoeth for your reply. We didn't specify PI, so you may be right, first column would have been take as PI. Could you please explain little more about AMP distribution with the help of an exa... |
|15984||16 Jun 2010 @ 04:17 PDT||Adeel Chaudhry||Extensibility||Reply||External Store procedure to read a local client file||The process of "call parseFile('filename');" can be easily achieved using a combination of UDFs and SPs. UDFs for reading data from file and SPs for using that data and INSERTs/UPDATEs.
|15983||16 Jun 2010 @ 04:06 PDT||Adeel Chaudhry||Marketing & CRM||Reply||I need a MACRO that will allow the User to define the table||Can you please provide more details what exactly you are trying to achieve? |
|15982||16 Jun 2010 @ 04:05 PDT||Adeel Chaudhry||Marketing & CRM||Reply||C++ compiler||Teradata requires C++ compiler .... the question of "what compiler" depends on the answer of "what OS".
You can get the list of supported OS and C++ compiler from help/support.
|15981||16 Jun 2010 @ 04:00 PDT||Adeel Chaudhry||Analytics||Reply||Need help on logic!||Hi,
What is "Tasks" column in second table?
Can you provide 1 detailed example of what are the inputs and what exactly are you trying to achieve?
|15980||16 Jun 2010 @ 03:45 PDT||Adeel Chaudhry||Database||Reply||Capture the data while updating a table||Hi,
Triggers would be your best bet .... but as you mentioned you are not allowed to use them .... can you share some UPDATE statements to clear the overall picture?
|15979||16 Jun 2010 @ 03:42 PDT||Adeel Chaudhry||General||Reply||Problem with Extented Ascii data||Hi,
Can you please mention from which tool you are trying to read data?
|15978||15 Jun 2010 @ 11:13 PDT||Chandoo||Training||Reply||Want Teradata SQL Tutorial||Hi
Request to all. currently I am wokring in DB2. I am learning teradata. Kindly forward teradata SQl material. please.
My mail id : firstname.lastname@example.org
Thanks in advance. |
|15977||15 Jun 2010 @ 10:54 PDT||dnoeth||General||Reply||Primary Index Reducing Space||Was it really a NOPI-table in TD13 defined with NO PRIMARY INDEX or did you just omit the PI definition?
What does a SHOW TABLE return?
If it actually was a NOPI table then there migth have be... |
|15976||15 Jun 2010 @ 08:45 PDT||archer007||General||Topic||Primary Index Reducing Space||Hi,
I did the following
1) First, I fastloaded a flat file [Record count: 184368033 ] in to a table [Table column length: 231] that does not have primary index. After loading 1/6th of the fil... |
|15975||15 Jun 2010 @ 04:39 PDT||Jim Chapman||Database||Reply||length of the string||Use the standard SQL function CHARACTER_LENGTH. |
|15974||15 Jun 2010 @ 04:20 PDT||tparvaiz||Database||Topic||length of the string||Hi I want to know how to do something like this in teradata
(case when LENGHT(a.address) > 5 then a.address else a.other_address end)
If the lenght of the address is greater than 5 characters... |
|15973||15 Jun 2010 @ 12:52 PDT||l.k||Database||Reply||Incremental / Differential backup in Teradata...||Hi pawan,
How to enable AFTER permanent journaling at database level and table level? |
|15972||15 Jun 2010 @ 11:54 PDT||nwojack||Jobs||Reply||Certified Teradata DBA - Richmond, VA - 12 month contract||Email your resume to me - email@example.com |
|15971||15 Jun 2010 @ 11:53 PDT||nwojack||Jobs||Topic||Certified Teradata DBA - Richmond, VA - 12 month contract||This position is for a senior level database administrator, preferably Teradata administrator, who is responsible for design, development and administration of large scale (500Gb - 2TB in size) ana... |
|15970||15 Jun 2010 @ 11:04 PDT||Tnewbee||Database||Reply||Capture the data while updating a table||Anyobody with any suggestions?
BTW, we are not allowed to use a trigger or stored procedure. |
|15969||15 Jun 2010 @ 10:34 PDT||nambiaruveetil||Database||Topic||Identifying BTEQ Name from Querylog||Problem statement -
We need a process to tie the Querylog to the BTEQ ? Is there some option in Teradata to capture the BTEQ Name from Query Log. ? Can we use PROCID or is there any other option ? |
|15968||15 Jun 2010 @ 09:19 PDT||Tnewbee||Database||Topic||Capture the data while updating a table||Hi all!
I have a sequence of update queries on a very huge table TableA. Now when it updates the table I want to capture all the primary key of the records getting updated. This primary key will... |
|15967||15 Jun 2010 @ 08:25 PDT||dnoeth||Database||Reply||Mulitple Row values into a sinlge Column...||Two ways to achieve that result set:
select paycode1 from tab where paycode1 ''
select paycode2 from tab where paycode2 ''
or a Cross Join to a helper table:
|15966||15 Jun 2010 @ 07:34 PDT||l.k||Database||Topic||Mulitple Row values into a sinlge Column...||Hi,
I have a scenario to combine all the column's value in a single column.For example,we have 5 columns like Pay_code1,Pay_code2,Pay_code3,Pay_code4 and Pay_code5.Each column will contain val... |